DB2 FOR LUW / DB2FORLUW / A10 - DB2

Problem Abstract:  The unit for memory_pool_used and 
memory_pool_used_hwm should be in KB 
---------------------------------------------------------------- 
------------------------------------------------- 
 
It's easy to reproduce the problem 
 
Problem Desc: 
----------------- 
The values for memory_pool_used and memory_pool_used_hwm are not 
shown in Kb: 
Here are the steps to check the values: 
 
1- Verify the database parameter - Locklist 
 Max storage for lock list (4KB)                 (LOCKLIST) 
=AUTOMATIC(4120) 
 
2- Run the command below to get the values: 
 
SELECT coalesce(varchar(memory_set_type, 20),'total') AS 
set_type, varchar(memory_pool_type,20) AS pool_type, 
varchar(db_name, 20) AS db_name, APPLICATION_HANDLE, 
memory_pool_used as "MEMORY_POOL_USED (kb)", 
memory_pool_used_hwm as "MEMORY_POOL_USED_HWM(kb)" FROM 
TABLE(MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER,  -2)) 
 
SET_TYPE         POOL_TYPE             DB_NAME 
APPLICATION_HANDLE                         MEMORY_POOL_USED 
(kb)             MEMORY_POOL_USED_HWM(kb) 
-------------------- -------------------- -------------------- 
----------------------------------- 
---------------------------------------- 
------------------------------------------------- 
DATABASE        LOCK_MGR             TESTE1               - 
17498112                                       17498112 
DATABASE        DATABASE             TESTE1               - 
15335424                                       15335424 
 
As the LOCKLIST  value is 4120 pages of 4Kb the MEMORY_POOL_USED 
AND MEMORY_POOL_USED_HWM should be 16480Kb (4120 * 4) 
The result above shows 17498112 instead of 16480

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 3                       * 
****************************************************************

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.1 Fix Pack 3

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC94400 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

29.11.2012
03.10.2013
03.10.2013