SQL2033N rc=106 on backing up DB2 to TSM

Technote (troubleshooting)


Problem(Abstract)

When backing up DB2 to TSM, a SQL2033N RC=106 error may be returned.

Symptom

The following messages will be logged in the db2diag.log:

2011-10-21-15.07.56.730930-300 E305204A394 LEVEL: Info
PID : 528478 TID : 1 PROC : db2agent (TESTDB)
0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-9 APPID: *LOCAL.db2inst1.111021200756
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1420
MESSAGE : Starting an offline db backup.

2011-10-21-15.07.56.766705-300 I305599A664 LEVEL: Error
PID : 467012 TID : 1 PROC : db2med.528478.0 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog,
probe:939
DATA #1 : String, 108 bytes
Vendor error: rc = 11 returned from function sqluvint.
Return_code structure from vendor library libtsm.a:

DATA #2 : Hexdump, 48 bytes
0x0FFFFFFFFFFFD1A8 : 0000 006A 3334 3420 3130 3600 0000 0000 ...j344
106.....
0x0FFFFFFFFFFFD1B8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0FFFFFFFFFFFD1C8 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2011-10-21-15.07.56.767045-300 I306264A317 LEVEL: Error
PID : 467012 TID : 1 PROC :
db2med.528478.0 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:979 MESSAGE : Error in vendor support code at line: 344 rc: 106


Diagnosing the problem

This is a result of the error log not having write permissions for the user that is performing the backup.

The following note is from the TSM API 5.3.0 readme.
- Starting with TSM ver 5.3.0, a writable log file is required for backup/restore.


The DSMI_LOG environment variable or the dsm.sys file ERRORLOGNAME option must be set to a path that the user of the application can write to. If the user performing the backup/restore does not have write permissions to the log file, the process will fail. The TSM API return code for this situation is 106 - EDSM_RC_ACCESS_DENIED (Access to the specified file or directory is denied).


Resolving the problem

Change the permissions of the error log file to 777 and rerun the backup command.

Related information

SQL2033N RC 106

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.1, 9.5, 9.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1569282

Modified date:

2011-11-15

Translate my page

Machine Translation

Content navigation