DB2 FOR LUW / DB2FORLUW / A10 - DB2

DB2 may abnormally end in fast integer sort functions. Symptoms 
are as follows: 
 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "negative fisFreeBuffSize".)  SQLSTATE=58004 
 
db2diag.log messages: 
 
2014-10-31-00.16.00.329839+060 I56539A617           LEVEL: 
Severe 
PID     : 7012842              TID : 144189         PROC : 
db2sysc 0 
INSTANCE: db2inst1               NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-9453               APPID: 
123.12.123.02.42794.141234567853 
AUTHID  : DB2INST1                HOSTNAME: SERVER1 
EDUID   : 144189               EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, runtime interpreter, sqlrifisSetupSqsMem, 
probe:12557 
MESSAGE : SQL0901N  The SQL statement or command failed because 
of a database 
          system error. (Reason "".) 
DATA #1 : String, 24 bytes 
negative fisFreeBuffSize

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V10.1 FP5                                  * 
****************************************************************

Disable FIS: 
db2stop 
db2set DB2_TCG_DEFAULT_OPTIONS="set num_page_fast_int_sort 0" 
db2start 
Test need to be done, as this can impact performance.

First fixed in V10.1 FP5

Disable FIS: 
db2stop 
export DB2STDIO=true 
db2set DB2_TCG_DEFAULT_OPTIONS="set num_page_fast_int_sort 0" 
db2start 
Test need to be done, as this can impact performance.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

19.01.2015
15.07.2015
15.07.2015