db version from backup image

[nittal jain]

Hi Friendz,
how do i know the version of database if i only have the backup image of it?
Find the output below for db2ckbkp -h

$ db2ckbkp -h GFIDEV.0.db2doc .NODE0000.CATN0 000.20100930145 704.0 01

ERROR - Unable to migrate media header from image



=============== ======
MEDIA HEADER REACHED:
=============== ======
Server Database Name --
Server Database Alias -- GFIDEV
Client Database Alias -- GFIDEV
Timestamp -- 20100930145704
Database Partition Number -- 0
Instance -- db2doc
Sequence Number -- 1
Release ID -- D0A
Database Seed -- 6E9395
DB Comment's Codepage (Volume) -- FFFFD700
DB Comment (Volume) --
DB Comment's Codepage (System) -- 0
DB Comment (System) --
Authentication Value -- 0
Backup Mode -- 239 (SPLIT MIRROR)
RANGE ERROR
Includes Logs -- 0
Compression -- 0
Backup Type -- 0
Backup Gran. -- 1
RANGE ERROR
Status Flags -- 100
System Cats inc -- 5120
Catalog Partition Number -- 0
DB Codeset --
DB Territory --
LogID -- 4677616
LogPath -- ¿/app/datagfi/db2doc/NODE0000/SQL00001/SQLOGDIR/
Backup Buffer Size -- 5632
Number of Sessions -- 0
Platform -- 1000000

The proper image file name would be:
GFIDEV.0.db2doc .NODE0000.CATN0 000.20100930145 704.0 01



ERROR: Failed to verify media header. Cannot continue.

[vijay2082]

Hi Nittal,

If you want to check if you can restore a particular database image (that youare unaware of which version etc) then below is the way out.

db2 get dbm cfg|grep -i "release level"
Database manager configuration release level = 0x0a00

db2ckbkp -H <BACKUP_IMAGE_N AME> |grep Release
Release ID -- A00

In both the output you need to look at the release level as highlighted and it should match.

=========

In your specific I will suggest you to open a PMR with IBM and check for the details related to release id output. I have found out that below holds true for the release level

release level 0x0a00 is version 8 (A00)
release level 0x0b00 is version 9.1 (B00)
release level 0x0c00 is version 9.5 (C00)

Cheers, Vijay