Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: db2ckrst output problem

    Hi all,

    Environment: Db2 LUW 10.1 on RHEL 5.

    I have taken online full, baseline full inc. backup and then delta backups.

    But command db2ckrst is not showing as expected output. I am confused with that scenerio is given below:

    online full backup:
    [db2inst1@db2host ~]$ ls -lrt /home/db2inst1/onlinedb2backup/
    total 245856
    -rw------- 1 db2inst1 db2inst1 251752448 Jun 23 16:10 DBMSTC.0.db2inst1.DBPART000.20140623161012.001

    online inc. full backups:
    [db2inst1@db2host ~]$ ls -lrt /home/db2inst1//onlineincbackup/
    total 491740
    -rw------- 1 db2inst1 db2inst1 167845888 Jun 23 17:09 DBMSTC.0.db2inst1.DBPART000.20140623170508.001
    -rw------- 1 db2inst1 db2inst1 167845888 Jun 23 17:37 DBMSTC.0.db2inst1.DBPART000.20140623173621.001
    -rw------- 1 db2inst1 db2inst1 167845888 Jun 24 10:20 DBMSTC.0.db2inst1.DBPART000.20140624101934.001

    online delta backups:
    [db2inst1@db2host ~]$ ls -lrt /home/db2inst1/onlinedeltabackup
    total 508124
    -rw------- 1 db2inst1 db2inst1 184627200 Jun 24 10:50 DBMSTC.0.db2inst1.DBPART000.20140624104841.001
    -rw------- 1 db2inst1 db2inst1 201408512 Jun 24 10:54 DBMSTC.0.db2inst1.DBPART000.20140624105258.001
    -rw------- 1 db2inst1 db2inst1 134283264 Jun 25 15:02 DBMSTC.0.db2inst1.DBPART000.20140625150227.001

    now the command: db2ckrst -d dbmstc -t 20140623173621

    is giving output

    Suggested restore order of images using timestamp 20140623173621 for
    database dbmstc.
    ================================================== ==================
    restore db dbmstc incremental taken at 20140623173621
    restore db dbmstc incremental taken at 20140623161012
    restore db dbmstc incremental taken at 20140623173621
    ================================================== ==================

    why it is so ? why 20140623173621 is coming twice and no delta backup is listed ?

    please suggest ?

    regards
    sumit
    ssumit

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    try todo the restore with regular command
    db2 restore....
    start with last backup - full backup - incr - last backup
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    The output of the db2ckrst is expected and correct.
    Your delta backups are not needed to restore to the specified point in time.
    Code:
    Type Timestamp
    F    23161012
    I    23170508
    I    23173621 <-- You want to restore here
    I    24101934
    D    24104841
    D    24105258
    D    25150227
    Look at the Restoring from incremental backup images for more details.
    So, you have to specify the target backup image twice by design.
    Regards,
    Mark.

  4. #4
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    thanks mark
    ssumit

Posting Permissions

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