IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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.1, FixPak 5
    (CQ defect#wsdbu00318851)
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI72629

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-10-24

  • Closed date

    2008-07-09

  • Last modified date

    2008-07-09

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

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

    LI74990

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 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:
16 October 2021