home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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