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 > rollforward database fails

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-14-03, 03:40
mixxalot mixxalot is offline
Registered User
 
Join Date: May 2003
Posts: 369
rollforward database fails

We did a redirected restore from our old db server on DB2 UDB 7.2 FP6 to a new server, DB2 UDB 7.2 FP10a, both servers run on AIX 5.2L and they are 32 bit. The initial restore went fine but when I rolled forward the database it fails with the error:

# db2 rollforward db prod to end of logs
SQL1265N The archive log file "S0060800.LOG" is not associated with the current log sequence for database "PROD" on node "0".

Also in the db2diag.log are some very nasty errors:

Problem with log file S0060800.LOG, Index 11, PId 104291803, 60899 1071232620

2003-12-14-00.07.44.471337 Instance:db2inst1 Node:000
PID:43066(db2agnsc (PROD) 0) Appid:*LOCAL.db2inst1.031214021835
data_protection sqlpgrlg Probe:48 Database:PROD

Next log extent not in chain. Blocks read : 0000 0000
Reply With Quote
  #2 (permalink)  
Old 12-14-03, 17:51
mixxalot mixxalot is offline
Registered User
 
Join Date: May 2003
Posts: 369
cause and solution

Found this issue online with Fixpaks9/10 its resolved in FP11 for DB2 UDB 7.2:

http://www-306.ibm.com/cgi-bin/db2ww...aparno=IY44816

Scott
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