DB2 FOR LUW / DB2FORLUW / 970 - DB2

Memory usage can increase WHEN RUNNING SQL on object with XML 
column. 
It can also result in an instance crash if we run out of memory 
on the instance/machine. 
 
Requirements to see this APAR: 
 
- Database is created with Collating using 
UCA500R1_LEN_AN_CX_EX_FX_HX_NX_S1. 
- SQL uses a table that has an XML column. 
- Table may also require XML Indexes. 
- The SQL uses XMLTABLE and/or XMLNAMESPACES. 
 
Can check for this by running the following during or just after 
the SQL: 
 
syscpid=`db2pd -edu | grep "db2sysc PID:" | awk  '{ print $3}'` 
db2pd -memblocks sort pid=${syscpid} |head -20 
 
The output will show the following: 
 
Address            DataAddress        PoolID     PoolName 
BlkAge Size(Bytes)  I LOC   File 
Total set size: 0 bytes 
 
Memory blocks sorted by size: 
PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File 
 
0                     205489369            295026     110 
sqlnlsICUcallback.C

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to  DB2 LUW v9.7 Fixpack 11 or Later.                * 
****************************************************************

First Fixed in DB2 LUW v9.7 Fixpack 11.

not known / see Local fix

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

09.07.2015
08.10.2015
08.10.2015

9.7.FP11