APAR status
Closed as program error.
Error description
After a successful Tivoli Storage Manager installation or upgrade to version 6.3.0.0 the DB2 start is failing with this message: db2start The service has returned a service-specific error code. SQL1042C An unexpected system error occurred. SQLSTATE=58004 Also starting the Tivoli Storage Manager server, the following message is raised: c:\Program Files\Tivoli\TSM\server\dsmserv.exe ANR7800I DSMSERV generated at 12:47:17 on Oct 10 2011. Tivoli Storage Manager for Windows Version 6, Release 3, Level 0.0 ANR0900I Processing options file D:\tsm\at05\instance\dsmserv.opt. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR1380I The buffer pool monitor switch is enabled. ANR1383I Memory usage by the database manager is limited to 13102MB. ANR0237E Fail to start the database manager. An unexpected system error occurred. ANR0172I rdbdb.c(1590): Error encountered performing action InstanceStop. ANR0162W Supplemental database diagnostic information: -1032:SQLSTATE 57019: The statement was not successful, because of a problem with a resource. :-1032 (SQL1032N No start database manager command was issued. SQLSTATE=57019 DB2DIAG.LOG reports such kind of error messages: 2011-10-21-13.32.48.870000+120 I168518F1215 LEVEL: Error PID : 840 TID : 10276 PROC : db2syscs.exe INSTANCE: XXXX NODE : 000 EDUID : 10276 EDUNAME: db2sysc FUNCTION: DB2 Common, Security, Users and Groups, secLoadServerAuthPlugin, probe:5 MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD Cannot load the specified library CALLED : DB2 Common, OSSe, OSSHLibrary::load RETCODE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD Cannot load the specified library DATA #1 : String, 97 bytes Error loading plugin library C:\PROGRA~1\Tivoli\TSM\db2\security\plugin\IBM\server\dsmdb2pw64 .dll CALLSTCK: [0] 0x00000001801256AC pdOSSeLoggingCallback + 0x13A [1] 0x00000000005DC0C2 ossLog + 0x174 [2] 0x00000000005DBF45 ossLogRC + 0xFD [3] 0x00000000021E8C66 secLoadServerAuthPlugin + 0xD4 [4] 0x00000000021E2806 sqlexLoadAllPluginsServer + 0xC3A [5] 0x0000000002FD74F1 sqloRunInstance + 0x2F3 [6] 0x0000000140006DC1 0x0000000140006DC1 + 0x0 [7] 0x000000014000154C 0x000000014000154C + 0x0 [8] 0x000000007706652D BaseThreadInitThunk + 0xD [9] 0x000000007729C521 RtlUserThreadStart + 0x21 2011-10-21-13.32.48.948000+120 I169735F440 LEVEL: Severe PID : 840 TID : 10276 PROC : db2syscs.exe INSTANCE: XXXX NODE : 000 EDUID : 10276 EDUNAME: db2sysc FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:356 MESSAGE : ZRC=0x805C018F=-2141453937=SQLEX_PLGN_SRV_PLGN_UNEXPECTED_ERROR "Server security plugin encountered an unexpected error" The problem is caused by dsmdb2pw does not locate gskit libraries. The issue does not occur on USA English locale. Customer/L2 Diagnostics: a DBADM DBCONN server trace will show: ========================= BEGIN TRACE ======================= 08:58:01.451 [0][trace.c][1668][TrBegin]:TRACE to file E:\tsmservertrace.txt started. 08:58:01.452 [0][trace.c][1670][TrBegin]: --> Active Trace Classes: DBCONN, DBADM, ADDMSG 08:58:01.452 [0][trace.c][1761][TrBegin]: Optimized 6.3.0.0 TSM Server (Driver 0000, Build 01283.1247) etc.. 08:58:02.404 [0][rdbinst.c][2183][SetupSecurityPlugin]:Invoking psCopyPluginToInstance 08:58:02.404 [0][psdb2sec.c][423][psCopyPluginToInstance]:Entering for instance AT04 08:58:02.404 [0][psdb2sec.c][445][psCopyPluginToInstance]:baseDir is C:\Program Files\Tivoli\TSM\ 08:58:02.404 [0][psdb2sec.c][465][psCopyPluginToInstance]:Calling stat for target file C:\Program Files\Tivoli\TSM\db2\security\plugin\IBM\server\dsmdb2pw64.dll 08:58:02.404 [0][psdb2sec.c][473][psCopyPluginToInstance]:Target file exists of size 17408, time 1319783100 08:58:02.405 [0][psdb2sec.c][505][psCopyPluginToInstance]:Calling stat for source file C:\Program Files\Tivoli\TSM\server\dsmdb2pw64.dll 08:58:02.405 [0][psdb2sec.c][513][psCopyPluginToInstance]:Source file exists of size 17408, time 1319783100 08:58:02.405 [0][psdb2sec.c][639][psCopyPluginToInstance]:Exiting, rc 0 08:58:02.405 [0][rdbinst.c][2221][SetupSecurityPlugin]:Setting DBM CFG SRVCON_PW_PLUGIN to "" 08:58:02.406 [0][rdbdb.c][5566][RdbCfgGet]:RC 0, sqlcode 0 getting delayed DBM CFG parm (SRVCON_PW_PLUGIN) 08:58:02.406 [0][rdbinst.c][2261][SetupSecurityPlugin]:Exit, rc 0 08:58:02.406 [0][psdb2sec.c][139][psGenerateAndStorePWDigest]:Entering for instance AT04, dbName TSMDB1 08:58:02.406 [0][psdb2sec.c][273][psGenerateAndStorePWDigest]:Exiting, rc 0 09:03:07.401 [0][rdbinst.c][1294][RdbStartInstance]:Failure -1042 starting instance. 09:03:08.472 [0][rdbinst.c][1294][RdbStartInstance]:Failure -1042 starting instance. 09:03:08.472 [0][rdbinst.c][1301][RdbStartInstance]:DbStartInstance: Exit (rc = 9990). 09:03:08.472 [0][dbiinit.c][1092][dbiInit]:Exiting with rc 9990. 09:03:10.490 [0][dbiconn.c][829][DbiReleaseAll]:Close connections on 0 DB2 pools. 09:03:10.490 [0][dbiconn.c][914][DbiReleaseAll]:Exit with rc 0, 0 connections released. 09:03:10.490 [0][rdbdb.c][1548][RdbDeactivateDatabase]:Got rc 0 from DbiReleaseAll - attempting unconditional deactivate. 09:03:10.498 [0][rdbinst.c][1328][RdbStopInstance]:Entry. 09:03:10.588 [0][rdbinst.c][1353][RdbStopInstance]:Exit (sqlcode = -1032). 09:03:10.642 [0][dbiinit.c][1124][dbiInit]:Stopping DB2 returned 999= ========================= END TRACE ======================= Tivoli Storage Manager Versions Affected: 6.3.0.0 Initial Impact: Medium Additional Keywords: TSM SERVER dsmdb2pw64.dll zz63
Local fix
check that the system environment variable "path" includes c:\program files\ibm\gsk8\lib64 . If not please add it to the path and reboot the machine.
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in level 6.3.1.0. Note that this is * * subject to change at the discretion of IBM * **************************************************************** *
Problem conclusion
This problem was fixed. Affected platforms: Windows.
Temporary fix
Comments
APAR Information
APAR number
IC79766
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-11-14
Closed date
2012-01-06
Last modified date
2012-01-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TSM SERVER
Fixed component ID
5698ISMSV
Applicable component levels
R63W PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
06 January 2012