DB2 FOR LUW / DB2FORLUW / A50 - DB2

The PD_LOG_GET_MSGS routine returns the messages recorded in the 
DB2 notify log.  As the notify log grows in size, calling the 
PD_LOG_GET_MSGS allocates a larger portion of memory, up to a 
limit of 20% of the INSTANCE_MEMORY setting.  This amount of 
memory can be excessive and may either fail to be allocated or 
strain memory resources on the server.  A failure will appears 
as follows in the db2diag.log, though it is possible to receive 
a similar failure executing other routines (Examine the failing 
statement or investigate the SQL statement cache to determine if 
the PD_LOG_GET_MSGS routine is being executed on the server): 
 
EDUID   : 123                  EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, WLM, sqlrwExpandableBuffer::addElement, 
probe:10 
CALLED  : DB2 UDB, WLM, sqlrwExpandableBuffer::addElement 
 
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
 
          "No memory available in 'Application Heap'" 
 
          DIA8301C No memory available in the application heap. 
 
Referencing the sysibmadm.pdlogmsgs_last24hours table function 
may also trigger the high memory allocation.

**************************************************************** 
* USERS AFFECTED:                                              * 
* systems where the PD_LOG_GET_MSGS routine or the             * 
* SYSIBMADM.PDLOGMSGS_LAST24HOURS view are referenced          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Use the workarounds described in the Local Fix section       * 
****************************************************************

Manage the size of the db2 notify log as follows: 
1. On UNIX, archive (or remove) the DB2 notify log ( <db2 
instance>.nfy in the DIAGPATH directory ).  On Windows, archive 
(or clear) the application event log. 
2. Manage the size/contents of the DB2 notify log using the 
DIAGSIZE and/or NOTIFYLEVEL settings.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 Version 10.5 Fix Pack 4

see Local Fix

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

23.04.2014
18.11.2014
18.11.2014