IBM Support

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

Troubleshooting


Problem

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.

[{"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Client","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.3;7.1.4;7.1.5","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21982516