|
Problem IC95299
|
Status: Geschlossen |
ACTIVITYSTMT TABLE OF ACTIVITIES EVENT MONITOR DOES NOT CAPTURE SQL STATEMENTS COMPILED USING THE REOPT ALWAYS BIND OPTION |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
When an activities event monitor is active and detailed activity
collection is enabled through a COLLECT ACTIVITY DATA WITH
DETAILS clause on a WLM object, the ACTIVITYSTMT table does not
capture SQL statements compiled using the REOPT ALWAYS bind
option. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to v10.5 Fix Pack 3 *
**************************************************************** |
| Local-Fix: |
Rebind the SQL statement with the option REOPT ONCE. |
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
Problem first fixed in v10.5 Fix Pack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.08.2013
04.03.2014
04.03.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
