ADSM-L

Re: [ADSM-L] Error running DB2 backups using TSM

2008-12-03 09:02:04
Subject: Re: [ADSM-L] Error running DB2 backups using TSM
From: Jacques Van Den Berg <jvandenberg AT PNP.CO DOT ZA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 3 Dec 2008 15:59:04 +0200
Hi Lori,

Look in the file /usr/tivoli/tsm/client/api/bin/sample/dsmrc.h
RC 186 means you don't have an archive copy group.

#define DSM_RC_TL_NOACG            186 /* Archive req, no archive copy
group *

Regards,

Jacques van den Berg
TSM / Storage / SAP Basis Administrator
Pick 'n Pay IT
Email   : jvandenberg AT pnp.co DOT za
Tel      : +2721 - 658 1711
Fax     : +2721 - 658 1676
Mobile  : +2782 - 653 8164 
 
Dis altyd lente in die hart van die mens wat God 
en sy medemens liefhet (John Vianney).
 
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lori Grimaldi
Sent: 03 December 2008 03:15 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Error running DB2 backups using TSM

I am trying to run DB2 backups using TSM and I am seeing this in the
db2diag.log:

2008-12-02-15.12.28.668662-300 E115842488A361     LEVEL: Error
PID     : 23938                TID  : 2199156889936PROC : db2vend
(db2logmgr.meth1 - 43 (P
"/db/db2inst1/db2dump/db2diag.log" 2093516L, 115878129C       2092860,11
99%
INSTANCE: db2inst1             NODE : 000
EDUID   : 43                   EDUNAME: db2logmgr (PWLAN) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile,
probe:3108
MESSAGE : Started archive for log file S0000018.LOG.

2008-12-02-15.13.03.912179-300 E115853025A361     LEVEL: Error
PID     : 23938                TID  : 2199156889936PROC : db2vend
(db2logmgr.meth1 - 43 (P
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluvint, probe:602
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x000000BA=186 -- see TSM API Reference for meaning.

2008-12-02-15.13.03.913855-300 E115853387A864     LEVEL: Error
PID     : 23893                TID  : 2199367182672PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
EDUID   : 43                   EDUNAME: db2logmgr (PWLAN) 0
FUNCTION: DB2 UDB, data protection services, sqlpInitVendorDevice,
probe:1030
MESSAGE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR
          "A vendor device reported a media error."
DATA #1 : String, 29 bytes
Init failed!  Vendor rc info:
DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
                                                              2093056,1
99%
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile,
probe:3150
MESSAGE : ADM1848W  Failed to archive log file "S0000005.LOG" to "TSM
chain
0"%
          from
"/db/db2inst1/db2backup/db2inst1/PWLAN/NODE0000/C0000000/".

2008-12-02-15.14.35.547958-300 E115877076A568     LEVEL: Error
PID     : 23893                TID  : 2199367182672PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
EDUID   : 43                   EDUNAME: db2logmgr (PWLAN) 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 S0000005.LOG to TSM chain 0
from /db/db2inst1/db2backup/db2inst1/PWLAN/NODE0000/C0000000/.

2008-12-02-15.14.35.548035-300 E115877645A484     LEVEL: Warning
PID     : 23893                TID  : 2199367182672PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
EDUID   : 43                   EDUNAME: db2logmgr (PWLAN) 0
FUNCTION: DB2 UDB, data protection services, sqlpgCleanFailArchPath,
probe:4940
DATA #1 : <preformatted>
Unable to archive log file 5 from
failarchpath /db/db2inst1/db2backup/db2inst1/PWLAN/NODE0000/C0000000/
for
LOGARCHMETH1 due to rc -2045771739.

Any ideas?

Lori G.
Linux on zSeries Team
VM Services Delivery - Information Technology Services Americas, Global
Services
letersky AT us.ibm DOT com

Linux Information?  See http://w3vmlinux.pok.ibm.com
Linux Requests?  Visit our new workload management tool at:
http://linuxonz.pok.ibm.com/service/request

They who give have all things; they who withhold have nothing.

Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? 
If you don't have web access, the disclaimer can be mailed to you on request. 
Disclaimer requests to be sent to it-security AT pnp.co DOT za 
 

<Prev in Thread] Current Thread [Next in Thread>