如题，数据库运行一些命令时老是报错如下：2014-08-18-14.03.03.254913+480 E518946233A1490 LEVEL: Warning (OS)
PID : 1699904 TID : 1 PROC : db2agent (instance) 0
INSTANCE: pjt NODE : 000
APPHDL : 0-1744 APPID: *LOCAL.pjt.140818060303
AUTHID : UNIONMON
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "Not enough space"
MESSAGE : Private memory and/or virtual address space exhausted, or data ulimit
exceeded
DATA #1 : Soft data resource limit, PD_TYPE_RLIM_DATA_CUR, 8 bytes
251657728
DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
150802432
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
8650752
CALLSTCK:
[0] 0x09000000026532B4 sqloLogMemoryCondition + 0x26C
[1] 0x0900000002652F90 sqloLogMemoryCondition@glue216 + 0x74
[2] 0x0900000003543018 sqlogmblkEx + 0xC
[3] 0x0900000003342CE0 sqledConvertDDtoSqlda + 0x348
[4] 0x09000000033433A8 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1BC
[5] 0x09000000033D8554 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0xD4
[6] 0x09000000033E4FBC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2UCinterface + 0xFFFFFFFFFFFFFFB8
[7] 0x09000000033E4DC8 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x27C
[8] 0x09000000033E6248 @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0xC4
[9] 0x0900000002F0E204 @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0x98
2014-08-18-14.03.03.255248+480 E518947724A654 LEVEL: Warning
PID : 1699904 TID : 1 PROC : db2agent (instance) 0
INSTANCE: pjt NODE : 000
APPHDL : 0-1744 APPID: *LOCAL.pjt.140818060303
AUTHID : UNIONMON
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 :
Out of memory failure for Private Heap on node 0.
Requested block size : 150777024 bytes.
Physical heap size : 196608 bytes.
Configured heap size : 1099511824384 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2014-08-18-14.03.03.255344+480 I518948379A502 LEVEL: Severe
PID : 1699904 TID : 1 PROC : db2agent (instance) 0
INSTANCE: pjt NODE : 000
APPHDL : 0-1744 APPID: *LOCAL.pjt.140818060303
AUTHID : UNIONMON
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCallDL, probe:20
RETCODE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM
"No Memory Available (reason code is id of requested heap)"
DIA8300C A memory heap error has occurred.
——————————————————————————————————————————————————
比如我看动态sql：db2pd -d dbname -dyn
看dyn的快照视图:db2 "select * from sysibmadm.snapdyn_sql"
一运行，db2diag日志就是报这些错误，关于内存这块，不知道该如何下手。
$ db2level
DB21085I Instance "pjt" uses "64" bits and DB2 code release "SQL09011" with
level identifier "01020107".
Informational tokens are "DB2 v9.1.0.1", "s061104", "U809676", and Fix Pack
"1".
Product is installed at "/opt/IBM/db2/V9.1".
$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 245760
stack(kbytes) 16384
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 2000
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 80000
Sort list heap (4KB) (SORTHEAP) = 40000
Database heap (4KB) (DBHEAP) = 16384
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 90359
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 8096
SQL statement heap (4KB) (STMTHEAP) = 40000
Default application heap (4KB) (APPLHEAPSZ) = 60000
Statistics heap size (4KB) (STAT_HEAP_SZ) = 16384收起