This APAR requires the existence of a backup in the history
file.
The db2ReadLog API tries to use the history file to get an
approximate starting point to open the log shredder to start
searching for the record in log extents, however, as you can see
a message from db2shred the given LFS/LSN are not mapped to an
LSO for a log stream, and baseLso are used, then SQL2654W is
returned instead of SQL1273N.
Symptoms are similar to the following db2diag.log messages:
2015-11-23-15.26.56.210994+480 I1541024E1228 LEVEL: Info
PID : 27952 TID : 139761918404352 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 398 EDUNAME: db2lfr.0 (DB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLogExtent,
probe:2164
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 19 bytes
Log is not found...
DATA #2 : Codepath, 8 bytes
19:24:26
DATA #3 : String, 99 bytes
extNum / logLocation / logStreamId / callerFlag / logFileName1 /
logFileName2 / callerSpecifiedPath
DATA #4 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
7
DATA #5 : unsigned integer, 4 bytes
0
DATA #6 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
0
DATA #7 : Hex integer, 8 bytes
0x0000000000000401
DATA #8 : String, 0 bytes
Object not dumped: Address: 0x00007F1CDB7FCB80 Size: 0 Reason:
Zero-length data
DATA #9 : String, 0 bytes
Object not dumped: Address: 0x00007F1CDB7FCCB0 Size: 0 Reason:
Zero-length data
DATA #10: String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address is NULL
2015-11-23-15.26.56.212630+480 I1542253E553 LEVEL:
Warning
PID : 27952 TID : 139761914210048 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 395 EDUNAME: db2logmgr (DB1) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogFile, probe:4062
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 38 bytes
Search on disk did not find any chain.
2015-11-23-15.26.56.213231+480 I1542807E505 LEVEL:
Warning
PID : 27952 TID : 139761918404352 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 398 EDUNAME: db2lfr.0 (DB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMReadLog,
probe:5120
DATA #1 :
LFR Scan Num = 3
LFR Scan Caller's EDUID = 428
Return code for LFR opening file S0000007.LOG was -2146434659
2015-11-23-15.26.56.208287+480 E1539870E618 LEVEL: Info
PID : 27952 TID : 139761914210048 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 395 EDUNAME: db2logmgr (DB1) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogFile, probe:4130
DATA #1 :
Started retrieve for log file S0000006.LOG for log stream 0 from
log chain 0.
Retrieval destination:
/home/db2inst1/dbs/db1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
LOGSTREAM0000/
Actual retrieval method: USE_METHOD1
2015-11-23-15.26.56.210994+480 I1541024E1228 LEVEL: Info
PID : 27952 TID : 139761918404352 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 398 EDUNAME: db2lfr.0 (DB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLogExtent,
probe:2164
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 19 bytes
Log is not found...
DATA #2 : Codepath, 8 bytes
19:24:26
DATA #3 : String, 99 bytes
extNum / logLocation / logStreamId / callerFlag / logFileName1 /
logFileName2 / callerSpecifiedPath
DATA #4 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
7
DATA #5 : unsigned integer, 4 bytes
0
DATA #6 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
0
DATA #7 : Hex integer, 8 bytes
0x0000000000000401
DATA #8 : String, 0 bytes
Object not dumped: Address: 0x00007F1CDB7FCB80 Size: 0 Reason:
Zero-length data
DATA #9 : String, 0 bytes
Object not dumped: Address: 0x00007F1CDB7FCCB0 Size: 0 Reason:
Zero-length data
DATA #10: String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address is NULL
2015-11-23-15.26.56.212630+480 I1542253E553 LEVEL:
Warning
PID : 27952 TID : 139761914210048 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 395 EDUNAME: db2logmgr (DB1) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogFile, probe:4062
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 38 bytes
Search on disk did not find any chain.
2015-11-23-15.26.56.213231+480 I1542807E505 LEVEL:
Warning
PID : 27952 TID : 139761918404352 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 398 EDUNAME: db2lfr.0 (DB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMReadLog,
probe:5120
DATA #1 :
LFR Scan Num = 3
LFR Scan Caller's EDUID = 428
Return code for LFR opening file S0000007.LOG was -2146434659
2015-11-23-15.26.56.213662+480 I1543313E570 LEVEL:
Warning
PID : 27952 TID : 139761805158144 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB1
APPHDL : 0-251 APPID:
*LOCAL.db2inst1.151123072659
AUTHID : DB2INST1 HOSTNAME: QTLinux1.cn.ibm.com
EDUID : 428 EDUNAME: db2shred (DB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpshrEdu, probe:5225
DATA #1 :
LFS/LSN 5225/000000000003FF0D was not mapped to an LSO for log
stream 0. Using baseLso 99193537. |
