Personal tools
You are here: Home DB2 Problem Resolution Backup and Recovery Errors Verifying if backup images are corrupted.
Navigation
Log in


Forgot your password?
 
Document Actions

Verifying if backup images are corrupted.

To check if a backup image is corrupted, you can use the db2ckbkp command.

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.

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls