restoring db2 database.

Vish_1x1 · #1 (**permalink**) 08-16-10, 08:20

Hello All,

I have got a database backup with name as below....

"EHA0710.0.db2inst1.NODE0000.CATN0000.201008101504 36.001"

This I want to restore to my database EHA0710, which I have created
myself using DB2 express c "control center".

But when I try to restore It by right clicking on the database and then restore
option It says that.....

"SQL2532N The backup file contains the backup image of database
"EHA0710" taken at timestamp "20100810150436". This is not the
backup image requested."

What should I do ? I need this database badly.

Thanks in advance.

ARWinner · #2 (**permalink**) 08-16-10, 09:10

I have several questions:

1) What DB2 version and OS are you using?
2) Where did the backup image come from? Was it the same database you are trying to restore into? Did it come from the same server?
3) What is the restore command you are trying to use to restore the database?

Andy

wilsonfv · #3 (**permalink**) 08-16-10, 10:14

do you enter a wrong timestamp in the control centre when control centre is trying to look for the image ? 20100810150436 is what you should enter

db2girl · #4 (**permalink**) 08-16-10, 22:46

Some additional things you can try:

- drop db you created yourself and retry the restore (from the command line)
- if you transferred this image from another server, make sure it was done using binary mode (you can use db2ckbkp to verify that the image is good)

DBFinder · #5 (**permalink**) 08-16-10, 23:06

Code:

>db2 drop db EHA0710
DB20000I  The DROP DATABASE command completed successfully.
>db2 restore db EHA0710 
DB20000I  The RESTORE DATABASE command completed successfully.

OR

Code:

>db2 restore db EHA0710 replace existing
SQL2539W  Warning!  Restoring to an existing database that is the same as the backup image database.  The database files will be deleted.

Vish_1x1 · #6 (**permalink**) 08-17-10, 01:01

Quote:

Originally Posted by ARWinner

I have several questions:

1) What DB2 version and OS are you using?
2) Where did the backup image come from? Was it the same database you are trying to restore into? Did it come from the same server?
3) What is the restore command you are trying to use to restore the database?

Andy

1) Version DB2 v9.7.200.358

2) The backup image came from clients production environment
which their previous vendors had set up for them. ( may be from their
server.)

3) I am not trying any restore command. I am using the db2 express c
to restore the database and It gives a command before restoring, that
is as follows.

********
RESTORE DATABASE EHA0710 FROM "C:\DB2" TAKEN AT 20100816171950 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
********

I am not sure what db2 version the previous vendor was using.

Vish_1x1 · #7 (**permalink**) 08-17-10, 01:05

Quote:

Originally Posted by wilsonfv

do you enter a wrong timestamp in the control centre when control centre is trying to look for the image ? 20100810150436 is what you should enter

when I try to restore the database through db2 express c tool.
I provide it with the image name and the timestamp that is mentioned in
the image provided by the client. (which may be different from the database on which I try to restore. I try to restore clients image on the database I created myself.)

DBFinder · #8 (**permalink**) 08-17-10, 01:06

Quote:

Originally Posted by Vish_1x1

1)
3) I am not trying any restore command. I am using the db2 express c
to restore the database and It gives a command before restoring, that
is as follows.

********
RESTORE DATABASE EHA0710 FROM "C:\DB2" TAKEN AT 20100816171950 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
********

Definitely, you are trying to restore the database. No matter it is GUI or commnad line.

This should work in any case because the image seems to be an offline backup image ( I am not sure if image comes from ver 5 or v6 ).

Regards

Vish_1x1 · #9 (**permalink**) 08-17-10, 01:19

Quote:

Originally Posted by DBFinder

Code:

>db2 drop db EHA0710
DB20000I  The DROP DATABASE command completed successfully.
>db2 restore db EHA0710 
DB20000I  The RESTORE DATABASE command completed successfully.

OR

Code:

>db2 restore db EHA0710 replace existing
SQL2539W  Warning!  Restoring to an existing database that is the same as the backup image database.  The database files will be deleted.

Thanks Every one for your valuable feedback.

If I have the image file as below

EHA0710.0.db2inst1.NODE0000.CATN0000.2010081015043 6.001

what would be the restore command for that.
I tried the restore command as specidied by you "db2 restore db EHA0710"
but it says
**********
SQL2542N No match for a database image file was found based on the source
database alias "EHA0710" and timestamp "" provided.
**********

DBFinder · #10 (**permalink**) 08-17-10, 01:26

Quote:

Originally Posted by Vish_1x1

Thanks Every one for your valuable feedback.

If I have the image file as below

EHA0710.0.db2inst1.NODE0000.CATN0000.2010081015043 6.001

what would be the restore command for that.
I tried the restore command as specidied by you "db2 restore db EHA0710"
but it says
**********
SQL2542N No match for a database image file was found based on the source
database alias "EHA0710" and timestamp "" provided.
**********

The one you pasted already. The simplest version will be as I said

Code:

db2 restore db EHA0710

when you are in the same folder as image.

or

Code:

db2 restore db EHA0710 from C:/DB2

from anywhere.

regards

DBFinder · #11 (**permalink**) 08-17-10, 01:31

Seems that the image was created on Linux platform. You may have to restore it on Linux box, then export data or db2relocate or db2move, in fact I am not sure at this moment.

I will find out more for you.

regards

Vish_1x1 · #12 (**permalink**) 08-17-10, 01:35

Quote:

Originally Posted by DBFinder

The one you pasted already. The simplest version will be as I said

Code:

db2 restore db EHA0710

when you are in the same folder as image.

or

Code:

db2 restore db EHA0710 from C:/DB2

from anywhere.

regards

Thanks so much for immediate reply.
I just tried out as you said

db2 => restore db EHA0710 from C:\DB2

This was the out come......
*************************
SQL2570N An attempt to restore on target OS "NT-32" from a backup created on
source OS "Linux-IA32" failed due to the incompatibility of operating systems
or an incorrect specification of the restore command. Reason-code: "1".
*************************

I am using windows 7.....

DBFinder · #13 (**permalink**) 08-17-10, 01:39

Better,

I had indicated that. Now you are almost clear.

Only way can be to restore it on similar system and move it via some utility or native db2 commands. I have never done that; but there are many experts on this forum to help out.

regards

Vish_1x1 · #14 (**permalink**) 08-17-10, 01:46

Quote:

Originally Posted by DBFinder

Better,

I had indicated that. Now you are almost clear.

Only way can be to restore it on similar system and move it via some utility or native db2 commands. I have never done that; but there are many experts on this forum to help out.

regards

Thank you so much for the help. I will try to restore it on linux platform and
then move it to some other server. Will keep the tread updated with all my progress and findings ......

Thanks ALL .

Vish_1x1 · #15 (**permalink**) 08-17-10, 03:08

Hello All,

Any latest version of db2ecpress installer on linux can help me restore the database on linux. am I right?

or do I need to get any specific varsion of db2 to restore my image file.

Internet Services

Web Development

Digital Marketing

Consumer Tech