Symptom
Online backup with default option (include log) fails intermittently with error "Log could not be retrieved".
Online backup without log files is not affected.
This happens only on Db2 version 11.5.6 and 11.5.7
2022-03-28-06.41.37.279057+000 E16617120A480 LEVEL: Info
PID : 11797134 TID : 234567 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 234567 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:2066
MESSAGE : Starting an online db backup.
<snipped>
2022-03-28-12.51.55.530423+000 I17448A522 LEVEL: Error
PID : 11797134 TID : 20320 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
HOSTNAME: abcde888
EDUID : 20320 EDUNAME: db2lfr.0 (ABC) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrOpenExtentRetrieve, probe:205
MESSAGE : ZRC=0x82100016=-2112880618=SQLP_RC_RETRIEVE_FAILED
"Log could not be retrieved"
DATA #1 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
1234567
2022-03-28-12.51.55.531475+000 I17971A501 LEVEL: Warning
PID : 11797134 TID : 20320 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
HOSTNAME: abcde888
EDUID : 20320 EDUNAME: db2lfr.0 (ABC) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMReadLog, probe:5120
DATA #1 : <preformatted>
LFR Scan Num = 19387969
LFR Scan Caller's EDUID = 103943
Return code for LFR opening file S1234567.LOG was -2112880618
<snipped>
2022-03-28-12.52.30.828177+000 E31340A604 LEVEL: Severe
PID : 11797134 TID : 12345 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 12345 EDUNAME: db2bm.234567.1 (ABC) 0
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:2620
MESSAGE : ADM8010E Backup was unable to copy requested log file "S1653166.LOG"
for inclusion in the backup image. The backup has been aborted.
2022-03-28-12.52.30.819688+000 E31945A723 LEVEL: Error
PID : 11797134 TID : 12345 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 12345 EDUNAME: db2bm.234567.1 (ABC) 0
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:2622
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 25 bytes
memberNum / currentExtent
DATA #2 : unsigned integer, 8 bytes
0
DATA #3 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
1653166
2022-03-28-12.52.30.820482+000 E32669A595 LEVEL: Severe
PID : 11797134 TID : 12345 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 12345 EDUNAME: db2bm.234567.1 (ABC) 0
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:2747
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2428
DATA #2 : Hexdump, 4 bytes
0x0A00040524B899C0 : FFFF F684 ....
2022-03-28-12.52.30.821547+000 E33265A1025 LEVEL: Severe
PID : 11797134 TID : 12345 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 12345 EDUNAME: db2bm.234567.1 (ABC) 0
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:2747
MESSAGE : SQL2428N The backup operation did not complete because an error was
encountered while the backup utility was retrieving the log files.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2428 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubPro
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2022-03-28-12.52.30.822551+000 E34291A585 LEVEL: Severe
PID : 11797134 TID : 12345 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 12345 EDUNAME: db2bm.234567.1 (ABC) 0
FUNCTION: DB2 UDB, database utilities, sqlubbuf, probe:473
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2044
DATA #2 : Hexdump, 8 bytes
0x0A00040524B899C0 : FFFF F804 0000 0002 ........
2022-03-28-12.52.30.864926+000 I34877A743 LEVEL: Error
PID : 11797134 TID : 284767 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 284767 EDUNAME: db2bm.234567.15 (ABC) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrScanNext, probe:3400
MESSAGE : ZRC=0x80100003=-2146435069=SQLP_LINT "Interrupt from application"
DIA8003C The interrupt has been received.
DATA #1 : SQLPLFR_SCAN_ID, PD_TYPE_SQLPLFR_SCAN_ID, 8 bytes
LFR Scan Num = 19387973
LFR Scan Caller's EDUID = 284767
DATA #2 : String, 17 bytes
Scan interrupted.
2022-03-28-12.52.30.866119+000 I35621A728 LEVEL: Error
PID : 11797134 TID : 284767 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 284767 EDUNAME: db2bm.234567.15 (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqlpOpenLogForBackup, probe:20
MESSAGE : ZRC=0x80100003=-2146435069=SQLP_LINT "Interrupt from application"
DIA8003C The interrupt has been received.
DATA #1 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
0
DATA #2 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
1653164
2022-03-28-12.53.20.751690+000 E127581A459 LEVEL: Severe
PID : 11797134 TID : 234567 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-88888 APPID: *LOCAL.db2ABC.220328064135
AUTHID : DB2ABC HOSTNAME: abcde888
EDUID : 234567 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:1221
MESSAGE : Backup terminated.
Read more...
Environment
- IBM Db2 version 11.5.6 or 11.5.7
Keywords
Online backup, Log could not be retrieved, SQL2428N, Scan interrupted , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.