DB2 FOR LUW / DB2FORLUW / B10 - DB2

Current diagnostic in db2diag.log with Java routines hitting out
of memory include just a callstack for failing allocation:

2019-01-01-00.00.00.000000+000 E184474E412           LEVEL:
Error
PID     : 38760                TID : 140536086259456 PROC :
db2sysc
INSTANCE: db2inst1             NODE : 000
HOSTNAME: db2host
EDUID   : 28786               EDUNAME: db2fmp (Java) 0
FUNCTION: DB2 UDB, oper system services, sqloJVMvfprintf,
probe:20
MESSAGE : JVMDUMP039I Processing dump event "systhrow", detail
"java/lang/OutOfMemoryError"

Under certain memory memory condition, when the heap is nearly
full, one might also see Java routines failing in loadClass:

2019-01-01-00.00.00.000000+000 E184474E412           LEVEL:
Error
PID     : 38760                TID : 140536086259456 PROC :
db2sysc
INSTANCE: db2inst1             NODE : 000
HOSTNAME: db2host
FUNCTION: DB2 UDB, BSU Java support, sqlejCallJavaRoutine_dll,
probe:80
MESSAGE : Class loader loadClass failed. class:
DATA #1 : Hexdump, 8 bytes
0x00007F5C1164A020 : 5370 5365 7276 6572
SpServer


This APAR will improve diagnostics during such a condition by
adding to Db2 diagnostics log:

- information that class loader failures are caused my memory
shortage and can be addressed by increasing JAVA_HEAP_SZ
- diagnostics message will include information about JAR causing
the error

Additionally, a registry variable DB2_ROUTINE_HEAPSZ_CHECK will
be added to automatically mark db2fmps that have full heap
unstable and will cause new Db2fmp process to be created:
db2set DB2_ROUTINE_HEAPSZ_CHECK=ON

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Db2 version 11.1 Fix Pack m4fp5                    *
****************************************************************

Increase JAVA_HEAP_SZ if OOM or loadClass error is hit.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Db2 version 11.1 Fix Pack m4fp5                    *
****************************************************************

First fixed in Db2 version 11.1 Fix Pack m4fp5

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

10.03.2020
10.03.2020
10.03.2020