Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
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:
Fix information
Fixed component name
DB2 UDE ESE LIN
Fixed component ID
5765F4104
Applicable component levels
R910 PSY
UP
Document Information
Modified date:
16 October 2021