DB2 FOR LUW / DB2FORLUW / A50 - DB2

DB2 LOAD leaves file descriptor open when LOAD temporary files
are greater than 128GB. This means that the disk space is not
freed up in the LOAD temporary disk path and then subsequent
LOADs may fail due to lack of disk space.
This will only occurring when loading data into Column Organized
tables.

There is a limit of 128GB for the temporary files. If the
temporary files are less than 128GB then the files are cleared
up successfully. If they are above this size then the file
descriptor will not be closed successfully and the disk space
will not be freed until the instance is restarted.

****************************************************************
* USERS AFFECTED:                                              *
* ALL DB2 LUW LOAD user with COLUMN ORGANIZED tables.          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Restart the instance to free up the disk space.              *
* Upgrade to the Db2 11.1 level that contains the fix.         *
****************************************************************

Restart the instance to free up the disk space.

not known / see Local fix

forerunner  : 
follow-up : IT27675 

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

12.07.2016
04.01.2019
09.01.2019