Command Reference

db2ckbkp - Check Backup

This utility allows the user to test the integrity of a backup image and determine whether or not it can be restored. It can also be used to display the meta-data stored in the backup header in order to determine information about a particular backup image. One or more parts of an image can be checked.

Authorization

Anyone can access the utility, but users must have read permissions on image backups in order to execute this utility against them.

Required Connection

None

Command Syntax

               .-,--------.   .-,-----------.
               V          |   V             |
>>-db2ckbkp-------+----+--+------filename---+------------------><
                  +--a-+
                  +--c-+
                  +--d-+
                  +--h-+
                  +--H-+
                  +--l-+
                  '--o-'
 

Command Parameters

-a

Displays all available information.

-c

Displays results of checkbits and checksums.

-d

Displays information from the headers of DMS table space data pages.

-h

Displays media header information, including the name or path of the image expected by the restore utility.

-H

Displays only the media header information.

Notes:

1. This option does not validate the image.

2. Validation will be performed on the entire image if this option is not specified.

-l

Displays Log File Header data.

-o

Displays detailed information from the object headers.

filename

The name of the backup image file. One or more files can be checked at a time.

Notes:

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.

Examples

   db2ckbkp SAMPLE.0.krodger.NODE0000.CATN0000.19990817150714.*
   [1] Buffers processed:  ## 
   [2] Buffers processed:  ##
   [3] Buffers processed:  ##
   Image Verification Complete - successful.
 
   db2ckbkp -h SAMPLE2.0.krodger.NODE0000.CATN0000.19990818122909.001
 
 
   =====================
   MEDIA HEADER REACHED:
   =====================
           Server Database Name           -- SAMPLE2
           Server Database Alias          -- SAMPLE2
           Client Database Alias          -- SAMPLE2
           Timestamp                      -- 19990818122909
           Node                           -- 0
           Instance                       -- krodger
           Sequence Number                -- 1
           Release ID                     -- 900
           Database Seed                  -- 65E0B395
           DB Comment's Codepage (Volume) -- 0
           DB Comment (Volume)            --                               
           DB Comment's Codepage (System) -- 0
           DB Comment (System)            --                               
           Authentication Value           -- 255
           Backup Mode                    -- 0
           Backup Type                    -- 0
           Backup Gran.                   -- 0
           Status Flags                   -- 11
           System Cats inc                -- 1
           Catalog Node Number            -- 0
           DB Codeset                     -- ISO8859-1
           DB Territory                   -- 
           Backup Buffer Size             -- 4194304
           Number of Sessions             -- 1
           Platform                       -- 0
 
   The proper image file name would be:
   SAMPLE2.0.krodger.NODE0000.CATN0000.19990818122909.001
   
   [1] Buffers processed:  ####
   Image Verification Complete - successful.

Usage Notes

If a backup was created using multiple sessions, db2ckbkp can examine all of the files at the same time. Users are responsible for ensuring that the session with sequence number 001 is the first file specified.

This utility can also verify backup images on tape. This is done by preparing the tape as for a restore operation and running the utility specifying the tape device name. For example, on UNIX based systems:

   db2ckbkp -h /dev/rmt0

and on Windows NT:

   db2ckbkp -d \\.\tape1

If the backup resides on TSM, refer to db2adutl - Work with TSM Archived Images.