IBM Support

Server starts up failed with error "SQL1042C An unexpected system error occurred. SQLSTATE=58004 ".

Troubleshooting


Problem

Server starts up failed , receiving error :"SQL1042C An unexpected system error occurred. SQLSTATE=58004 "

Symptom

Starting Server in for-ground, the starts up failed with the following msg:


ANR0990I Server restart-recovery in progress.
ANR0152I Database manager successfully started.
ANR0162W Supplemental database diagnostic information:
-1:HY000:-1042
([IBM][CLI Driver][DB2/NT64]
SQL1042C An unexpected system error occurred. SQLSTATE=58004 ).
ANR9999D_3146658462 tbSQLExecuteToStrings(tbnsql.c:1263) Thread<0>:
Unexpected rc 9999 from tbSQLExecuteFetch.
ANR9999D Thread<0> issued message 9999 from:
ANR9999D Thread<0> 00007FFBD9B07035 OutDiagToCons()+155
ANR9999D Thread<0> 00007FFBD9B00F6C outDiagfExt()+10c
ANR9999D Thread<0> 00007FFBD9883A1D tbSQLExecuteToStrings()+1ad
ANR9999D Thread<0> 00007FFBD98AE7AC GetDB2LevelStr()+16c
ANR9999D Thread<0> 00007FFBD98A7C77 RdbCrossCheckDb2Level()+97
ANR9999D Thread<0> 00007FFBD98065B8 dbiInit()+4b8
ANR9999D Thread<0> 00007FFBD91F090C StartServer()+2bc
ANR9999D Thread<0> 00007FFBD91EC1DF admStartServer()+ff
ANR9999D Thread<0> 00007FFBD91D23FF adsmMain()+134f
ANR9999D Thread<0> 00007FF63FCE110D main()+8d dsmserv.c:241
ANR9999D Thread<0> 00007FF63FCE271B __tmainCRTStartup()+10f crtexe.c:536
ANR9999D Thread<0> 00007FFBF88C13D2 BaseThreadInitThunk()+22
ANR9999D Thread<0> 00007FFBF9C3E954 RtlUserThreadStart()+34
ANR9999D_3325034490 GetDB2LevelStr(rdbdb.c:8412) Thread<0>:
Rc 9999 from tbSQLExecuteToStrings for SELECT SERVICE_LEVEL
FROM SYSIBMADM.ENV_INST_INFO.

Cause

Incorrect ownership of the DB2 install directory.

Environment

IBM Spectrum Protect Server

Diagnosing The Problem

1: Login as instance owner and execute db2start/db2 connect to tsmdb1, the command finished successful,

2: the following select failed:


db2 "select service_level from sysIBMADM.ENV_INST_INFO"

SQL1042C An unexpected system error occurred. SQLSTATE=58004


3: db2diag.log shows the FMP failed to start:

2016-02-05-10.08.08.610225-360 I5684E394 LEVEL: Severe
PID : 22316 TID : 47029220796736PROC : db2sysc 0
INSTANCE: pnb101 NODE : 000
EDUID : 207 EDUNAME: db2hinit 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMLNCreateFmp, probe:20
DATA #1 : Hexdump, 4 bytes
0x00002AC5D7FFDA5C : EEFB FFFF ....

2016-02-05-10.08.08.612942-360 I6079E395 LEVEL: Error
PID : 22316 TID : 47029220796736PROC : db2sysc 0
INSTANCE: pnb101 NODE : 000
EDUID : 207 EDUNAME: db2hinit 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerAddFmpToPool, probe:40
DATA #1 : String, 30 bytes
Startup of FMP process failed.
DATA #2 : signed integer, 4 bytes
-1042


4:" ls -Ral /opt/tivoli/tsm/db2 " shows files and directories under DB2 install location incorrectly owned by instance owner.

Resolving The Problem

1: find a working instance ownership of "ls -Ral /opt/tivoli/tsm/db2"

.Correct the ownership according to the content of the working instance.

2: after the permission of /opt/tivoli/tsm/db2 is corrected, update the instance:

/opt/tivoli/tsm/db2/instance/db2iupdt instance_name

3: retry the server starts up

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21976369

Page Feedback