|
Problem IC95378
|
Status: Closed |
PARTIAL EVENT MESSAGES LOGGED IN DB2DIAG.LOG FROM EVMON_FORMAT_UE_TO_XML TABLE FUNCTION |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - 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 using UNFORMATTED EVENT TABLE event monitors *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version 10.5 FP3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
First fixed in version 10.5 FP3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
