Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2007
    Posts
    78

    Unanswered: Confirming backups

    Hi everyone,

    I executed a backup on a database how would i confirm that the backup was done correctly? I received the "Backup successful" confirmation but is there any other way? Thanks in advance.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    How about supplying us with your OS, DB2 version, Fixpack level, and how you did the backup?

    Andy

  3. #3
    Join Date
    Dec 2007
    Posts
    78
    REHL db2 v9, fp4a

    db2 backup db <dbname> to <destination>

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If you are executing the backup from the command line, what else could you want?

    Andy

  5. #5
    Join Date
    Dec 2007
    Posts
    78
    what if through crontab

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Send the output of the backup command to a file.

    Andy

  7. #7
    Join Date
    Mar 2008
    Posts
    136
    You can use db2ckbkp utility.

    C:\SAMPLE.0\DB2\NODE0000\CATN0000\20080321>db2ckbk p -h 053859.001

    The "db2ckbkp -h 053859.001" output is listed below:

    =====================

    MEDIA HEADER REACHED:

    =====================

    Server Database Name -- SAMPLE
    Server Database Alias -- SAMPLE
    Client Database Alias -- SAMPLE
    Timestamp -- 20080321053859
    Database Partition Number -- 0
    Instance -- DB2
    Sequence Number -- 1
    Release ID -- A00
    Database Seed -- 482820FA
    DB Comment's Codepage (Volume) -- 0
    DB Comment (Volume) --
    DB Comment's Codepage (System) -- 0
    DB Comment (System) --
    Authentication Value -- 255
    Backup Mode -- 1
    Includes Logs -- 0
    Compression -- 0
    Backup Type -- 0
    Backup Gran. -- 0
    Status Flags -- 11
    System Cats inc -- 1
    Catalog Partition Number -- 0
    DB Codeset -- IBM-1252
    DB Territory --
    LogID -- 1206087065
    LogPath -- C:\DB2\NODE0000\SQL00002\SQLOGDIR\
    Backup Buffer Size -- 4984832
    Number of Sessions -- 1
    Platform -- 5


    The proper image path would be:

    SAMPLE.0\DB2\NODE0000\CATN0000\20080321\053859.001

    [1] Buffers processed: #########

    Image Verification Complete - successful.

    If you received the message above " Image Verification Complete - successful. ", this backup image is not corrupted.

    Thanks & Regards
    Pawan Kumar

Posting Permissions

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