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
Hi ,
ReplyDeleteThe means for Includes logs field is:
0 : Exclude logs
1 : Includes logs
Please correct me if I'm wrong .
Thank you.