Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.