SAP Knowledge Base Article - Preview

3200623 - DB6: Online backup fails due to "Log could not be retrieved" error

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.