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 |