If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > restore db2 database to different instance from Legato backup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-23-10, 08:55
indri_cilia indri_cilia is offline
Registered User
 
Join Date: Jan 2010
Posts: 8
Question restore db2 database to different instance from Legato backup

Has anyone had any practical experience on restoring a database to a different instance on the same machine where the backup was made and where the backup is being made via Legato? Right now I'm getting complaints as follows:

4784150#0 Tue Feb 23 13:17:05 2010 libnsrdb2_util: NMDB2_WARNING, SECURITY: *** Restore Permission Denied ***

4784150#0 Tue Feb 23 13:17:05 2010 libnsrdb2_util: NMDB2_WARNING, SECURITY: You must enable restores to alternate instances, in the client resource

4784150#0 Tue Feb 23 13:17:05 2010 nsrdb2_set_restore_object: Leaving Function: Result = 11
4784150#0 Tue Feb 23 13:17:05 2010 sqluvint: NMDB2_ERROR: nsrdb2_set_restore_object()
4784150#0 Tue Feb 23 13:17:05 2010 sqluvint: NMDB2_ERROR: restore lookup failure
4784150#0 Tue Feb 23 13:17:05 2010 sqluvint: NMDB2_ERROR
4784150#0 Tue Feb 23 13:17:05 2010 sqluvint: Leaving Function: Result = 11


Now I followed this up and it recommends using the Legato DB2 document recommends using DB2_R setting in what it calls the Client Resource. i put the line
DB2_R=<databasename>:<instance1>:<instance2>:

in the configuration file (which I suspect is the wrong place) but no luck. The restore line is:

db2 restore database AMMDB load /usr/lib/libnsrdb2.o options @/nsr/recover_AMMDB taken at 20100221030013
Reply With Quote
Reply

Tags
instance, legato, restore

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On