Troubleshooting
Problem
After server upgrade to version 8.1.6 or higher on Windows, 'BACKUP DB' command may fail with the error
message ANR2983E, DB2 sqlcode -2033 sqlerrmc 137
Symptom
Activity log shows:
ANR2982E Database backup terminated due to environment or setup issue related to password - Db2 sqlcode -2033 sqlerrmc 137.
Cause
API return code 137 means "authentication failure" and happens because IBM Spectrum Protect servers starting
with 8.1.6, no longer require "PASSWORDACCESS generate" for the API backup node to connect to the server on
Windows systems.
Resolving The Problem
- Manually remove the option "passwordaccess generate" from the API client options file "dsm.opt" and retry the Backup DB command.
By default, the API client options file is named dsm.opt and is located in a subdirectory that has the same name as the database instance. The subdirectory is located in the Db2 instance directory path that is returned when the below command is issued:
db2set -i tsminst1 db2instprof
For example, if your database instance name is tsminst1 and your Db2 instance directory is c:\programdata\ibm\db2\db2tsm1, the client options file is stored at the following location:
c:\programdata\ibm\db2\db2tsm1\tsminst1\dsm.opt
Document Location
Worldwide
Historical Number
TS003176891;TS003143020
Product Synonym
SP;ITSM;ADSM;TSM
Was this topic helpful?
Document Information
Modified date:
03 April 2020
UID
ibm11103451