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.

Can you restart a failed DB2 backup?

Discussion in 'Backup / Archive Discussion' started by chad_small, Apr 13, 2012.

  1. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,205
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    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: 224718)


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

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,149
    Likes Received:
    275
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    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: Apr 13, 2012
  4. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,205
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    My DBA's tell me it has to start all over. Ridiculous! Oracle has been able to restart a failed backup since early 2000!
     
  5. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,149
    Likes Received:
    275
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    I don't think so - the TSM API built into DB2 handles this so we don't see it.
     
: db2

Share This Page