DB2 FOR LUW / DB2FORLUW / B10 - DB2

We reproduced Application Error -901 "no tuple blocks" when
a huge SQL is executed several time in parallel.
DB2 is very constrained on memory and we should return SQL code
-955.


2022-01-03-11.27.11.011269+060 I7121080A924         LEVEL:
Severe
PID     : 23855464             TID : 147792         PROC :
db2sysc 0
INSTANCE: db2inst1	       NODE : 000           DB   : MYDB1
APPHDL  : 0-64145              APPID:
X.X.X.X.0000.220108022121
UOWID   : 20                   ACTID: 1
AUTHID  : DB2INST1             HOSTNAME: MYHOST1
EDUID   : 147792               EDUNAME: db2agent (MYDB1) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 15
 sqlerrmc: no tuple blocks
 sqlerrp : SQLRI109
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
0x00000000
           (4) 0x00000000      (5) 0xFFFFED42      (6)
0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
 sqlstate:

The stack is:

sqlzeSqlCode(sqeAgent *, unsigned int, unsigned long, unsigned
long, sqlca *, int, unsigned short, char *) + 0x27C
sqlrrSqlCode + 0x18C
sqlri_hsjnLoadTupleCollection(sqlrr_cb *, sqlri_hsjno *,
sqlri_hsjnPartitionBucket *, bool *) + 0x62C
sqlri_hsjnLeftoversReturnMatch(sqlrr_cb *, sqlri_hsjno *) +
0x27EC
sqlrihsjn(sqlrr_cb *) + 0xFA4
sqlrihsjn(sqlrr_cb *) + 0x16D8
sqlrihsjn(sqlrr_cb *) + 0x16D8
sqlrihsjn(sqlrr_cb *) + 0x16D8
sqlriSectInvoke(sqlrr_cb *, sqlri_opparm *) + 0x628
sqlrr_process_fetch_request(db2UCinterface *) + 0xD14
sqlrr_open(db2UCinterface *, db2UCCursorInfo *) + 0xF84
sqljs_ddm_opnqry(db2UCinterface *, sqljDDMObject *) + 0x4C0
sqljsParseRdbAccessed(sqljsDrdaAsCb *, sqljDDMObject *,
db2UCinterface *) + 0x298
sqljsParse(sqljsDrdaAsCb *, db2UCinterface *, sqeAgent *, bool)
+ 0x2264
IPRA.$sqljsSqlam(db2UCinterface *, sqeAgent *, bool) + 0xEC8
sqljsDriveRequests(sqeAgent *, db2UCconHandle *) + 0xB4
IPRA.$sqljsDrdaAsInnerDriver(SQLCC_INITSTRUCT_T *, bool) +
0x13F0
sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T *) + 0x33C
sqeAgent::RunEDU(void) + 0xB60
sqzEDUObj::EDUDriver(void) + 0x300
sqloEDUEntry + 0x360

The problem will be fixed in next releases.

Increase SORTHEAP to a larger value would resolve the problem.

The problem will be fixed in next releases.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.03.2022
11.05.2022
11.05.2022