home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC78289 Status: Geschlossen

INSTANCE HUNG AT FUNCTION SQMFASTWRITERQUEUEMGR::ALLOCFASTWRITER RECORDS
WHEN LOCKING EVENT MONITORS ARE ENABLE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When a locking event monitor is active and activity collection 
is enabled for deadlock, lock timeout or lock wait events, 
agents generating locking records may block waiting for records 
while holding latches sqlrr_curr_activity_cb_latch or 
sqlrr_past_activity_cb_latch.  This can result in a hang as the 
fast writers (which release records for reuse) end up waiting on 
those latches.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users that use locking event monitors                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 1) The majority of EDUs (including the PMODEL ones) are      * 
* waiting for (SQLO_LT_sqeAppServices__m_appServLatch) -       * 
* Address: (c0000000246d04d8). The holder is doing an index    * 
* scan, and it is waiting for                                  * 
* (SQLO_LT_sqlrr_past_activity_cb__sqlrr_past_activity_cb_latc * 
* h) - Address: (c00000005f4653c8).                            * 
*                                                              * 
* EDU name     : db2agent (SB27069)                            * 
* EDU ID       : 590                                           * 
*                                                              * 
* (5)  0xc000000000419a70  nanosleep_sys                       * 
* (6)  0xc000000000429950  nanosleep                           * 
* (7)  0xc000000017dafab0  sqloSpinLockConflict                * 
* (8)  0xc00000001d2948a0  sqlplDumpLockTimeoutInfo            * 
* (9)  0xc000000017cfb9b0  sqlplnfd                            * 
* (10) 0xc000000017825910  sqlplrqWithAttr                     * 
* (11) 0xc00000001f39ca20  sqliLockUncond                      * 
* (12) 0xc000000017797f10  sqliLockRec2                        * 
* (13) 0xc00000001733c850  sqliProcLeafNotNorm                 * 
* (14) 0xc00000001781fad0  sqlischf                            * 
* (15) 0xc0000000177e54d0  sqliFirstTreeSearch                 * 
* (16) 0xc000000017bca120  sqlirdk                             * 
* (17) 0xc000000017d88320  sqldIndexFetch                      * 
* (18) 0xc00000001799bd50  sqldRowFetch                        * 
* (19) 0xc000000017999d10  sqlritaSimplePerm                   * 
*                                                              * 
* Waiting on latch type:                                       * 
* (SQLO_LT_sqlrr_past_activity_cb__sqlrr_past_activity_cb_latc * 
* h) - Address: (c00000005f4653c8), Line: 1615, File:          * 
* sqlpldwi.C                                                   * 
* Holding Latch type: (SQLO_LT_SQLP_LHSH__xhshlatch) -         * 
* Address: (c0000000818788c8), Line: 550, File:                * 
* /view/db2_v97fp5_hpipf64_s110814/vbs/engn/sqp/inc/sqlpLockIn * 
* ternal.h HoldCount: 1                                        * 
* Holding Latch type: (SQLO_LT_sqeAppServices__m_appServLatch) * 
* - Address: (c0000000246d04d8), Line: 1366, File: sqlpldwi.C  * 
* HoldCount: 1                                                 * 
* Holding Latch type: (SQLO_LT_sqeApplication__masterAppLatch) * 
* - Address: (c00000005f4601c4), Line: 1383, File: sqlpldwi.C  * 
* HoldCount: 1                                                 * 
*                                                              * 
* =====                                                        * 
*                                                              * 
* 2) The holder of                                             * 
* (SQLO_LT_sqlrr_past_activity_cb__sqlrr_past_activity_cb_latc * 
* h) - Address: (c00000005f4653c8) is another index scan. This * 
* EDU is waiting for fast writer records but none are          * 
* available and so it blocks on a waitpost (which will be      * 
* posted by a fast writer when it returns records back to the  * 
* fast writer record pool):                                    * 
*                                                              * 
* EDU name     : db2agent (SB27069)                            * 
* EDU ID       : 121                                           * 
*                                                              * 
* // looks like waiting for fast writers                       * 
* (5)  0xc00000000041ac70  semtimedop_sys                      * 
* (6)  0xc00000000042c7c0  semtimedop                          * 
* (7)  0xc0000000172f49f0  sqloWaitEDUWaitPost                 * 
* (8)  0xc00000001abe7ad0                                      * 
* sqmLockEvents::collectRequestorActivities                    * 
* (9)  0xc000000017e4ba20  sqmLockEvents::collectLockEvent     * 
* (10) 0xc000000017df0580  sqlplfnd                            * 
* (11) 0xc000000017a46f10  sqlplrq                             * 
* (12) 0xc00000001f39c660  sqliLockUncond                      * 
* (13) 0xc000000017dc7f40  sqliScanLeaf2                       * 
* (14) 0xc0000000178099b0  sqlifnxt                            * 
* (15) 0xc000000017bc94f0  sqlirdk                             * 
* (16) 0xc000000017d88320  sqldIndexFetch                      * 
* (17) 0xc00000001799bd50  sqldRowFetchP8                      * 
* (18) 0xc000000017999d10  sqlritaSimplePerm                   * 
*                                                              * 
* Holding Latch type:                                          * 
* (SQLO_LT_sqlrr_past_activity_cb__sqlrr_past_activity_cb_latc * 
* h) - Address: (c00000005f4653c8), Line: 1262, File:          * 
* sqlm_lock_events.C HoldCount: 1                              * 
*                                                              * 
* =====                                                        * 
*                                                              * 
* 3) This instance has five fast writers.  The first four have * 
* the same stack, but the fifth one is diffent. In fact, the   * 
* first four are waiting for the fifth one which is waiting on * 
* a SQLO_LT_SQLP_LHSH__xhshlatch:                              * 
*                                                              * 
* EDU name     : db2fw0 (SB27069)                              * 
* EDU ID       : 52                                            * 
*                                                              * 
* EDU name     : db2fw1 (SB27069)                              * 
* EDU ID       : 59                                            * 
*                                                              * 
* EDU name     : db2fw2 (SB27069)                              * 
* EDU ID       : 56                                            * 
*                                                              * 
* EDU name     : db2fw3 (SB27069)                              * 
* EDU ID       : 55                                            * 
*                                                              * 
* (5)  0xc00000000041abf0  semop_sys                           * 
* (6)  0xc00000000042c560  semop                               * 
* (7)  0xc000000017d982d0                                      * 
* SQLO_SLATCH_CAS::getConflictComplexEm                        * 
* (8)  0xc000000017e839c0  SQLO_SLATCH_CAS64::getConflictEm    * 
* (9)  0xc0000000179a6000  sqloltch_notrack                    * 
* (10) 0xc000000017e2f040  sqlbVerifyAndLatchPage              * 
* (11) 0xc000000017b01c40  sqlbfix                             * 
* (12) 0xc000000017e20020  sqldGetPageForAppend                * 
* (13) 0xc00000001783b250  sqldInsertRow                       * 
* (14) 0xc00000001789d3e0  sqldRowInsert                       * 
* (15) 0xc000000017810ed0  sqlrinsr                            * 
* (16) 0xc00000001aae0f00  sqmRecordTypeArray::processRecord   * 
*                                                              * 
* EDU name     : db2fw4 (SB27069)                              * 
* EDU ID       : 57                                            * 
*                                                              * 
* (5)  0xc000000000419a70  nanosleep_sys                       * 
* (6)  0xc000000000429950  nanosleep                           * 
* (7)  0xc000000017dafab0  sqloSpinLockConflict                * 
* (8)  0xc000000017a45380  sqlplrq                             * 
* (9)  0xc0000000197b5830  sqldFindSlotOnPage                  * 
* (10) 0xc000000017e209c0  sqldFindAndLockSlotIfSpaceAvail     * 
* (11) 0xc000000017e1f6d0  sqldGetPageForAppend                * 
* (12) 0xc00000001783b250  sqldInsertRow                       * 
* (13) 0xc00000001789d3e0  sqldRowInsert                       * 
* (14) 0xc000000017810ed0  sqlrinsr                            * 
* (15) 0xc00000001aae0f00  sqmRecordTypeArray::processRecord   * 
*                                                              * 
* Waiting on latch type: (SQLO_LT_SQLP_LHSH__xhshlatch) -      * 
* Address: (c0000000818788c8), Line: 505, File:                * 
* /view/db2_v97fp5_hpipf64_s110814/vbs/engn/sqp/inc/sqlpLockIn * 
* ternal.h                                                     * 
*                                                              * 
* =====                                                        * 
*                                                              * 
* 4) The holder of the SQLO_LT_SQLP_LHSH__xhshlatch - Address: * 
* (c0000000818788c8) - is waiting for                          * 
* (SQLO_LT_sqlrr_past_activity_cb__sqlrr_past_activity_cb_latc * 
* h) - Address: (c00000005f4653c8), which is being held by the * 
* EDU described in step 1). So, 1) wants something that 4)     * 
* has, and 4) is waiting for something owned by 1). DEADLATCH! * 
*                                                              * 
* EDU name     : db2agent (SB27069)                            * 
* EDU ID       : 590                                           * 
*                                                              * 
* (5)  0xc000000000419a70  nanosleep_sys                       * 
* (6)  0xc000000000429950  nanosleep                           * 
* (7)  0xc000000017dafab0  sqloSpinLockConflict                * 
* (8)  0xc00000001d2948a0  sqlplDumpLockTimeoutInfo            * 
* (9)  0xc000000017cfb9b0  sqlplnfd                            * 
* (10) 0xc000000017825910  sqlplrqWithAttr                     * 
* (11) 0xc00000001f39ca20  sqliLockUncond                      * 
* (12) 0xc000000017797f10  sqliLockRec2                        * 
* (13) 0xc00000001733c850  sqliProcLeafNotNorm                 * 
* (14) 0xc00000001781fad0  sqlischf                            * 
* (15) 0xc0000000177e54d0  sqliFirstTreeSearch                 * 
* (16) 0xc000000017bca120  sqlirdk                             * 
* (17) 0xc000000017d88320  sqldIndexFetch                      * 
* (18) 0xc00000001799bd50  sqldRowFetch                        * 
* (19) 0xc000000017999d10  sqlritaSimplePerm                   * 
*                                                              * 
* Waiting on latch type:                                       * 
* (SQLO_LT_sqlrr_past_activity_cb__sqlrr_past_activity_cb_latc * 
* h) - Address: (c00000005f4653c8), Line: 1615, File:          * 
* sqlpldwi.C                                                   * 
* Holding Latch type: (SQLO_LT_SQLP_LHSH__xhshlatch) -         * 
* Address: (c0000000818788c8), Line: 550, File:                * 
* /view/db2_v97fp5_hpipf64_s110814/vbs/engn/sqp/inc/sqlpLockIn * 
* ternal.h HoldCount: 1                                        * 
* Holding Latch type: (SQLO_LT_sqeAppServices__m_appServLatch) * 
* - Address: (c0000000246d04d8), Line: 1366, File: sqlpldwi.C  * 
* HoldCount: 1                                                 * 
* Holding Latch type: (SQLO_LT_sqeApplication__masterAppLatch) * 
* - Address: (c00000005f4601c4), Line: 1383, File: sqlpldwi.C  * 
* HoldCount: 1                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 5                            * 
****************************************************************
Local-Fix:
For deadlock collection use the DEADLOCKS WITH DETAILS event 
monitor rather than the LOCKING event monitor.  For lock timeout 
collection set the DB2_CAPTURE_LOCKTIMEOUT registry variable to 
ON to generate a report file about lock timeouts rather than the 
LOCKING event monitor.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.7 Fix Pack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.08.2011
21.12.2011
09.08.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList