|
Problem IC66409
|
Status: Closed |
MONITOR NOT CAPTURING UNIT OF WORK RECORD WHEN COMMIT IS CHAINED FROM JCC |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The unit of work event monitor in DB2 does not properly record a
unit of work record when executing a commit that is chained at
the DRDA level. This behaviour was observed when executing
queries using a JCC client. Note that the metrics collected for
the aforementioned unit of work do not get lost, rather they are
amalgamated into the record generated at the next unchained unit
of work boundary. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Any users of DB2 LUW utilizing the unit of work event *
* monitor may be affected. *
****************************************************************
* PROBLEM DESCRIPTION: *
* The unit of work event monitor in DB2 does not properly *
* record a unit of work record when executing a unit of work *
* boundary (commit or rollback) that is chained at the DRDA *
* level. This behaviour was observed when executing queries *
* using a JCC client. Note that the metrics collected for the *
* aforementioned unit of work do not get lost, rather they are *
* amalgamated into the record generated at the next unchained *
* unit of work boundary. *
****************************************************************
* RECOMMENDATION: *
* Recommendation is to upgrade to 9.7.2 if the customer is *
* encountering problems with missing unit of work records when *
* using the unit of work event monitor. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
Fix has been delivered to 9.7.2 (DB2 9.7 Fixpack 2). With this
fix, the unit of work event monitor in DB2 will now properly
record a unit of work record at all unit of work boundaries,
including those cases where the commit or rollback request was
chained at the DRDA level. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66432 IC66473
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.02.2010
13.05.2010
13.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.2,
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
