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.001The "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