Personal tools
You are here: Home DB2 How To's How to check the db2 version for a backup image
Navigation
Log in


Forgot your password?
 
Document Actions

How to check the db2 version for a backup image

using the command db2ckbkp

The option -h on the db2ckbkp displays media header information including DB2 version for a image backup.

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.

The means for A00 on Release ID field is: 8.2

To other versions:

  • 900 = 8.1
  • A00 = 8.2
  • B00 = 9.1
  • C00 = 9.5

The means for Backup mode field is:

  • 0 : Backup full offline
  • 1: Backup full online

The means for Includes logs  field is:

  • 0 : Includes logs option
  • 1: Exclude logs option

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





Polls