IBM Support

DB2 database backup failed with error SQL2033N and TSM reason code: "400"

Technote (troubleshooting)


Problem(Abstract)

A DB2 database backup fails with the following error :
SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "400"

Symptom

Execute the following command to backup a db2 database:


db2 backup database DBNAME online use tsm open 1 sessions parallelism 2

The command fails with the following error:

SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "400"


Cause

Incorrect entries in the client options file.
The reason code "400" or "DSM_RC_INVALID_OPT " has the following explanation and response text :

Explanation:
An invalid option was found.

User Response:
Verify the options in dsm.opt, dsm.sys, and the options string. Check the error log for more details about the error.


Diagnosing the problem

Verify the dsm.opt file used by the DB2 backup. In this case, the file contained the following options :


#TRACEFILE /tmp/trace.out
#TRACEFLAGS service

The "#" character is an incorrect character to comment a line and causes invalid options error during backup.
To comment out an option, insert an asterisk (*) as the first character on the line that you want to comment out.


Resolving the problem

Modify the dsm.opt to use the "*" character instead of the "#" character to comment out a line. For example :


*TRACEFILE /tmp/trace.out
*TRACEFLAGS service

Re-run the DB2 backup after the change.

Document information

More support for: IBM Spectrum Protect
Client

Software version: 7.1.3, 7.1.4, 7.1.5

Operating system(s): Platform Independent

Reference #: 1982516

Modified date: 03 May 2016