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 IC73186 Status: Geschlossen

DB2 MIGHT ENCOUNTER 'DEAD LATCH' ISSUE AND INSTANCE WILL HANG.

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
To identify the problem, issue 'db2fodc -hang' command to 
generate diagnostic information. Then in stack files you will 
see 2 agents similar to the followings: 
================================ 
<StackTrace> 
sqloXlatchConflict 
sqlpm_write_appl_locks 
sqm_snap_appl_locks 
sqm_snap_db_locks 
sqlmonssagnt 
 
<LatchInformation> 
Waiting on latch type: (SQLO_LT_SQLP_TENTRY__tranEntryLatch) - 
Address: (7000001bc956e68), Line: 748, File: 
/view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqlpi_inlines.h 
 
Holding Latch type: (SQLO_LT_sqeLocalDatabase__dblatch) - 
Address: (780000000780328), Line: 395, File: sqlmutil.C 
HoldCount: 1 
Holding Latch type: (SQLO_LT_sqeAppServices__m_appServLatch) - 
Address: (7800000002f04f8), Line: 7822, File: sqlmonss.C 
HoldCount: 1 
Holding Latch type: (SQLO_LT_sqeApplication__masterAppLatch) - 
Address: (7000002513101c4), Line: 327, File: 
/view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqle_app_service 
s.h 
HoldCount: 1 
 
... 
 
<StackTrace> 
sqloXlatchConflict 
sqlkdDispatchRequest 
sqlkdInterrupt 
sqlrr2pd 
sqlrkcmt 
sqlrkcm 
sqlrrcom_dps 
sqlrr_xcommit 
 
<LatchInformation> 
Waiting on latch type: (SQLO_LT_sqeApplication__masterAppLatch) 
- Address: (7000002513101c4), Line: 997, File: 
/view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqle_application 
.h 
 
Holding Latch type: (SQLO_LT_SQLP_TENTRY__tranEntryLatch) - 
Address: (7000001bc956e68), Line: 748, File: 
/view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqlpi_inlines.h 
HoldCount: 1 
================================ 
The deadlatch is constructed by 'masterAppLatch' and 
'tranEntryLatch'. 
 
You will have to recycle the instance to get out of the 'dead 
latch' situation.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* To identify the problem, issue 'db2fodc -hang' command to    * 
* generate diagnostic information. Then in stack files you     * 
* will see 2 agents similar to the followings:                 * 
* ================================                             * 
* <StackTrace>                                                 * 
* sqloXlatchConflict                                           * 
* sqlpm_write_appl_locks                                       * 
* sqm_snap_appl_locks                                          * 
* sqm_snap_db_locks                                            * 
* sqlmonssagnt                                                 * 
*                                                              * 
* <LatchInformation>                                           * 
* Waiting on latch type: (SQLO_LT_SQLP_TENTRY__tranEntryLatch) * 
* - Address: (7000001bc956e68), Line: 748, File:               * 
* /view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqlpi_inlines. 
*                                                              * 
* Holding Latch type: (SQLO_LT_sqeLocalDatabase__dblatch) -    * 
* Address: (780000000780328), Line: 395, File: sqlmutil.C      * 
* HoldCount: 1                                                 * 
* Holding Latch type: (SQLO_LT_sqeAppServices__m_appServLatch) * 
* - Address: (7800000002f04f8), Line: 7822, File: sqlmonss.C   * 
* HoldCount: 1                                                 * 
* Holding Latch type: (SQLO_LT_sqeApplication__masterAppLatch) * 
* - Address: (7000002513101c4), Line: 327, File:               * 
* /view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqle_app_servi 
* HoldCount: 1                                                 * 
*                                                              * 
* ...                                                          * 
*                                                              * 
* <StackTrace>                                                 * 
* sqloXlatchConflict                                           * 
* sqlkdDispatchRequest                                         * 
* sqlkdInterrupt                                               * 
* sqlrr2pd                                                     * 
* sqlrkcmt                                                     * 
* sqlrkcm                                                      * 
* sqlrrcom_dps                                                 * 
* sqlrr_xcommit                                                * 
*                                                              * 
* <LatchInformation>                                           * 
* Waiting on latch type:                                       * 
* (SQLO_LT_sqeApplication__masterAppLatch) - Address:          * 
* (7000002513101c4), Line: 997, File:                          * 
* /view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqle_applicati 
*                                                              * 
* Holding Latch type: (SQLO_LT_SQLP_TENTRY__tranEntryLatch) -  * 
* Address: (7000001bc956e68), Line: 748, File:                 * 
* /view/db2_v97fp2_aix64_s100514/vbs/engn/include/sqlpi_inlines. 
* HoldCount: 1                                                 * 
* ================================                             * 
* The deadlatch is constructed by 'masterAppLatch' and         * 
* 'tranEntryLatch'.                                            * 
*                                                              * 
* You will have to recycle the instance to get out of the      * 
* 'dead latch' situation.                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 version 9.7 fp 4                              * 
****************************************************************
Local-Fix:
The problem only occurs when you're getting snapshot. So it can 
be avoided if you don't get any snapshot.
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.12.2010
10.12.2010
10.12.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version