home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC96553 Status: Closed

SQL0901N ERROR TRIGGERED IN SQLKTSND:AT SANITY CHECK IN CODE

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Any users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to V10.1 Fixpack 4 or later                           * 
****************************************************************
Local Fix:
N/A
available fix packs:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
Solution
Problem first fixed in V10.1 Fixpack 4
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC96946 
follow-up :
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.10.2013
18.06.2014
18.06.2014
Problem solved at the following versions (IBM BugInfos)


Problem solved according to the fixlist(s) of the following version(s)


10.1.0.4

FixList