Troubleshooting
Problem
The db2adutl tool fails to query the IBM Spectrum Protect server backups with return code 137. Code 137 means incorrect password.
This error can also be seen on a DB restore with the following message:
"ANR2969E Database restore terminated. Db2 sqlcode: -2033. Db2 sqlerrmc: 137."
Symptom
db2adutl query db sample
Error: Initialize session failed with TSM return code 137
Error: Initialize session failed with TSM return code 137
Cause
A DB2 bug was introduced at DB2 9.7-FP7. The database configuration contains a nonempty "TSM_PASSWORD" value.
Environment
The DB2 bug was introduced at DB2 9.7-FP7 with any supported Tivoli Storage Manager levels. The DB restore failure was seen with IBM Spectrum Protect 8.1.
Diagnosing The Problem
The IBM Spectrum Protect option "passwordaccess" prompt is used and the DB2 option "TSM_PASSWORD" is set to a value. To find this value, do the following steps:
Log on as instance user and use the following command to display the value of the DB2 option "TSM_PASSWORD":
db2 get db cfg for tsmdb1|grep TSM_PASSWORD
db2 get db cfg for tsmdb1|grep TSM_PASSWORD
(note:tsmdb1 is the default dbname - if the dbname is not the default then change to your dbname )
The output looks like the following:
TSM password (TSM_PASSWORD) = *****
The asterisks indicate that the password is not empty.
Resolving The Problem
This problem is covered by DB2 APAR IC89423.
The local fix for a failing db2adutl query is to specify the password with the query:
db2adutl query db tsmdb1 PASSWORD <password>
The local fix for a failing DB Restore is to remove the TSM_PASSWORD value:
"db2 update db cfg for tsmdb1 using TSM_PASSWORD NULL"
"db2 update db cfg for tsmdb1 using TSM_PASSWORD NULL"
Related Information
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Client","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Product Synonym
TSM;ITSM;ADSM;SP;
Was this topic helpful?
Document Information
Modified date:
20 October 2021
UID
swg21622652