DB2 - Problem description
| Problem IC66756 | Status: Closed |
SYSIBMADM.ENV_SYS_RESOURCES - MEMORY_SWAP_FREE IS GREATER THAN MEMORY_SWAP_TOTAL (KMA) | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
sysibmadm.env_sys_resources - MEMORY_SWAP_FREE is greater than
MEMORY_SWAP_TOTAL
MEMORY_SWAP_TOTAL 1463
MEMORY_SWAP_FREE 1565
DB2: DB2 v9.5.100.179,
BLD_LEVEL: s080328
OS : WIN32_NT 5.2
Service Pack: Service Pack 2
sysibmadm.env_sys_resources
NAME VALUE
DATATYPE UNIT DBPARTITIONNUM
---------------------- ----------------------------------
------------ ------- --------------
OS_NAME WIN32_NT
VARCHAR(256) NULL 0
HOST_NAME OPM
VARCHAR(256) NULL 0
OS_VERSION 5.2
VARCHAR(256) NULL 0
OS_RELEASE Service Pack 2
VARCHAR(256) NULL 0
MACHINE_IDENTIFICATION x86 Family 6, model 15, stepping 6
VARCHAR(256) NULL 0
CPU_TOTAL 4
BIGINT NULL 0
CPU_ONLINE 4
BIGINT NULL 0
CPU_CONFIGURED 4
BIGINT NULL 0
CPU_SPEED 2992
BIGINT MHz 0
CPU_HMT_DEGREE 1
BIGINT NULL 0
CPU_CORES_PER_SOCKET 2
BIGINT NULL 0
MEMORY_TOTAL 16384
BIGINT MB 0
MEMORY_FREE 13631
BIGINT MB 0
MEMORY_SWAP_TOTAL 1463
BIGINT MB 0
MEMORY_SWAP_FREE 1565
BIGINT MB 0
VIRTUAL_MEM_TOTAL 17847
BIGINT MB 0
VIRTUAL_MEM_FREE 15196
BIGINT MB 0
CPU_USAGE_TOTAL 37
SMALLINT PERCENT 0
sysibmadm.env_inst_info
INST_NAME IS_INST_PARTITIONABLE NUM_DBPARTITIONS INST_PTR_SIZE
RELEASE_NUM SERVICE_LEVEL BLD_LEVEL PTF FIXPACK_NUM
--------- --------------------- ---------------- -------------
----------- ---------------- --------- ------- -----------
DB2 1 1 32
03020107 DB2 v9.5.100.179 s080328 WR21402 1
sysibmadm.env_prod_info
INSTALLED_PROD INSTALLED_PROD_FULLNAME LICENSE_INSTALLED
PROD_RELEASE LICENSE_TYPE
-------------- ----------------------------- -----------------
------------ ------------
ESE DB2_ENTERPRISE_SERVER_EDITION N
9.5 TRIAL
CONSV DB2_CONNECT_SERVER N
9.5 TRIAL
sysibmadm.env_sys_info
OS_NAME OS_VERSION OS_RELEASE HOST_NAME TOTAL_CPUS
CONFIGURED_CPUS TOTAL_MEMORY
-------- ---------- -------------- --------- ----------
--------------- ------------
WIN32_NT 5.2 Service Pack 2 OPM 4
4 16384 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Windows platforms * **************************************************************** * PROBLEM DESCRIPTION: * * The routune sysibmadm.env_sys_resources might return * * theMEMORY_SWAP_FREE value that is greater * * thanMEMORY_SWAP_TOTAL * **************************************************************** * RECOMMENDATION: * * Upgrade to version V97FP2 * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC67250 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.03.2010 25.05.2010 25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.2 |
|