|
Problem IC89172
|
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 / A10 - 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: *
* Anybody using an an activities or deadlocks with details *
* history values event monitor *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 10.1 Fix Pack 2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 10.1 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.12.2012
11.04.2013
11.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
