Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Austin,TX
    Posts
    4

    Unanswered: db2ckbkp on multi partition

    I am using db2 V8.1 and created sample database on 4 logical nodes on one windows box. I am using the following backup commands to perform full database offline backup.

    db2 backup db sample user db2admin using db2admin to d:\db2dump

    db2_all "<<-0<||db2 backup db sample user db2admin using db2admin to d:\ db2dump, e:\ db2dump, f:\ db2dump, g:\ db2dump

    After successful backup, created the following structure and I would like to verify the below backup image using db2ckbkp command. How to use db2ckbkp command to verify below backup image? Any help greatly appreciated.

    Thanks!
    GNR

    d:\db2dump\sample.0\DB2\NODE0000\CATN0000\20060116 \143032.001
    d:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.001
    d:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143158.001
    d:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.001

    e:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.002
    e:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143112.002
    e:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.002

    f:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.003
    f:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143112.003
    f:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.003

    g:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.004
    g:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143112.004
    g:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.004

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Check the manual for information on db2ckbkp command.
    Here is the portion I guess is likely to help you
    1. If the complete backup consists of multiple objects, the validation will only succeed if db2ckbkp is used to validate all of the objects at the same time.
    2. When checking multiple parts of an image, the first backup image object (.001) must be specified first.
    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Oct 2003
    Location
    Austin,TX
    Posts
    4
    I gone through Manual but It doesn't say much on it except those two notes. I tried using *.001 first but giving somekind of errors.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you are keen to increase the chances of getting a useful response, post the command you are using and the error message you get.

    I wish I were a superhuman to know what 'somekind of errors' means


    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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