|
Problem IT09273
|
Status: Closed |
DB2DIAG.LOG CAN BE FLOODED WITH SQLP_NOTA "TRANSACTION WAS NOT FOUND" |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
DIA8036C XA message level INFO logged in db2diag thousand times
every second with DIAGLEVEL 4, 3, 2 and 1
db2diag.log:
0
2015-05-21-14.35.00.820840+120 E5153A1703 LEVEL: Info
PID : 11075784 TID : 145256 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-23765 APPID:
10.42.130.43.54449.150521122913
AUTHID : DB2INST1 HOSTNAME: db2host1
EDUID : 145256 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv,
sqlrr_dispatch_xa_request, probe:703
MESSAGE : ZRC=0x80100024=-2146435036=SQLP_NOTA "Transaction was
not found"
DIA8036C XA error with request type of "". Transaction
was not found.
DATA #1 : String, 27 bytes
XA Dispatcher received NOTA
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x09000000073A6B70 sqlrr_xrollback__FP14db2UCinterface +
0x11E0
[1] 0x0900000007266764 sqljsSyncRollback__FP14db2UCinterface +
0x6E4
[2] 0x090000000910AAA8
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x529C
[3] 0x0000000000000000 ?unknown + 0x0
[4] 0x090000000914D260
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1174
[5] 0x090000000914CE54
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xD68
[6] 0x090000000A65AB90
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
[7] 0x090000000A65B6A0
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5F8
[8] 0x09000000088085AC RunEDU__8sqeAgentFv + 0x48C38
[9] 0x0900000008786240 RunEDU__8sqeAgentFv + 0x124
[10] 0x0900000009CA0DFC EDUDriver__9sqzEDUObjFv + 0x130
[11] 0x0900000008D11664 sqloEDUEntry + 0x390
[12] 0x09000000004F5E10 _pthread_body + 0xF0
[13] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW v10.5 Fixpack 7 or later. *
**************************************************************** |
| Local Fix: |
Can look to fix the application to prevent these message. |
| Solution |
First Fixed in DB2 LUW v10.5 Fixpack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.06.2015
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
