DB2 Backups and Log Archives fail

Troubleshooting

Problem

DB2 table space backups or Log Archives to IBM Spectrum Protect fail with a SQLP_MEDIA_VENDOR_DEV_ERR error in the db2diag.log

Symptom

The Backups or Log Archives fail with no errors in IBM Spectrum Protect logs but show errors similar to the below in the DB2 diaglog

2016-01-20-12.02.45.248779-300 E1474264225E623 LEVEL: Error
PID : 22553 TID : 140056090109696 PROC : db2sysc 0
INSTANCE: abc NODE : 000 DB : xyz
HOSTNAME: localhost
EDUID : 17819 EDUNAME: db2logmgr (xyz) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile,
probe:3160
MESSAGE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR
"A vendor device reported a media error."
DATA #1 : <preformatted>
Failed to archive log file S0000300.LOG to TSM chain 0 from
/home/abc/abc/NODE0000/SQL00001/LOGSTREAM0000/.

2016-01-20-12.02.45.249038-300 I1474264849E507 LEVEL: Warning
PID : 22553 TID : 140056090109696 PROC : db2sysc 0
INSTANCE: abc NODE : 000 DB :xyz
HOSTNAME: localhost
EDUID : 17819 EDUNAME: db2logmgr (xyz) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive,
probe:4780
MESSAGE : Still unable to archive log file 300 due to rc -2045771739 for
LOGARCHMETH1 using method 2 and target TSM_MC.

Cause

The rc -2045771739 points to a failure to create the connection to the IBM Spectrum Protect API

Diagnosing The Problem

A trace of the failure will show

08:47:55.384 [010830] [528365344] : pssec.cpp (1580): psGetpswdA(): User is password authorized
08:47:55.384 [010830] [528365344] : dsminit.cpp (3461): ApiCleanUp was called because of rc = 2033
08:47:55.384 [010830] [528365344] : dsminit.cpp (3482): User has Passwordaccess=generate, but appl supplied node or owner.
08:47:55.384 [010830] [528365344] : dsminit.cpp (3494): ApiCleanUp : handle is = 1
.

Resolving The Problem

DB2 has the ability to pass the NODENAME, OWNER, and PASSWORD into the IBM Spectrum Protect API when it makes the call to initialization the session. If the TSM_NODE value is set in DB2 and PASSWORDACCESS GENERATE is also set then the above failure will occur.

To resolve the RC=2033 error:

If PASSWORDACCESS GENERATE is the desired handling of the password then make sure that

TSM_OWNER

TSM_PASSWORD

are NULL within the db2 cfg settings

If the intention is to use the values set in DB2 then ensure

TSM_OWNER

TSM_PASSWORD

are correctly specified within the DB2 cfg settings and ensure that

is set in the IBM Spectrum Protect client options file

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Client","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM Tivoli Storage Manager

Was this topic helpful?

Document Information

Modified date:
17 June 2018

UID

swg21976144

Tips