|
Problem IC75525
|
Status: Closed |
EVMON_FORMAT_UE_TO_TABLES DOES NOT OUTPUT ANYTHING IF PARTIAL EVENT EXISTS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
EVMON_FORMAT_UE_TO_TABLES does not output anything if partial
event exists.
The UE table included the incomplete events.
In case of EVMON_FORMAT_UE_TO_TABLES:
Did not output complete events information to relational
table,
Partial event is mentioned at the following URL.
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?t
opic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0054909.html
$ db2 "SELECT count(*) FROM TABLE (EVMON_FORMAT_UE_TO_XML...
1
-----------
1
Before fix,
EVMON_FORMAT_UE_TO_TABLES returned SQL443N with 0 record.
$ db2 call EVMON_FORMAT_UE_TO_TABLES(...)
SQL0443N
$ db2 "select count(*) from lock_event"
1
-----------
0
After fix, EVMON_FORMAT_UE_TO_TABLES returned SQL443N,but
inserted record.
$ db2 call EVMON_FORMAT_UE_TO_TABLES(...)
SQL0443N
$ db2 "select count(*) from lock_event"
1
-----------
1 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* EVMON_FORMAT_UE_TO_TABLES does not output anything if *
* partial *
* event exists. *
* *
* *
* *
* The UE table included the incomplete events. *
* *
* In case of EVMON_FORMAT_UE_TO_TABLES: *
* *
* Did not output complete events information to relational *
* *
* table, *
* *
* *
* *
* Partial event is mentioned at the following URL. *
* *
* http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.j *
* sp?t *
* opic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0054909.html *
* *
* *
* *
* $ db2 "SELECT count(*) FROM TABLE (EVMON_FORMAT_UE_TO_XML... *
* *
* *
* *
* 1 *
* *
* ----------- *
* *
* 1 *
* *
* *
* *
* Before fix, *
* *
* EVMON_FORMAT_UE_TO_TABLES returned SQL443N with 0 record. *
* *
* $ db2 call EVMON_FORMAT_UE_TO_TABLES(...) *
* *
* SQL0443N *
* *
* $ db2 "select count(*) from lock_event" *
* *
* *
* *
* 1 *
* *
* ----------- *
* *
* 0 *
* *
* *
* *
* After fix, EVMON_FORMAT_UE_TO_TABLES returned SQL443N,but *
* *
* inserted record. *
* *
* *
* *
* $ db2 call EVMON_FORMAT_UE_TO_TABLES(...) *
* *
* SQL0443N *
* *
* $ db2 "select count(*) from lock_event" *
* *
* *
* *
* 1 *
* *
* ----------- *
* *
* 1 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB version 9.7 fixpack 5. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Comment |
LOG_PARTIAL_EVENTS option don't apply to
EVMON_FORMAT_UE_TO_TABLES.
It only apply to EVMON_FORMAT_UE_TO_XML.
So the only way to look at the partial event is to use
EVMON_FORMAT_UE_TO_XML with LOG_PARTIAL_EVENTS option and
format the separate XML document under sqllib/dump.
There is no way to got those partial event into event table.
It is a limitation for the EVMON_FORMAT_UE_TO_TABLES. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC91696
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.04.2011
17.01.2012
17.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
