Recover/restore db2 database from files under node directory

lalit_dba · #1 (**permalink**) 02-24-10, 09:06

Is there any way (other than normal backup/restore operation) to restore db2database using files in node directory (e.g C:\DB2\NODE0000) from one machine to another machine?

ARWinner · #2 (**permalink**) 02-24-10, 10:24

No. The recommended method is backup and restore.

Andy

sathyaram_s · #3 (**permalink**) 02-24-10, 12:29

It may be possible to use db2relocatedb , but as Andy says, backup and restore is the recommended option.

lalit_dba · #4 (**permalink**) 02-24-10, 23:56

Thanks, I will check with db2relocatedb.

grdfrsk · #5 (**permalink**) 05-04-11, 04:01

Hi all, really old thread, but I am taking my chances

lalit_dba,

Any luck in this endeavor? I am facing a similar problem after a system crash and so far db2relocatedb has failed to help me...

Best regards,
Robert

ARWinner · #6 (**permalink**) 05-04-11, 09:04

If your system crashed, then it is possible that the data on disk got corrupted so db2relocatedb will not work. You really should have used backup and restore.

Andy

grdfrsk · #7 (**permalink**) 05-04-11, 09:41

Many thanks for the quick reply, Andy.

The disk on the system is OK, the motherboard is not, however

I have managed to retreive all files from the disk without problems so I do not think the files are corrupt in any way.

Problems arise with db2relocatedb when the database to be relocated it is not found in the database directory, according to message DBT1025N.

Robert

ARWinner · #8 (**permalink**) 05-04-11, 09:45

What DB2 version and OS are you using? Please explain in detain what you are trying to do.

Andy

grdfrsk · #9 (**permalink**) 05-05-11, 07:04

The DB2-version is 9.5.0.808. Source OS is Windows Vista, target is Windows 7. As I mentioned before, the Vista system is dead and thus the instance on which the database resided does not exist anymore.

I have retreived the database folder and files from the Vista system harddrive and I want to recreate this database from these files.

I am using a relocadedb.cfg file in which I have experimented a little. One version I have tried looked like this (I have consulted the DB2 online help as well as google):

DB_NAME=NAME
DB_PATH=C:
INSTANCE=db2
NODENUM=0

Here is another one:
DB_NAME=NAME,NAME
DB_PATH=C:,C:
INSTANCE=db2inst1,db2inst1
NODENUM=0

However, both these files render the same message (DBT1025N).

To me it seems like there is no way of using db2relocatedb for databases that no longer exist within a running db2 instance, but I might ofcourse be mistaken.

Once more, many thanks for all help.

Robert

n_i · #10 (**permalink**) 05-05-11, 07:37

I'd try copying the files to the target system using exactly the same directory structure as in the old system. Assuming you have installed DB2 and created a new instance using all the same parameters as before, issuing CATALOG DB whatever ON C: might just work.

rajaraja_cholan · #11 (**permalink**) 05-05-11, 15:38

you may try to follow database mirroring pocedure. In db mirroring, you copy the filesystems/disks from source to target and initialize the target as mirror

ARWinner · #12 (**permalink**) 05-05-11, 15:59

Quote:

Originally Posted by rajaraja_cholan

you may try to follow database mirroring pocedure. In db mirroring, you copy the filesystems/disks from source to target and initialize the target as mirror

This will only work if the data on the disk is in a steady state (WRITE SUSPEND or deactivated DB).

Andy