home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09945 Status: Geschlossen

MEMORY USAGE CAN INCREASE WHEN RUNNING SQL ON OBJECT WITH XML COLUMN.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 7 or Later.                 * 
****************************************************************
Local-Fix:
Lösung
First Fixed in DB2 LUW v10.5 Fixpack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.07.2015
21.01.2016
21.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList