IBM Support

JR33191: DURING CRASH RECOVERY DB2 MAY FAIL TO CREATE NEW TRANSACTION LOG FILES WHEN NEEDED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 may fail to create new transaction logs during crash
    recovery when needed which will cause the crash recovery to
    fail or hang.
    
    
    Symptom 1:
    
    Crash recovery hangs while the following message is being
    repeatedly written into db2diag.log
    
    2009-01-23-10.10.07.461979-300 I253295078A442     LEVEL: Warning
    PID     : 9142514              TID  : 4628        PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE
    APPHDL  : 0-52                 APPID: *N0.db2inst1.000000000000
    AUTHID  : db2inst1
    EDUID   : 4628                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpWriteLR,
    probe:4770
    MESSAGE : Need more active log space.
    
    Symptom 2:
    
    Crash recovery abends. One way to trigger the problem is to
    increase LOGSECOND and perform crash recovery. The following is
    a Signal #11 (SIGSEGV) call stack taken from an AIX trap file:
    
    00002B9DD4B65B3A sqlpgarl + 0x05ae
    00002B9DD4B6990D sqlpgasn + 0x0b4b
    00002B9DD4B6AF46 sqpLoggrEdu::RunEDU + 0x0052
    00002B9DD5D96C34 sqzEDUObj::EDUDriver + 0x00f2
    00002B9DD5D96D2B sqlzRunEDU + 0x0023
    

Local fix

Problem summary

  • Db2 may fail to create new transaction logs during crash
    recovery when needed which will cause the crash recovery to
    fail or hang.
    

Problem conclusion

  • First Fixed in db2 v9.1 FP8
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33191

  • 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

    2009-06-01

  • Closed date

    2009-11-16

  • Last modified date

    2009-11-16

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

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

    JR33192 IC63988

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSY

       UP

  • R950 PSY

       UP

[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021