3756283 - DB6: 'Unexpected' restore pending status

• Database restore completes successfully. The database reaches roll-forward pending status.
  
  
• Rollforward is initiated but fails due to a missing log file.
  
  
• Rollforward is canceled by end user, and database 'returns' to "restore pending".
  
  
  
• db2diag.log
  
  

  2026-05-20-12.34.29.161306+480 E531203219E551        LEVEL: Warning
  PID     : 3569                 TID : 140677539161856 PROC : db2sysc 0
  INSTANCE: db2abc               NODE : 000            DB   : abc
  APPHDL  : 0-316                APPID: *LOCAL.db2abc.260520034324
  AUTHID  : DB2abc               HOSTNAME: abc001
  EDUID   : 22                   EDUNAME: db2agent (abc) 0
  FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:330
  MESSAGE : ADM1609W  The database manager is canceling the database rollforward 
            recovery.

  
  2026-05-20-12.34.29.174946+480 E531204317E523        LEVEL: Warning
  PID     : 3569                 TID : 140677539161856 PROC : db2sysc 0
  INSTANCE: db2abc               NODE : 000            DB   : abc
  APPHDL  : 0-316                APPID: *LOCAL.db2abc.260520034324
  AUTHID  : DB2abc               HOSTNAME: abc001
  EDUID   : 22                   EDUNAME: db2agent (abc) 0
  FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8180
  MESSAGE : ADM1611W  The rollforward recovery phase has been completed.

  2026-05-20-12.34.29.178952+480 E531204841E601        LEVEL: Warning
  PID     : 3569                 TID : 140677539161856 PROC : db2sysc 0
  INSTANCE: db2abc               NODE : 000            DB   : abc
  APPHDL  : 0-316                APPID: *LOCAL.db2abc.260520034324
  AUTHID  : DB2abc               HOSTNAME: abc001
  EDUID   : 22                   EDUNAME: db2agent (abc) 0
  FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8181
  MESSAGE : ZRC=0x801000C0=-2146434880=SQLPR_CANCELED_WARN "Rollforward canceled"
  DATA #1 : String, 41 bytes
  The rollforward recovery phase completed.

  
  2026-05-20-12.34.45.153120+480 I531209365E519        LEVEL: Error
  PID     : 3569                 TID : 140677539161856 PROC : db2sysc 0
  INSTANCE: db2abc               NODE : 000            DB   : abc
  APPHDL  : 0-317                APPID: *LOCAL.db2abc.260520034344
  AUTHID  : DB2abc               HOSTNAME: abc001
  EDUID   : 22                   EDUNAME: db2agent (abc) 0
  FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:376
  MESSAGE : ZRC=0x801000B8=-2146434888=SQLP_RESTPEND "Restore pending."

  2026-05-20-12.34.45.156028+480 E531209885E2426       LEVEL: Severe
  PID     : 3569                 TID : 140677539161856 PROC : db2sysc 0
  INSTANCE: db2abc               NODE : 000            DB   : abc
  APPHDL  : 0-317                APPID: *LOCAL.db2abc.260520034344
  AUTHID  : DB2abc               HOSTNAME: abc001
  EDUID   : 22                   EDUNAME: db2agent (abc) 0
  FUNCTION: DB2 UDB, data protection services, SQLP_DBCB::setLogState, probe:5000
  DATA #1 : <preformatted>
  Database error has been detected.  As a result, for precautionary reasons
  all logging services have been stopped.

SAP on IBM Db2 for Linux, Unix and Windows

restore pending, roll-forward pending, missing log file, cancel , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem