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

AN APPLICATION MAY APPEAR TO BE STUCK IN "UOW EXECUTING" STATE
WHEN EXECUTING A PLAN CONTAINING AN INDEX AND OPERATION.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
An application may appear to be stuck in "UOW Executing" state 
when executing query with an execution plan that includes an 
index AND operation. It will be characterised by high CPU usage 
for one or more EDUs processing the query on behalf of the 
application. 
 
Index ANDing represents the logical AND of results from multiple 
index scans on the same source object to satisfy the filtering 
criteria or to merge the results of semi-joins used in star 
joins. 
 
Examination of the stack for an EDU involved in this processing 
will be similar to the following: 
========================================== 
sqlri_BFBandP 
sqliScanLeaf2NoLocking 
sqlifnxt 
sqlirdk 
sqldIndexFetch 
sqldIndexFetch 
sqldRowFetch 
...... 
========================================== 
 
The application isn't truly hung but may take an unrealistic 
amount of time to complete and may be forced using the FORCE 
APPLICATION command.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.7 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* An application may appear to be stuck in "UOW Executing"     * 
* state when executing query with an execution plan that       * 
* includes an index AND operation. It will be characterised by * 
* high CPU usage for one or more EDUs processing the query on  * 
* behalf of the application.                                   * 
*                                                              * 
* Index ANDing represents the logical AND of results from      * 
* multiple index scans on the same source object to satisfy    * 
* the filtering criteria or to merge the results of semi-joins * 
* used in star joins.                                          * 
*                                                              * 
* Examination of the stack for an EDU involved in this         * 
* processing will be similar to the following:                 * 
* ==========================================                   * 
* sqlri_BFBandP                                                * 
* sqliScanLeaf2NoLocking                                       * 
* sqlifnxt                                                     * 
* sqlirdk                                                      * 
* sqldIndexFetch                                               * 
* sqldIndexFetch                                               * 
* sqldRowFetch                                                 * 
* ......                                                       * 
* ==========================================                   * 
*                                                              * 
* The application isn't truly hung but may take an unrealistic * 
* amount of time to complete and may be forced using the FORCE * 
* APPLICATION command.                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 FixPak 5 or higher levels.    * 
****************************************************************
Local-Fix:
Use the query explain tools to check the access plan for the 
executing SQL and create necessary indices to avoid the index 
AND operations.
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
First fixed in DB2 UDB Version 9.7 FixPak 5.
Workaround
Use the query explain tools to check the access plan for the 
executing SQL and create necessary indices to avoid the index 
AND operations.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.08.2011
02.01.2012
02.01.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.5 FixList