Disaster recovery for the DB2 server

Question

Hi ,

I am trying to recover the Db2 database on the Dr site.

The primary networker server name is A. the secondary networker server name is B which is also a DB2 server on Dr site.

the DB2 server name on the primary site is B. Using scanner -i , I have populated the CFi and media index for B.

Now when I am trying to restore the Db2 database, it fails. can any one please let me know the exact DR procedure for Db2 database.

regards
Anand

HabibG2 · Answer

We need more information.Detailed your platform.How you are performing your recover?What error message are you getting?At what point is the restore failing?

DavidHampson · Answer

Could you post the error message as the information here is too vague to give you anything constructive.

jasonlee1 · Answer

Is the equipment at the DR site in a closed-off network that duplicates the exact hostname and ip conventions of your production site? My first guess would be to verify that hostname resolution is ok both ways between networker server and db2 server at the DR site.

jasonlee1 · Answer

Is the equipment at the DR site in a closed-off network that duplicates the exact hostname and ip conventions of your production site? My first guess would be to verify that hostname resolution is ok both ways between networker server and db2 server at the DR site.

AnandB1 · Answer

the error message is as follows:512014#0 Tue May 19 11:25:28 2009 nsrdb2_check_init_input: NMDB2_ERROR: Error opening db specific debug log file /nsr/restdebug512014#0 Tue May 19 11:25:28 2009 sqluvint: NMDB2_ERROR503822#0 Tue May 19 11:26:44 2009 nsrdb2_set_restore_object: NMDB2_WARNING: BSAQueryObject found no matches503822#0 Tue May 19 11:26:44 2009 sqluvint: NMDB2_ERROR: nsrdb2_set_restore_object()503822#0 Tue May 19 11:26:44 2009 sqluvint: NMDB2_ERROR: no matching backups found503822#0 Tue May 19 11:26:44 2009 sqluvint: NMDB2_ERROR442442#0 Tue May 19 11:31:10 2009 nsrdb2_open_debug_file: NMDB2_ERROR: Cannot open db file /nsr/restdebug442442#0 Tue May 19 11:31:10 2009 nsrdb2_check_init_input: NMDB2_ERROR: Error opening db specific debug log file /nsr/restdebug442442#0 Tue May 19 11:31:10 2009 sqluvint: NMDB2_ERROR

AnandB1 · Answer

The DB2 server is also serving as the Networker server, therefore there is no issue of the hostname resoultiuon.

ble1 · Answer

The error seems to suggest that query against the index resulted in no backups found for this client. Without looking closely to configuration it is going to be hard to figure out what went wrong.

AnandB1 · Answer

Can you please let me know what will be the exact steps for the Db2 disaster recovery.

ble1 · Answer

I didn't do it, but I would guess following:- you install DB2 as before with same name on the client with the same name (unless you do directed recovery)- you run restore

NetWorker

Disaster recovery for the DB2 server

Was this post helpful?