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 IC93690 Status: Closed

PARTIAL EVENT MESSAGES LOGGED IN DB2DIAG.LOG FROM EVMON_FORMAT_UE_TO_XML
TABLE FUNCTION

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
The following two error messages can be reported in db2diag.log 
when partial events are encountered by EVMON_FORMAT_UE_TO_XML 
table function: 
 
2013-01-15-16.06.14.427750+060 I618515A1224       LEVEL: Error 
PID     : 1966632              TID  : 180165      PROC : db2sysc 
0 
INSTANCE: db2inst3             NODE : 000         DB   : MYDB 
APPHDL  : 0-17200              APPID: 
10.40.79.37.62915.130212161545 
AUTHID  : DB2USR 
EDUID   : 180165               EDUNAME: db2agent (MYDB) 0 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : Superceding prev. error, probe 165, SQLCA: 
DATA #1 : Hexdump, 136 bytes 
0x0A000000BDFF7A70 : 5351 4C43 4120 2020 0000 0088 0000 0064 
SQLCA   .......d 
0x0A000000BDFF7A80 : 0000 2020 2020 2020 2020 2020 2020 2020 
.. 
0x0A000000BDFF7A90 : 2020 2020 2020 2020 2020 2020 2020 2020 
 
0x0A000000BDFF7AA0 : 2020 2020 2020 2020 2020 2020 2020 2020 
 
0x0A000000BDFF7AB0 : 2020 2020 2020 2020 2020 2020 2020 2020 
 
0x0A000000BDFF7AC0 : 2020 2020 2020 2020 5351 4C52 4930 3146 
SQLRI01F 
0x0A000000BDFF7AD0 : 8004 0001 0000 0001 0000 0000 0000 0000 
................ 
0x0A000000BDFF7AE0 : 0000 0000 0000 0000 2020 2020 2020 2020 
........ 
0x0A000000BDFF7AF0 : 2020 2030 3230 3030 
02000 
 
2013-01-15-16.06.14.429119+060 I619740A496        LEVEL: Error 
PID     : 1966632              TID  : 180165      PROC : db2sysc 
0 
INSTANCE: db2inst3             NODE : 000         DB   : MYDB 
APPHDL  : 0-17200              APPID: 
10.40.79.37.62915.130212161545 
AUTHID  : DB2USR 
EDUID   : 180165               EDUNAME: db2agent (MYDB) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_fetch_error, 
probe:300 
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT 
          "SQLCA has already been built" 
 
These messages can be ignored. This APAR will make so that they 
are not un-necessarily reported in db2diag.log file.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to version 10.1 Fix Pack 3                           * 
****************************************************************
Local Fix:
available fix packs:
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
first fixed in version 10.1 Fix Pack 3
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.06.2013
01.10.2013
01.10.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList