|
Problem IT06597
|
Status: Closed |
LARGE SORT QUERY RUNNING FAILED WITH SQL0901N ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to V10.1 FP5 *
**************************************************************** |
| Local Fix: |
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. |
| Solution |
First fixed in V10.1 FP5 |
| Workaround |
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. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.01.2015
15.07.2015
15.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
