DB2 FOR LUW / DB2FORLUW / A50 - DB2

INGEST uses approximately SHM_MAX_SIZE of base memory, plus it 
may use a varying amount of overflow memory. 
 
There is no limit to the amount of overflow memory, and in 
some scenarios we are using excessive amount overflow memory 
and it may impact system resources. 
 
INGEST client db2diag.log may have below message: 
----- 
2017-05-10-01.02.53.069040+540 I3326440A717         LEVEL: 
Warning 
PID     : 13566156             TID : 258            PROC : db2bp 
 
INSTANCE: db2inst1             NODE : 000 
HOSTNAME: DB2INST1 
EDUID   : 258 
FUNCTION: DB2 UDB, Ingest utility, 
SqludiFieldSetOverflowMemory::sqludiFreeAllFieldSetOverflowBlock 
s, 
probe:10 
DATA #1 : String, 282 bytes 
During the ingest operation, in order to improve performance or 
to 
avoid a 
deadlock, the utility needed to allocate additional memory. 
This can be 
avoided by increasing the value of ingest configuration 
parameter 
shm_max_size by the number of bytes indicated by data item #2 
below. 
DATA #2 : unsigned integer, 8 bytes 
38386936936 
DATA #3 : unsigned integer, 8 bytes 
24 
-----

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 10.5                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.5 FixPack 9.                           * 
****************************************************************

No workaround available.

Problem was first fixed in DB2 UDB Version 10.5 FixPack 9.

not known / see Local fix

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

06.06.2017
27.09.2017
27.09.2017

9.0.