Results 1 to 4 of 4
  1. #1
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,191
    Thanks
    1
    Thanked 25 Times in 24 Posts

    Question Can you restart a failed DB2 backup?

    Anyone know if you can restart a DB2 backup from the last transaction point before the failure? I know Oracle can, I would think DB2 could. If so how. Searching Google I haven't found the needed information. On a side not our DB2 server experienced the following error.


    04/13/12 08:24:33 ANR0530W Transaction failed for session 224718 for node
    PRDODM1A_DB2 (DB2/AIX64) - internal server error
    detected. (SESSION: 22471


    It's a LAN-Free client so I did see some notes on issues with LAN-Free to disk but this does to VTL.
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,861
    Thanks
    4
    Thanked 228 Times in 223 Posts

    Default

    Quote Originally Posted by chad_small View Post
    Anyone know if you can restart a DB2 backup from the last transaction point before the failure? I know Oracle can, I would think DB2 could. If so how. Searching Google I haven't found the needed information. On a side not our DB2 server experienced the following error.


    04/13/12 08:24:33 ANR0530W Transaction failed for session 224718 for node
    PRDODM1A_DB2 (DB2/AIX64) - internal server error
    detected. (SESSION: 22471


    It's a LAN-Free client so I did see some notes on issues with LAN-Free to disk but this does to VTL.
    Chad,

    It has been a while since I worked with DB2 backing up to TSM.

    I believe you just run another backup and the API will pickup from where it left. Just don't take this as something etched in stone.
    Last edited by moon-buddy; 04-13-2012 at 01:50 PM.
    Ed

  3. #3
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,191
    Thanks
    1
    Thanked 25 Times in 24 Posts

    Default

    My DBA's tell me it has to start all over. Ridiculous! Oracle has been able to restart a failed backup since early 2000!
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  4. #4
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,861
    Thanks
    4
    Thanked 228 Times in 223 Posts

    Default

    Quote Originally Posted by chad_small View Post
    My DBA's tell me it has to start all over. Ridiculous! Oracle has been able to restart a failed backup since early 2000!
    I don't think so - the TSM API built into DB2 handles this so we don't see it.
    Ed

Similar Threads

  1. backup hangs until shedule restart
    By foobar2devnull in forum TSM Client
    Replies: 5
    Last Post: 08-08-2012, 03:22 PM
  2. DB2 v9.5 backup reporting as failed
    By Chris_Wigglesworth in forum Backup / Archive Discussion
    Replies: 6
    Last Post: 10-11-2011, 06:33 AM
  3. Event Status : "Failed - no restart"
    By rchoudarapu in forum TSM Server
    Replies: 9
    Last Post: 11-20-2008, 03:05 AM
  4. Restart Failed Backup via Script.
    By Foxxy74 in forum Backup / Archive Discussion
    Replies: 12
    Last Post: 07-25-2007, 08:36 AM
  5. Automatically Restart Failed Backups
    By Foxxy74 in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 05-16-2007, 07:49 PM

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
  •