DB backup fails with ANR2983E, DB2 sqlcode -2033 sqlerrmc 137 after the server upgrade.

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:

ANR0424W Session # for node $$_TSMDBMGR_$$ (WIN) refused - invalid password submitted.
ANR2982E Database backup terminated due to environment or setup issue related to password - Db2 sqlcode -2033 sqlerrmc 137.

ANR1893E Process # for Database Backup completed with a completion state of FAILURE.

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.

For more details on 'Preparing the database manager for database backup', please click here.

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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Component":"Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1.6 and Higher","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Historical Number

TS003176891;TS003143020

Product Synonym

SP;ITSM;ADSM;TSM

Was this topic helpful?

Document Information

Modified date:
03 April 2020

UID

ibm11103451

Tips