IBM Support

IC75194: MESSAGE "DIA8036C XA ERROR WITH REQUEST TYPE OF "". TRANSACTION WAS NOT FOUND." REPORTED AS SEVERE IN THE DB2DIAG.LOG.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description above.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 FP5 or higher                             *
    ****************************************************************
    

Problem conclusion

  • Problem First Fixed in DB2 Version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75194

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Serviceability

  • Submitted date

    2011-03-23

  • Closed date

    2012-03-08

  • Last modified date

    2012-03-15

  • APAR is sysrouted FROM one or more of the following:

    IC73397

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC75194

Modified date: 15 March 2012