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 > db2diag.log Warning-Rollforward does not have log skipping information for log file

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-12-10, 14:11
rockycj rockycj is offline
Registered User
 
Join Date: Feb 2007
Posts: 73
db2diag.log Warning-Rollforward does not have log skipping information for log file

I'm using DB2 V9.1. I got this on HADR server (secondary) this morning. Just wondering if there's something that I should do to prevent these kind of problems. Not sure how this happened.


2010-04-12-06.46.11.028659-300 I1119A453 LEVEL: Warning
PID : 1614000 TID : 1 PROC : db2logts (PSFTPROD) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, recovery manager, sqlpWriteDirtyList, probe:55 DATA #1 : <preformatted> Rollforward does not have log skipping information for log file 16513.Therefore, during tablespace rollforward, this log file will be replayed unconditionally. ExtentEntry 165

2010-04-12-06.46.11.036988-300 I1573A162 LEVEL: Warning
PID:1614000 TID:1 NODE:000 Title: SQLP_DBCB Dump File:/home/db2inst1/sqllib/db2dump/16140001.000


Attached is the 16140001.000 hexidecimal file. Has anyone ever encounter this issue before?

Thank you.

CC
Reply With Quote
  #2 (permalink)  
Old 04-12-10, 16:14
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
whats your DIAGLEVEL ? Is it 4 ?
Reply With Quote
  #3 (permalink)  
Old 04-12-10, 16:18
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
As per this APAR, this should be fixed in 8.2 FP 9, FP10 and FP10a which means you should see this as an informational message and can only be seen if the DIAGLEVEL is set to 4. But looks like you are getting it as a warning message eventhough you are in V9.1.

IBM IZ06273: MOVE LOG SKIPPING INFORMATION IN DB2DIAG.LOG FROM DIAGLEVEL 3 TO 4 - United States
Reply With Quote
  #4 (permalink)  
Old 04-13-10, 09:19
rockycj rockycj is offline
Registered User
 
Join Date: Feb 2007
Posts: 73
db2diag.log Warning-Rollforward does not have log skipping information for log file

I'm on diaglevel 3. I'm using DB2v9.1 FixPack 4.
Hmmm...

prodhadr$ db2 get dbm cfg | grep -i diaglevel
Diagnostic error capture level (DIAGLEVEL) = 3

CC
Reply With Quote
  #5 (permalink)  
Old 04-13-10, 10:58
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
As it is clearly mentioned that the error can be ignored, you don't have to worry about that message. You might want to open a PMR to let them know that this is coming out as a warning message in 9.1 FP3
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