Troubleshooting
Problem
When doing RESTORE DB of Tivoli Storage Manager Server database, ANR9999D and ANR0162W with SQL5193N may be displayed.
Symptom
dsmserv RESTORE DB command may fail with ANR9999D and ANR0162W messages.
>>>
"C:\Program Files\Tivoli\TSM\server\dsmserv" restore db
...
ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:nnnn) Thread<0>: Missing sqlSttate=42524, sqlCode=-5193 from table. Returning rc = 9994.
ANR9999D Thread<0> issued message 9999 from:
ANR9999D Thread<0> 000007FFBA110825 OutDiagToCons()+155
ANR9999D Thread<0> 000007FFBA10A75C outDiagfExt()+10c
ANR9999D Thread<0> 000007FFB9EA7930 ReportSQLDiagInfo()+2a0
ANR9999D Thread<0> 000007FFB9EA68F1 DbiEvalSQLOutcomeX()+4f1
ANR9999D Thread<0> 000007FFB9E95084 DbiExecuteOnConn()+1e4
ANR9999D Thread<0> 000007FFB9EABD3E RdbSetQryOptLevel()+6e
ANR9999D Thread<0> 000007FFB9E3456B RdbCreateConnection()+7cb
ANR9999D Thread<0> 000007FFB9E32AAD DbiGetConnectionTracked()+18d
ANR9999D Thread<0> 000007FFB9E1B53B dbiInitAfterRestore()+11b
ANR9999D Thread<0> 000007FFB9ECB6BB RestoreDbEndOp()+3b
ANR9999D Thread<0> 000007FFB9ECA304 RdbAdmRestoreDB()+be4
ANR9999D Thread<0> 000007FFB98E517A AdmRestoreDb()+cca
ANR9999D Thread<0> 000007FFB984C3CB admRestoreDatabase()+1db
ANR9999D Thread<0> 000007FFB9833294 RestoreDb()+104
ANR9999D Thread<0> 000007FFB983248C adsmMain()+13dc
ANR9999D Thread<0> 000007F6D73A110D main()+8d dsmserv.c:241
ANR9999D Thread<0> 000007F6D73A271B __tmainCRTStartup()+10f crtexe.c:536
ANR9999D Thread<0> 000007FFD3E71842 BaseThreadInitThunk()+1a
ANR9999D Thread<0> 000007FFD4A57509 RtlUserThreadStart()+21
ANR0162W Supplemental database diagnostic information: -1:42524:-5193 ([IBM][[CLI Driver][DB2/NT64] SQL5193N The current session user does not have usage privilege on any enabled workloads. SQLSTATE=42524).
<<<
Cause
The error might happen when you attempted to do RESTORE DB using the other user account than the instance user of Tivoli Storage Manger Server, such as Administrator, for example.
Environment
Tivoli Storage Manger Server 6.2, 6.3, 7.1 for Windows platform.
Diagnosing The Problem
In db2diag.log, AUTHID in the following records helps to determine by what user ID RESTORE DB was done.
>>>
YYYY-MM-DD-hh:mm:ss+sss ******** LEVEL: Info
PID : **** TID : **** PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.SERVER1.********
AUTHID : ADMINISTRATOR HOSTNAME: hostname
EDUID : **** EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:880
MESSAGE : Restore Complete.
<<<
Resolving The Problem
Logon by the instance user account, then do RESTORE DB.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21677776