IBM Support

JR28747: DATABASE PANIC / CRASHES BRINGING DOWN INSTANCE WITH " DIA8501C A BUFFER POOL LOGIC ERROR HAS OCCURRED ".CRASH RECOVERY SQL1042C

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The database or instance unexpectedly comes down with the
    following db2diag.log message:
    .
    2007-12-03-13.02.22.771000-480 I88795918H471 LEVEL: Error
    PID     : 5828                 TID  : 3652   PROC : db2syscs.exe
    INSTANCE:                      NODE : 000    DB   :
    APPHDL  : 0-157                APPID: GA00014E.L307.024B83205611
    FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
    RETCODE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
              error detected"
              DIA8501C A buffer pool logic error has occurred.
    .
    Subsequent attempts of crash recovery fail with SQL1042C,
    accompanied with the same aforementioned db2diag.log message.
    .
    The code that is reporting the error is performing a physical
    write of database data to disk.
    .
    This APAR serves two purposes.
    1) Enhance the diagnostics such that if the same codepath
       encounters the same error, then the code will report
       additional diagnostic data such as any system error codes
       encountered during the write to disk.  These diagnostics
       will help to isolate the source of the problem.
    2) Include a code fix for a bug that can lead to the problem
       symptoms described in this APAR.
    

Local fix

Problem summary

  • ERROR DESCRIPTION:
    The database or instance unexpectedly comes down with the
    following db2diag.log message:
    .
    2007-12-03-13.02.22.771000-480 I88795918H471 LEVEL: Error
    PID     : 5828                 TID  : 3652   PROC : db2syscs.exe
    INSTANCE:                      NODE : 000    DB   :
    APPHDL  : 0-157                APPID: GA00014E.L307.024B83205611
    FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
    RETCODE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
              error detected"
              DIA8501C A buffer pool logic error has occurred.
    .
    Subsequent attempts of crash recovery fail with SQL1042C,
    accompanied with the same aforementioned db2diag.log message.
    .
    The code that is reporting the error is performing a physical
    write of database data to disk.
    .
    

Problem conclusion

  • First Fixed in DB2 v9.1 FP6
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR28747

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-03-18

  • Closed date

    2008-11-12

  • Last modified date

    2009-05-18

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

    JR28742

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

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:
06 October 2021