DB2 backup failing due to error

[newguy538]

here is the error the DB guys are getting when they try to take a DB2 backup i dont understand the error at all i am just copying the error .

Bolow is the error we get

2009-07-15-04.00.04.578143-240 I3653867A383 LEVEL: Warning
PID : 4505606 TID : 1 PROC : db2agent (idle) 0
INSTANCE: prdc27 NODE : 000 DB : DPR272DC
APPHDL : 0-68 APPID: *LOCAL.prdc27.090718190322
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:2028
MESSAGE : Starting an online db backup.

2009-07-15-04.00.15.461730-240 I3654251A663 LEVEL: Error
PID : 4784308 TID : 1 PROC : db2med.4505606.0 0
INSTANCE: prdc27 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:0
DATA #1 : String, 108 bytes
Vendor error: rc = 25 returned from function sqluvput.
Return_code structure from vendor library libtsm.a:

DATA #2 : Hexdump, 48 bytes
0x0FFFFFFFFFFFDA00 : 0000 009D 3133 3434 2031 3537 0000 0000 ....1344 157....
0x0FFFFFFFFFFFDA10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFFDA20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2009-07-15-04.00.15.463225-240 I3654915A317 LEVEL: Error
PID : 4784308 TID : 1 PROC : db2med.4505606.0 0
INSTANCE: prdc27 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:0
MESSAGE : Error in vendor support code at line: 1344 rc: 157

2009-07-15-04.00.15.464484-240 I3655233A327 LEVEL: Warning
PID : 4784308 TID : 1 PROC : db2med.4505606.0 0
INSTANCE: prdc27 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:60
MESSAGE : Media controller -- problem writing to vendor device. rc = -2025

2009-07-15-04.00.15.464674-240 I3655561A457 LEVEL: Severe
PID : 4505606 TID : 1 PROC : db2agent (idle) 0
INSTANCE: prdc27 NODE : 000 DB : DPR272DC
APPHDL : 0-68 APPID: *LOCAL.prdc27.090718190322
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 11 bytes
0x0780000031422118 : FFFF F817 3431 FF54 534D 00 ....41.TSM.

2009-07-15-04.00.15.586125-240 I3656470A460 LEVEL: Severe
PID : 4505606 TID : 1 PROC : db2agent (idle) 0
INSTANCE: prdc27 NODE : 000 DB : DPR272DC
APPHDL : 0-68 APPID: *LOCAL.prdc27.090718190322
FUNCTION: DB2 UDB, database utilities, sqluCleanupPartialBackup, probe:688
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFE6844 : 0000 0006 ....

2009-07-15-04.00.15.586395-240 I3656931A638 LEVEL: Warning
PID : 4505606 TID : 1 PROC : db2agent (idle) 0
INSTANCE: prdc27 NODE : 000 DB : DPR272DC
APPHDL : 0-68 APPID: *LOCAL.prdc27.090718190322
FUNCTION: DB2 UDB, database utilities, sqluCleanupPartialBackup, probe:689
MESSAGE : Vendor RC:
DATA #1 : Hexdump, 48 bytes
0x0FFFFFFFFFFE6920 : 0000 0006 3235 3836 2036 0000 0000 0000 ....2586 6......
0x0FFFFFFFFFFE6930 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFE6940 : 0000 6332 372F 4E4F 0000 0000 0000 0000 ..c27/NO........

2009-07-15-04.00.15.594924-240 I3657570A358 LEVEL: Severe
PID : 4505606 TID : 1 PROC : db2agent (idle) 0
INSTANCE: prdc27 NODE : 000 DB : DPR272DC
APPHDL : 0-68 APPID: *LOCAL.prdc27.090718190322
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:140
MESSAGE : Backup Terminated.

the backup is failing 4AM EST .some bady please help me

[ChrisRees]

Hi

Is there anything useful in the TSM server activity log at the time of this backup?

Cheers

[newguy538]

i check the activity log of the TSM server for the last 5 days and found this may this log give some help to you . cheers

tsm: TSMPRS04>q act begind=-5 endd=-0 sea=pprdi020_db2
Date/Time Message
-------------------- ----------------------------------------------------------
07/12/2009 08:26:15 ANR0406I Session 405372 started for node PPRDI020_DB2
(AIX) (Tcp/Ip cpaidi40.homedepot.com(5261). (SESSION:
405372)
07/12/2009 08:26:15 ANR0403I Session 405372 ended for node PPRDI020_DB2 (AIX).
(SESSION: 405372)
07/12/2009 08:40:53 ANR0406I Session 405462 started for node PPRDI020_DB2
(AIX) (Tcp/Ip cpaidi42.homedepot.com(43485)). (SESSION:
405462)
07/12/2009 08:40:53 ANR1639I Attributes changed for node PPRDI020_DB2: TCP
Name from cpaidi40 to cpaidi42, TCP Address from
165.130.210.24 to 165.130.210.25. (SESSION: 405462)
07/12/2009 08:40:53 ANR0403I Session 405462 ended for node PPRDI020_DB2 (AIX).
(SESSION: 405462)
07/12/2009 08:56:14 ANR0406I Session 405565 started for node PPRDI020_DB2
(AIX) (Tcp/Ip cpaidi40.homedepot.com(52641)). (SESSION:
405565)
07/12/2009 08:56:14 ANR1639I Attributes changed for node PPRDI020_DB2: TCP
Name from cpaidi42 to cpaidi40, TCP Address from
165.130.210.25 to 165.130.210.24. (SESSION: 405565)

[chad_small]

The attribute changes are not errors and not the cause of the problem. I think you need to look at the configuration files.

[newguy538]

the DB guy check the dsierror log and he says he dsmerror log is empty.

[Mikey D]

This message MESSAGE : Media controller -- problem writing to vendor device. rc = -2025

Matches up to this API return code

dsmrc.h:#define DSM_RC_INVALID_MCNAME 2025 /* Mgmt class name not found*/

[newguy538]

still the issue is not resolved and we are unable to identify the problem and again tonight the backup runs so we have to wait and watch what happens today we get the same error what we are getting today or some different error or backup runs good .

do somebody has documentation on how to troubleshoot a DB2 backup issue ?

[jwhowell]

I found this on IBM's website. I was having a similar problem backing up a database. The problem appears to be a lack of mount points causing simultaneous write to drop the copy pool; DB2 doesn't handle the retry request and so the backup fails.

http://www-01.ibm.com/support/docvie...id=swg21206886