IBM Support

ANR9999D tbSQLExecuteToStrings with rc 1040 during normal operation

Troubleshooting


Problem

Receiving message ANR9999D tbSQLExecuteToStrings with rc 1040 during normal operation in Tivoli Storage Manager Server.

Symptom

During any administrative action (such as db backup, reclamation, migration etc), the following message may be reported in the activity log of the Tivoli Storage Manager Server:
ANR9999D_3146658462 tbSQLExecuteToStrings(tbnsql.c:1212) Thread<51>:
Unexpected Unexpected rc 1040 from tbSQLExecuteFetch.
ANR9999D Thread<51> issued message 9999 from:
ANR9999D Thread<51> 000007FEF8669839 OutDiagToCons()+159
ANR9999D Thread<51> 000007FEF86633BC outDiagfExt()+fc
ANR9999D Thread<51> 000007FEF83FE1FC tbSQLExecuteToStrings()+1ac
ANR9999D Thread<51> 000007FEF83FE426 RdbExecuteSQLToStrings()+e6
ANR9999D Thread<51> 000007FEF840FE76 tbReorgAddToLockWaitList()+1186
ANR9999D Thread<51> 000007FEF8417BFE RdbReorgHasForcedAppl()+57ae
ANR9999D Thread<51> 000007FEF8418AE6 RdbReorg()+76
ANR9999D Thread<51> 000007FEF83B5A30 RdbMonitorStatsThread()+270
ANR9999D Thread<51> 000007FEF7E56384 startThread()+124
ANR9999D Thread<51> 0000000074441D9F endthreadex()+43
ANR9999D Thread<51> 0000000074441E3B endthreadex()+df
ANR9999D Thread<51> 000000007721652D BaseThreadInitThunk()+d
ANR9999D Thread<51> 000000007734C541 RtlUserThreadStart()+21
ANR9999D_3044804774 RdbExecuteSQLToStrings(tbnsql.c:1384) Thread<51>: rc
1040 from tbSQLExecuteToStrings.

Cause

The error message may have multiple causes but mainly it can be a resource conflict or insufficient rights for the user that starts the Tivoli Storage Manager Server.

Resolving The Problem

For resolving the problem the Tivoli Storage Manager system administrator needs to check:

- If the user under which Tivoli Storage Manager and DB2 services are running (default tsminst1) is


member of the Windows groups ADMINISTRATORS, DB2ADMNS, and DB2USER


- If the DB2 reorganization process is not running concurrently with other administrative processes like db backup, reclamation, migration etc.
The Tivoli Storage Manager system administrator should set the DB2 reorganization process accordingly to the guidelines given in the following technote, and avoid to have it always running:
http://www-01.ibm.com/support/docview.wss?uid=swg21452146

Note: if the above actions do not solve the issue, the problem needs to be verified further and it may be necessary to involve Tivoli Support for deeper review and analysis.

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

Document Information

Modified date:
17 June 2018

UID

swg21676910