IBM Support

LI74990: POSSIBLE DEAD LOCK/LATCH BETWEEN REORG AND OTHER SESSION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • There is a  possibility of  dead  lock /latch situation between
    a reorg and other session
    
    Reorg  grabs an anchor latch and  tries to get an X lock on the
    entry to free it.  On the other hand another session already
    has a share lock on the cache entry and needs to grab the anchor
    latch to find the entry again to unset a flag before unholding
    the lock.
    
    
    Following type of  snapshot might be observered :
    
    Snapshot timestamp                         = 09/24/2007
    14:56:14.028290
    
    Application handle                         = 66027
    Application status                         = UOW Executing
    Status change time                         = 09/24/2007
    14:56:13.154890
    Most recent operation                      = Reorganize
    Most recent operation start timestamp      = 09/22/2007
    00:20:29.751512
    Most recent operation stop timestamp       =
    
    Application handle                         = 65700
    Application status                         = Rollback Active
    Status change time                         = 09/22/2007
    00:20:35.630198
    Most recent operation                      = Static Rollback
    Most recent operation start timestamp      = 09/22/2007
    00:20:35.630200
    Most recent operation stop timestamp       = 09/22/2007
    00:20:35.630218
    
    
    Following type of stack might be observed for reorg :
    
    
    0000002A97DC8720 sqlt_logerr_zrc + 0x0088
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A977DEA96
    _Z18sqlrlc_flush_entryP8sqlrr_cbP20sqlrlc_anchor_commonP19sqlrlc
    _entry_common + 0x0336
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A977DE4E3 _Z21sqlrlc_flush_catcacheP8sqlrr_cbj + 0x02ab
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A977DCDE4
    _Z20sqlrlc_execute_eventP8sqlrr_cbP17sqlrlc_event_rqst + 0x007c
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A977DC8BD
    _Z23sqlrlc_broadcast_at_catP8sqlrr_cbP17sqlrlc_event_rqst +
    0x005d
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A977DC751
    _Z16sqlrlc_broadcastP8sqlrr_cbP17sqlrlc_event_rqst + 0x0209
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A963E3876 _Z26sqlrlc_flush_catalog_cacheP8sqlrr_cbj +
    0x0036
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A97434F84
    _Z15sqlrreorg_tableP8sqlrr_cbttP8sqlrg_idiimiisPhiS3_ish +
    0x05bc
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A974330D1 _Z18sqlrreorg_sendinfoP14db2UCinterfacei +
    0x15a9
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    0000002A973E2DD5 _Z11sqlrr_reorgP14db2UCinterface + 0x0075
                    (/var/ibmdb2/nyqxt060/sqllib/lib64/libdb2e.so.1)
    

Local fix

Problem summary

  • Users affected:
    Users running reorg  as  described in APAR description
    
    Problem Description:
    Please see  APAR  error description
    
    Problem Summary:
    POSSIBLE DEAD LOCK/LATCH  BETWEEN REORG AND OTHER SESSION
    

Problem conclusion

  • First fixed in DB2 UDB Version V9.5, FixPak 5
    (CQ defect#wsdbu00325604)
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74990

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-26

  • Closed date

    2009-11-24

  • Last modified date

    2009-11-24

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

    LI72629

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 November 2009