When database starts retrieval of log we do not check the Format
Version to make sure it is the same as the current.
This can result in various error when we try and check the size
of the log or further along, due to mismatch in the structures.
The tool db2cklog should also check for this.
db2diag.log:
2012-04-19-12.45.30.158090+120 I134579A369 LEVEL: Warning
PID : 495636 TID : 2571 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogFile, probe:4130
MESSAGE : Started retrieve for log file S0005686.LOG.
2012-04-19-12.45.32.422286+120 E134949A611 LEVEL: Error
PID : 495636 TID : 2571 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogVendor, probe:2516
DATA #1 : String, 107 bytes
The actual log file size did not match the expected file size,
retrying retrieve. Actual / Expected / File:
DATA #2 : signed integer, 8 bytes
1245184
DATA #3 : signed integer, 8 bytes
8192
DATA #4 : String, 51 bytes
/ap/fh/fhdba03/fh0310bh/sqlog/NODE0000/S0005686.TMP
2012-04-19-12.45.32.422678+120 E135561A562 LEVEL: Error
PID : 495636 TID : 2571 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogVendor, probe:2533
MESSAGE : ZRC=0x870F000A=-2029060086=SQLO_FEXS "file already
exists"
DIA8722C A file already exists.
DATA #1 : String, 107 bytes
An error was encountered moving the mismatched sized logfile to
a saved file on the first retrieve attempt.
2012-04-19-12.45.32.422976+120 I136124A606 LEVEL: Warning
PID : 495636 TID : 2571 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogVendor, probe:2697
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
Error"
DIA8526C A fatal error occurred in data protection
services.
DATA #1 : String, 84 bytes
An error was encountered in first retrieve attempt. Retry will
be attempted. errId:
DATA #2 : signed integer, 8 bytes
3778 |
