=== Capture log ===
2019-03-26-22.06.02.880169 ASN8041D
"Q Capture" : "QASN" : "LogrdThread" : db2LogRead API is sending
us backwards in theDB2 Log: First LSN is
"0000:0005:1552:b1ac:0000:d96b:43dc:0c78" while Next Start LSN
is "0000:0000:0000:0000:0000:0000:0000:0000"
2019-03-26-22.06.02.880338 ASN0552E
"Q Capture" : "QASN" : "logrd" : The program encountered an SQL
error. The server name is "CXL1". The SQL request is
"db2ReadLog". The table name is "". The SQLCODE is "-1273". The
SQLSTATE is " ". The SQLERRMC is "CXL1??88357.LOG??". The
SQLERRP is "SQLPRLOG".
SQL1273N An operation reading the logs on database "CXL1"
cannot continue because of a missing log file "S0188357.LOG" on
database partition "0" and log stream "3".
2019-03-26-22.06.02.880382 ASN0005E
CAPTURE "QASN" : "LogrdThread". The Capture program encountered
an error when reading the DB2 log. The log sequence number is
"0000:0005:1552:B1AC:0000:D96B:43DC:0C78", the SQLCODE is
"-1273", and the reason code is "".
2019-03-26-22.06.05.881483 ASN8999D
db2ReadLog SQL1273 retry 1 of 5
=== db2diag.log ===
2019-03-26-22.06.02.838600+480 I826860A1535 LEVEL: Error
PID : 5243322 TID : 86637 PROC :
db2sysc 3
INSTANCE: db2inst2 NODE : 003 DB : CXL1
APPHDL : 3-1414 APPID:
172.17.31.111.33523.190322100003
AUTHID : QREPADM HOSTNAME: cxl2csdp04
EDUID : 86637 EDUNAME: db2agent (CXL1) 3
FUNCTION: DB2 UDB, recovery manager,
sqlpshrValidateLogStreamEndPoint, probe:1130
MESSAGE : ZRC=0x86100026=-2045771738=SQLPR_MISSING_LOG_EXT
"Used by various operations reading the logs to
indicate a missing log extent."
DATA #1 :
Forward phase of recovery on stream 3 did not reach end of logs.
stream returned log records: yes
found logRecs after end pt: no
lastExt: 188356
lastExtNeededForRecovery: 188356
lastExtNeededForTbspRfwd: 0
nextRecLso: 31446629380908
LastRecLsoLFH: 31446620699338
shrScanEndLso: 18446744073709551615
shrLastDiskLso: 31446629382261
shrScanNextFlagsOut: 0x1
highestLfsLsnProduced: 21832577517/0000D96B43DC10CE
maxStopLfsLsn:
18446744073709551615/FFFFFFFFFFFFFFFF
delayErrorUntilNextLogRead: true
isReadLogOrOlic: true
isTbspRfwd: false
gBkpEndMarker LFS / LSN: 21626398456/0000D96A76846027
LFH hflag1: 0x0
LFH hflag2: 0x0
LFH hflag3: 0x0
GLFH hflag1: 0x20
GLFH hflag2: 0x0
2019-03-26-22.06.02.872811+480 I828396A1061 LEVEL:
Warning
PID : 5243322 TID : 86637 PROC :
db2sysc 3
INSTANCE: db2inst2 NODE : 003 DB : CXL1
APPHDL : 3-1414 APPID:
172.17.31.111.33523.190322100003
AUTHID : QREPADM HOSTNAME: cxl2csdp04
EDUID : 86637 EDUNAME: db2agent (CXL1) 3
FUNCTION: DB2 UDB, recovery manager, sqlpshrScanNext, probe:3485
MESSAGE : ZRC=0x86100026=-2045771738=SQLPR_MISSING_LOG_EXT
"Used by various operations reading the logs to
indicate a missing log extent."
DATA #1 : String, 41 bytes
Ignoring error detected on log stream id:
DATA #2 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
3
DATA #3 : String, 11 bytes
At LFS/LSN:
DATA #4 : unsigned integer, 8 bytes
21832577585
DATA #5 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes
0000D96B43DC1735
DATA #6 : String, 37 bytes
Because the log merge is finishing at
DATA #7 : unsigned integer, 8 bytes
21832577517
DATA #8 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes
0000D96B43DC10CE
2019-03-26-22.06.02.873924+480 I829458A609 LEVEL: Error
PID : 5243322 TID : 86637 PROC :
db2sysc 3
INSTANCE: db2inst2 NODE : 003 DB : CXL1
APPHDL : 3-1414 APPID:
172.17.31.111.33523.190322100003
AUTHID : QREPADM HOSTNAME: cxl2csdp04
EDUID : 86637 EDUNAME: db2agent (CXL1) 3
FUNCTION: DB2 UDB, data protection services,
sqlpgReadLogReadAction, probe:15600
MESSAGE : ZRC=0x86100026=-2045771738=SQLPR_MISSING_LOG_EXT
"Used by various operations reading the logs to
indicate a missing log extent."
2019-03-26-22.06.02.878903+480 I830068A604 LEVEL:
Warning
PID : 5243322 TID : 86637 PROC :
db2sysc 3
INSTANCE: db2inst2 NODE : 003 DB : CXL1
APPHDL : 3-1414 APPID:
172.17.31.111.33523.190322100003
AUTHID : QREPADM HOSTNAME: cxl2csdp04
EDUID : 86637 EDUNAME: db2agent (CXL1) 3
FUNCTION: DB2 UDB, data protection services, sqlpgReadLogAPI,
probe:17350
MESSAGE : ZRC=0x86100026=-2045771738=SQLPR_MISSING_LOG_EXT
"Used by various operations reading the logs to
indicate a missing log extent."
2019-03-26-22.06.02.879485+480 E830673A545 LEVEL: Error
PID : 5243322 TID : 86637 PROC :
db2sysc 3
INSTANCE: db2inst2 NODE : 003 DB : CXL1
APPHDL : 3-1414 APPID:
172.17.31.111.33523.190322100003
AUTHID : QREPADM HOSTNAME: cxl2csdp04
EDUID : 86637 EDUNAME: db2agent (CXL1) 3
FUNCTION: DB2 UDB, data protection services, sqlpgReadLogAPI,
probe:1
DATA #1 : String, 12 bytes
S0188357.LOG
DATA #2 : String, 1 bytes
0
DATA #3 : String, 1 bytes
3 |
