Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2009
    Posts
    36

    Unanswered: db2level for a Backup image

    Hi,
    Anyone knows how to check the db2level or db2 version for a offline backup image.

    I am having a backup image taken at 20080821010254. And I am trying to rediect restore that to current db2 version of 8.1.1 and fixpack 16.

    it is giving me the following error.

    SQL1651N The request cannot be executed because the DB2 server version does not support this functionality.

    So I want to check the db2level of the backup image and do it on the server with the same version.. Are there any other suggestions?? Please respond...


    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Try db2ckbkp
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Mar 2009
    Posts
    36
    I have tried db2ckbkp before with -a option.. but I did not find any db2 version information.

    is there any option other than db2ckbkp -a <imagename> which gets all the information?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It's there - look at "Release ID":
    Code:
            Timestamp                      -- 20090328223005
            Database Partition Number      -- 0
            Instance                       -- DB2
            Sequence Number                -- 1
            Release ID                     -- A00
            Database Seed                  -- 45AF8BE2
    I think the numbers mean the following: 900 is 8.1, A00 is 8.2, B00 is 9.1, C00 is 9.5
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Mar 2009
    Posts
    36
    Hi Nick,
    Thanks for your prompt response.. I can see that release id as A00 in my image..so it is db2 v8.2 what abt fix pack?
    The following are the details of db2level from my current db where I want to restore the image:

    Db2level :
    DB21085I Instance "db2d901" uses "64" bits and DB2 code release "SQL08029"
    with level identifier "030A0106".
    Informational tokens are "DB2 v8.1.1.144", "s080111", "U811269", and FixPak
    "16".
    Product is installed at "/usr/opt/db2_08_01".

    Is this possible to restore on this version. when I am giving the db2 restore dbname continue. I am getting the following error.

    SQL1651N The request cannot be executed because the DB2 server version does not support this functionality

    How can I fix it.. Thanks a lot

  6. #6
    Join Date
    Oct 2004
    Posts
    268
    Are you trying to restore a Linux database backup onto AIX server ?

  7. #7
    Join Date
    Mar 2009
    Posts
    36
    no AIX to AIX

  8. #8
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Is the backup image compressed? Are you restoring from 32 to 64 bit? If yes, you may need to specify the compression library that's stored with the backup image.
    ---
    "It does not work" is not a valid problem statement.

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The is most likely due to some syntax error. Please see this thread:

    http://www.dbforums.com/db2/1638554-...t-restore.html

  10. #10
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    mind posting the db2ckbkp output here and the commands of your restore...
    IBM Certified Database Associate, DB2 9 for LUW

  11. #11
    Join Date
    Mar 2009
    Posts
    36
    these are the commands I am using

    1. db2 "restore database D901 from /db2/D901/log_retrieve/backup taken at 20081002200108 into TEMPD901 redirect without rolling forward without prompting";


    2. db2 -tvf tbsp.sh (has the set tablespaces containers)

    3. db2 restore database D901 continue


    db2ckbkp is too large to post..

Posting Permissions

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