Results 1 to 8 of 8
  1. #1
    Member
    Join Date
    Jun 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default DB2 backup failing due to error

    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. #2
    Senior Member
    Join Date
    Jul 2008
    Location
    Birmingham, UK
    Posts
    537
    Thanks
    0
    Thanked 5 Times in 4 Posts

    Default

    Hi

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

    Cheers

  3. #3
    Member
    Join Date
    Jun 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default DB2 backup failing due to error

    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)

  4. #4
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,194
    Thanks
    1
    Thanked 26 Times in 25 Posts

    Default

    The attribute changes are not errors and not the cause of the problem. I think you need to look at the configuration files.
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  5. #5
    Member
    Join Date
    Jun 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default DB2 backup failing due to error

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

  6. #6
    Member Mikey D's Avatar
    Join Date
    Mar 2007
    Location
    Southeast Michigan
    Posts
    272
    Thanks
    0
    Thanked 5 Times in 5 Posts

    Default

    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*/

  7. #7
    Member
    Join Date
    Jun 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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 ?

  8. #8
    Member
    Join Date
    Sep 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default DB2 backup failing due to error

    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

Similar Threads

  1. DB2 backup is failing
    By waire in forum DB2
    Replies: 11
    Last Post: 10-10-2006, 06:58 AM
  2. Backups failing due to "out of space". Not really the problem though?
    By beacher in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 02-02-2006, 06:07 PM
  3. No Backups Due To Error
    By dustypaint in forum Backup / Archive Discussion
    Replies: 2
    Last Post: 09-22-2004, 02:22 PM
  4. TSM backup of DB2 V8 64-bit database failing on AIX server with SQL2071N
    By bspiegel in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 09-17-2004, 12:43 AM
  5. Error on DB2 backup
    By nkinison in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 01-28-2003, 07:29 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •