A - Errors

If you receive the following error, the db2ckbkp utility may be used:

SQL1013N The database alias name or database name "sample" could not be
found.

2008-02-21-01.48.22.938044 Instance:db2 Node:000
PID:1081544(db2agent (ITB20) 0) TID:1 Appid:*LOCAL.db2.021012972726
database_utilities sqludMRWarn Probe:40 Database:sample
DiagData.


16f6 ffff 433a 5c44 4232 4261 636b 7570 . C:\SAMPLE.0
5c49 5442 3230 2e30 5c44 4232 5c4e 4f44 \DB2\NODE0000
4530 3030 305c 4341 544e 3030 3030 5c32 \CATN0000\200
3030 3230 3931 335c 3039 3237 3339 2e30 80321\053859.
3031 00 01.   

B - Causes

1 - When the backup was running, something caused the corrupted of image.

2 - The backup image in the file system was corrupted for someone or for some program.

C - Investigating 

The option -h on the db2ckbkp displays media header information including the name and path of the image expected by the restore utility.

C:\SAMPLE.0\DB2\NODE0000\CATN0000\20080321>db2ckbkp -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.

D - Resolution

You need to restore other backup image, or if you can, you may run a backup again, and when it finish, you can restore your backup image.