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 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
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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 FixList