有个db2 测试库,正常情况下主机空闲内存还有6个多G,可是应用一跑程序,内存使用急剧增长,最低时空闲内存就剩下70M,把application force后马上恢复正常。不知道怎么回事?能不能限制DB2只能使用主机的固定大小内存啊
部分db cfg
Self tuning memory (SELF_TUNING_MEM) = OFF
Size of database shared memory (4KB) (DATABASE_MEMORY) = 1048576
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = 3400
Percent. of lock lists per application (MAXLOCKS) = 60
Package cache size (4KB) (PCKCACHESZ) = 1533
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 26964
Sort list heap (4KB) (SORTHEAP) = 1348
Database heap (4KB) (DBHEAP) = 2588
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 260
Log buffer size (4KB) (LOGBUFSZ) = 2048
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 60114
Buffer pool size (pages) (BUFFPAGE) = 1000
Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 53251
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 592
SQL statement heap (4KB) (STMTHEAP) = 4096
Default application heap (4KB) (APPLHEAPSZ) = 128
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1