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 > SQL2540W Restore is successful, however a warning "2523" was encountered

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-29-05, 21:04
raj125 raj125 is offline
Registered User
 
Join Date: Nov 2005
Posts: 6
SQL2540W Restore is successful, however a warning "2523" was encountered

I did a successful restore from the backup but the command center spewed out this message. Does anyone know what this means. I googled it and all i got was that the restore happened sucessfully but "2523" was issued .... No explanation whatsoever..
Reply With Quote
  #2 (permalink)  
Old 11-30-05, 03:00
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Possibly this

db2 ? sql02523n


SQL2523W Warning! Restoring to an existing database that is
different from the database on the backup image, but
have matching names. The target database will be
overwritten by the backup version. The Roll-forward
recovery logs associated with the target database will
be deleted.

Explanation:

The database alias and name of the target database are the same
as the backup image database alias and name. The database seeds
are not the same indicating that the databases are not the same.
The target database will be overwritten by the backup version.
The Roll-forward recovery logs associated with the target
database will be deleted. The current configuration file will be
overwritten with the backup version.

User Response:

Return to the utility with the callerac parameter indicating
processing to continue or end.
Reply With Quote
Reply

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