|
Problem IC84526
|
Status: Closed |
EVENT MONITOR STMT_VALUE_DATA ELEMENT NOT POPULATED IF STMT_VALUE_TYPE IS GRAPHIC, VARGRAPHIC, NCHAR OR NVARCHAR |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
For an activities or deadlocks with details history values event
monitor a string representation of a data value for an SQL
statement won't be recorded in the stmt_value_data element if
the type of data value is GRAPHIC or VARGRAPHIC. Since NCHAR
and NVARCHAR are synonyms for GRAPHIC and NVARCHAR respectively
this also applies to data values of type NCHAR and NVARCHAR. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First Fixed in DB2 V9.7 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC89172
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2012
17.12.2012
17.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
