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 IC96946 Status: Geschlossen

SQL0901N ERROR TRIGGERED IN SQLKTSND:AT SANITY CHECK IN CODE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
DB2 can trigger an SQL0901N error in sqlktsnd at a sanity check 
in the code resulting 
in the corresponding query failing.  db2diag.log messages like 
the following will be seen: 
 
2013-09-05-08.25.52.151404-300 I492603840E590        LEVEL: 
Error 
PID     : 23393                TID : 46955535263488  PROC : 
db2sysc 80 
INSTANCE: db2admn              NODE : 080            DB   : 
SAMPLE 
APPHDL  : XXX-34385            APPID: *NXXX.db2admn.130905131925 
AUTHID  : DB2INST1                 HOSTNAME: db2inst1 
EDUID   : 433525               EDUNAME: db2agntp (SAMPLE) 80 
FUNCTION: DB2 UDB, buffer Q services, sqlkq_error, probe:50 
MESSAGE : DIA0001E An internal error occurred. Report the 
following error code 
          : "Not enough pro-active resets. numResets = 51, count 
= 64". 
 
2013-09-05-08.26.09.059594-300 I492604431E611        LEVEL: 
Error 
PID     : 23393                TID : 46955535263488  PROC : 
db2sysc 80 
INSTANCE: db2admn              NODE : 080            DB   : 
SAMPLE 
APPHDL  : XXX-34385            APPID: *NXXX.db2admn.130905131925 
AUTHID  : DB2INST1                 HOSTNAME: db2inst1 
EDUID   : 433525               EDUNAME: db2agntp (SAMPLE) 80 
FUNCTION: DB2 UDB, table Q services, sqlktsnd, probe:100 
MESSAGE : DIA0001E An internal error occurred. Report the 
following error code 
          : "Line=00878, rc1=0x82180001, rc2=0x00000000, 
rc3=(nil), 
          msg=sqlkqsnd()".
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Any using the DPF feature                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) for Linux, UNIX, and Windows                         * 
****************************************************************
Local-Fix:
N/A
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix 
Pack 4) for Linux, UNIX, and Windows
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.10.2013
15.09.2014
15.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList