IBM Support

IZ11603: ROLLFORWARD FAILS AND BRINGS THE INSTANCE DOWN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • when logSpace and logSpaceSaved in SQLOGCTL.LFH file are set to
    inconsistent values, Rollforward does not complete and brings
    the instance down.
    
    Messages similar to the following will be dumped in the
    db2diag.log :-
    
    2007-09-30-02.09.03.417803-240 I4541005A463       LEVEL: Warning
    PID     : 6701                 TID  : 1           PROC :
    db2agent (DEXIXP1) 0
    INSTANCE: db2idep1             NODE : 000         DB   : DEXIXP1
    APPHDL  : 0-18                 APPID:
    *LOCAL.db2idep1.070930060859
    AUTHID  : DB2UDB
    FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery,
    probe:2210
    DATA #1 : <preformatted>
    Invoking database rollforward backward recovery, nextLsn:
    000000EA99324FF7
    
    2007-09-30-02.09.06.290645-240 I4541469A424       LEVEL: Severe
    PID     : 6701                 TID  : 1           PROC :
    db2agent (DEXIXP1) 0
    INSTANCE: db2idep1             NODE : 000         DB   : DEXIXP1
    APPHDL  : 0-18                 APPID:
    *LOCAL.db2idep1.070930060859
    AUTHID  : DB2UDB
    FUNCTION: DB2 UDB, data protection services, sqlpEndBFI,
    probe:990
    DATA #1 : <preformatted>
    logSpace 0 amount 18446744073709551550
    
    2007-09-30-02.09.06.290941-240 I4541894A501       LEVEL: Error
    PID     : 6701                 TID  : 1           PROC :
    db2agent (DEXIXP1) 0
    INSTANCE: db2idep1             NODE : 000         DB   : DEXIXP1
    APPHDL  : 0-18                 APPID:
    *LOCAL.db2idep1.070930060859
    AUTHID  : DB2UDB
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMScheckObjAlloc,
    probe:0
    MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
    Error"
              DIA8526C A fatal error occurred in data protection
    services.
    
    2007-09-30-02.09.06.291821-240 I4542396A467       LEVEL: Error
    PID     : 6701                 TID  : 1           PROC :
    db2agent (DEXIXP1) 0
    INSTANCE: db2idep1             NODE : 000         DB   : DEXIXP1
    APPHDL  : 0-18                 APPID:
    *LOCAL.db2idep1.070930060859
    AUTHID  : DB2UDB
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMScheckObjAlloc,
    probe:0
    DATA #1 : String, 76 bytes
     Obj={pool:8;obj:16;type:1} State=x27 Parent={7;9}, EM=864,
    PP0=896 Page=864
    

Local fix

  • Enable Infinte logging by setting LOGSECOND to -1
    

Problem summary

  • ROLLFORWARD FAILS AND BRINGS THE INSTANCE DOWN
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 5
    

Temporary fix

  • Enable Infinte logging by setting LOGSECOND to -1
    

Comments

APAR Information

  • APAR number

    IZ11603

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-12-20

  • Closed date

    2008-06-23

  • Last modified date

    2008-06-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IZ11605

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R910 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
04 October 2021