1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

DB2 backup failing due to error

Discussion in 'Backup / Archive Discussion' started by newguy538, Jul 15, 2009.

  1. newguy538

    newguy538 New Member

    Joined:
    Jun 7, 2009
    Messages:
    24
    Likes Received:
    0
    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
     
  2.  
  3. ChrisRees

    ChrisRees Senior Member

    Joined:
    Jul 24, 2008
    Messages:
    537
    Likes Received:
    13
    Occupation:
    Storage Management Person
    Location:
    Birmingham, UK
    Hi

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

    Cheers
     
  4. newguy538

    newguy538 New Member

    Joined:
    Jun 7, 2009
    Messages:
    24
    Likes Received:
    0
    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(52618)). (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)
     
  5. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,207
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    The attribute changes are not errors and not the cause of the problem. I think you need to look at the configuration files.
     
  6. newguy538

    newguy538 New Member

    Joined:
    Jun 7, 2009
    Messages:
    24
    Likes Received:
    0
    the DB guy check the dsierror log and he says he dsmerror log is empty.
     
  7. Mikey D

    Mikey D Member

    Joined:
    Mar 21, 2007
    Messages:
    272
    Likes Received:
    8
    Location:
    Southeast Michigan
    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*/
     
  8. newguy538

    newguy538 New Member

    Joined:
    Jun 7, 2009
    Messages:
    24
    Likes Received:
    0
    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 ?
     
  9. jwhowell

    jwhowell New Member

    Joined:
    Sep 18, 2002
    Messages:
    26
    Likes Received:
    0
    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/docview.wss?uid=swg21206886
     
: db2

Share This Page