home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList