db2level for a Backup image

db2pro · #1 (**permalink**) 04-02-09, 10:10

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

n_i · #2 (**permalink**) 04-02-09, 10:28

Try db2ckbkp

db2pro · #3 (**permalink**) 04-02-09, 10:35

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?

n_i · #4 (**permalink**) 04-02-09, 11:56

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

db2pro · #5 (**permalink**) 04-02-09, 12:09

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

mdx34 · #6 (**permalink**) 04-02-09, 14:12

Are you trying to restore a Linux database backup onto AIX server ?

db2pro · #7 (**permalink**) 04-02-09, 14:32

no AIX to AIX

n_i · #8 (**permalink**) 04-02-09, 15:31

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.

db2girl · #9 (**permalink**) 04-02-09, 16:14

The is most likely due to some syntax error. Please see this thread:

SQL1651N during redirect restore

nick.ncs · #10 (**permalink**) 04-03-09, 03:33

mind posting the db2ckbkp output here and the commands of your restore...

db2pro · #11 (**permalink**) 04-03-09, 09:08

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..

Internet Services

Web Development

Digital Marketing

Consumer Tech