Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    88

    Unanswered: backup image version

    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.CATN0000.20100930145704.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.CATN0000.20100930145704.0 01



    ERROR: Failed to verify media header. Cannot continue.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Should be able to tell from:
    Release ID -- D0A

    However, I'm not really sure what D0A is.


    For my v9.7 db, I have:

    db cfg:
    Database release level = 0x0d00


    db2ckbkp:
    Release ID -- D00



    db2 releases:
    0x0a00 - v8
    0x0b00 - v9.1
    0x0c00 - v9.5
    0x0d00 - v9.7

  3. #3
    Join Date
    May 2010
    Posts
    88
    Thanks bella... Can anyone help me with what DOA means?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •