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.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21982516