DB2 - Problembeschreibung
Problem IT09273 | Status: Geschlossen |
DB2DIAG.LOG CAN BE FLOODED WITH SQLP_NOTA "TRANSACTION WAS NOT FOUND" | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
Lösung | |
First Fixed in DB2 LUW v10.5 Fixpack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.06.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |