After a successful online backup database restore, if initial
rollforward returns SQL4970N because some log files are missed,
then a transaction log file will be created incorrectly and all
following rollforward will return SQL1265N
2013-07-17-21.22.49.445901-240 E34067A572 LEVEL: Error
PID : 671814 TID : 2457 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 2457 EDUNAME: db2logmgr (SAMPLE)
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogDisk, probe:3500
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "S0000000.LOG" could not be found.
DATA #1 : String, 110 bytes
This might mean that end-of-logs has been reached. Check for
other errors
to verify whether this is the case.
2013-07-17-21.22.49.520452-240 E34640A454 LEVEL: Warning
PID : 671814 TID : 2457 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 2457 EDUNAME: db2logmgr (SAMPLE)
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogFile, probe:4165
MESSAGE : ADM1847W Failed to retrieve log file "S0000000.LOG"
on chain "0" to
"/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/".
2013-07-17-21.22.49.521020-240 I35095A366 LEVEL: Warning
PID : 671814 TID : 3228 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 3228 EDUNAME: db2lfr (SAMPLE)
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog,
probe:5120
MESSAGE : Return code for LFR opening file S0000000.LOG was
-2146434659
2013-07-17-21.22.49.529119-240 I35462A397 LEVEL: Info
PID : 671814 TID : 2714 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
EDUID : 2714 EDUNAME: db2loggr (SAMPLE)
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchFromRedoToUndo,
probe:1800
DATA #1 : <preformatted>
Create Last Log, FileCount is 0, TailIndex is 0 |
