DB2 - Problem description
| Problem IC73397 | Status: Closed |
MESSAGE "DIA8036C XA ERROR WITH REQUEST TYPE OF "". TRANSACTION WAS NOT FOUND." REPORTED AS SEVERE IN THE DB2DIAG.LOG. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problem description: | |
A message like the one below, marked as "Severe", is reported in
the db2diag.log. This message should not be marked as Severe.
Message (IP Address has been substituted by x to protect privacy
of the data):
2010-12-10-05.32.22.500140-360 I667030A561 LEVEL: Severe
PID : 2765126 TID : 108732 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :
PROD_PSC
APPHDL : 0-31436 APPID: x.x.x.x.57561.101210113223
AUTHID : DB2ADMIN
EDUID : 108732 EDUNAME: db2agent (db1) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:57
RETCODE : ZRC=0x80100024=-2146435036=SQLP_NOTA "Transaction was
not
found"
DIA8036C XA error with request type of "". Transaction
was not found. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 9.5 users at fix pack 7 release or earlier. * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 server is incorrectly logging the message "DIA8036C XA * * ERROR WITH REQUEST TYPE OF "". TRANSACTION WAS NOT FOUND." * * as a SEVERE entry in DB2's diagnostic log (db2diag.log). * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.5 FP 8 * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
| Solution | |
DB2 will ignore the NOTA message in XA case as of fix pack 8 | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC75194 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.12.2010 11.07.2011 11.07.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.5.FP8 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.5.0.8 |
|