Home
Blog
About
Database administration
Operating systems
Development
Links
Following require login:
ScratchPad
Backup to TSM requires 3 environment variables. If one or more of these is not set, or set incorrectly you may see TSM Reason code 106.
In particular note:
See DB2 backup to TSM for more detail.
db2 => backup database sp1 online use tsm SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "106".
If TSM backup options are incorrectly specified then you may see TSM reason code 400.
Most likely place for options to be set is in dsm.opt but they can also be specified in the database parameter VENDOROPT.
db2 => backup database sp1 online use tsm SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "400".
One or more tablespaces have the BACKUP_IN_PROGRESS flag set.
This might happen if a backup is cancelled and then attempted in quick succession.
In this case patience is a virtue - DB2 will clear the flags given time (true for DB2 v9.7 FP2).
From db2 this error might appear as:
db2 => backup database sp1 online incremental delta use tsm without prompting SQL2048N An error occurred while accessing object "0". Reason code: "6".
In db2diag.log this might appear as:
2011-06-21-04.43.40.344127-240 E8263185E732 LEVEL: Error PID : 18315 TID : 47075576244544PROC : db2sysc 0 INSTANCE: db2sp1 NODE : 000 DB : SP1 APPHDL : 0-6852 APPID: *LOCAL.db2sp1.110621084340 AUTHID : DB2 EDUID : 100 EDUNAME: db2agent (SP1) 0 FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1685 MESSAGE : SQL2048N An error occurred while accessing object "". Reason code: "". DATA #1 : String, 166 bytes The BACKUP_IN_PROGRESS state is already on for this tablespace. This tablespace is already in the midst of being backed up and cannot have a concurrent backup on it. DATA #2 : String, 11 bytes SYSCATSPACE