|
Problem IC88745
|
Status: Closed |
THE UNIT FOR MEMORY_POOL_USED AND MEMORY_POOL_USED_HWM SHOULD BE IN KB |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC94400
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.11.2012
03.10.2013
03.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
