db2数据库内存不足
2010-07-06-11.09.37.853544+480 E5877494A1518 LEVEL: Warning (OS)PID : 1999334 TID : 1 &nb...显示全部
2010-07-06-11.09.37.853544+480 E5877494A1518 LEVEL: Warning (OS)
PID : 1999334 TID : 1 PROC : db2agent (instance) 4
INSTANCE: db2inst1 NODE : 004
APPHDL : 4-362 APPID: *N4.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "There is not enough memory available now."
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
134217728
DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
113512448
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
7602176
CALLSTCK:
[0] 0x0900000001624DF0 sqloLogMemoryCondition + 0x26C
[1] 0x0900000001624ACC sqloLogMemoryCondition@glue212 + 0x74
[2] 0x09000000004CA2E0 sqlogmblkEx + 0xC
[3] 0x0900000001312364 sqledConvertDDtoSqlda + 0x538
[4] 0x0900000001312AEC sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1BC
[5] 0x0900000001312F28 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0xEC
[6] 0x090000000142D0BC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2UCinterface + 0xFFFFFFFFFFFFFFB8
[7] 0x090000000142CEA8 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x274
[8] 0x090000000142C81C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x194
[9] 0x0900000001572150 @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4
2010-07-06-11.09.37.863653+480 E5879013A656 LEVEL: Warning
PID : 1999334 TID : 1 PROC : db2agent (instance) 4
INSTANCE: db2inst1 NODE : 004
APPHDL : 4-362 APPID: *N4.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 :
Out of memory failure for Private Heap on node 4.
Requested block size : 113447212 bytes.
Physical heap size : 327680 bytes.
Configured heap size : 1099511824384 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2010-07-06-11.09.37.869739+480 I5879670A504 LEVEL: Severe
PID : 1999334 TID : 1 PROC : db2agent (instance) 4
INSTANCE: db2inst1 NODE : 004
APPHDL : 4-362 APPID: *N4.db2inst1.100706030935
AUTHID : ETL
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.
2010-07-06-11.09.38.211531+480 E5880175A1518 LEVEL: Warning (OS)
PID : 1814968 TID : 1 PROC : db2agent (instance) 6
INSTANCE: db2inst1 NODE : 006
APPHDL : 6-918 APPID: *N6.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "There is not enough memory available now."
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
134217728
DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
108269568
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
5505024
CALLSTCK:
[0] 0x090000000162DDF0 sqloLogMemoryCondition + 0x26C
[1] 0x090000000162DACC sqloLogMemoryCondition@glue212 + 0x74
[2] 0x09000000004D32E0 sqlogmblkEx + 0xC
[3] 0x090000000131B364 sqledConvertDDtoSqlda + 0x538
[4] 0x090000000131BAEC sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1BC
[5] 0x090000000131BF28 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0xEC
[6] 0x09000000014360BC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2UCinterface + 0xFFFFFFFFFFFFFFB8
[7] 0x0900000001435EA8 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x274
[8] 0x090000000143581C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x194
[9] 0x090000000157B150 @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4
2010-07-06-11.09.38.220755+480 E5881694A656 LEVEL: Warning
PID : 1814968 TID : 1 PROC : db2agent (instance) 6
INSTANCE: db2inst1 NODE : 006
APPHDL : 6-918 APPID: *N6.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 :
Out of memory failure for Private Heap on node 6.
Requested block size : 108247716 bytes.
Physical heap size : 327680 bytes.
Configured heap size : 1099511824384 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2010-07-06-11.09.38.225220+480 I5882351A504 LEVEL: Severe
PID : 1814968 TID : 1 PROC : db2agent (instance) 6
INSTANCE: db2inst1 NODE : 006
APPHDL : 6-918 APPID: *N6.db2inst1.100706030935
AUTHID : ETL
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.
2010-07-06-11.17.44.640774+480 E5882856A1518 LEVEL: Warning (OS)
PID : 803010 TID : 1 PROC : db2agent (instance) 1
INSTANCE: db2inst1 NODE : 001
APPHDL : 1-1563 APPID: *N1.db2inst1.100706031745
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "There is not enough memory available now."
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
241700864
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
7012352
CALLSTCK:
[0] 0x090000000193FDF0 sqloLogMemoryCondition + 0x26C
[1] 0x090000000193FACC sqloLogMemoryCondition@glue212 + 0x74
[2] 0x09000000007E52E0 sqlogmblkEx + 0xC
[3] 0x090000000162D364 sqledConvertDDtoSqlda + 0x538
[4] 0x090000000162DAEC sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1BC
[5] 0x090000000162DF28 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0xEC
[6] 0x09000000017480BC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2UCinterface + 0xFFFFFFFFFFFFFFB8
[7] 0x0900000001747EA8 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x274
[8] 0x090000000174781C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x194
[9] 0x090000000188D150 @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4
2010-07-06-11.17.44.642975+480 E5884375A656 LEVEL: Warning
PID : 803010 TID : 1 PROC : db2agent (instance) 1
INSTANCE: db2inst1 NODE : 001
APPHDL : 1-1563 APPID: *N1.db2inst1.100706031745
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 :
Out of memory failure for Private Heap on node 1.
Requested block size : 241683456 bytes.
Physical heap size : 131072 bytes.
Configured heap size : 1099511824384 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2010-07-06-11.17.44.643176+480 I5885032A504 LEVEL: Severe
PID : 803010 TID : 1 PROC : db2agent (instance) 1
INSTANCE: db2inst1 NODE : 001
APPHDL : 1-1563 APPID: *N1.db2inst1.100706031745
AUTHID : ETL
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.
上述是diag.log的日志内容，请分析一下如何解决，需要调整哪些参数收起
PID : 1999334 TID : 1 PROC : db2agent (instance) 4
INSTANCE: db2inst1 NODE : 004
APPHDL : 4-362 APPID: *N4.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "There is not enough memory available now."
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
134217728
DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
113512448
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
7602176
CALLSTCK:
[0] 0x0900000001624DF0 sqloLogMemoryCondition + 0x26C
[1] 0x0900000001624ACC sqloLogMemoryCondition@glue212 + 0x74
[2] 0x09000000004CA2E0 sqlogmblkEx + 0xC
[3] 0x0900000001312364 sqledConvertDDtoSqlda + 0x538
[4] 0x0900000001312AEC sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1BC
[5] 0x0900000001312F28 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0xEC
[6] 0x090000000142D0BC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2UCinterface + 0xFFFFFFFFFFFFFFB8
[7] 0x090000000142CEA8 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x274
[8] 0x090000000142C81C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x194
[9] 0x0900000001572150 @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4
2010-07-06-11.09.37.863653+480 E5879013A656 LEVEL: Warning
PID : 1999334 TID : 1 PROC : db2agent (instance) 4
INSTANCE: db2inst1 NODE : 004
APPHDL : 4-362 APPID: *N4.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 :
Out of memory failure for Private Heap on node 4.
Requested block size : 113447212 bytes.
Physical heap size : 327680 bytes.
Configured heap size : 1099511824384 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2010-07-06-11.09.37.869739+480 I5879670A504 LEVEL: Severe
PID : 1999334 TID : 1 PROC : db2agent (instance) 4
INSTANCE: db2inst1 NODE : 004
APPHDL : 4-362 APPID: *N4.db2inst1.100706030935
AUTHID : ETL
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.
2010-07-06-11.09.38.211531+480 E5880175A1518 LEVEL: Warning (OS)
PID : 1814968 TID : 1 PROC : db2agent (instance) 6
INSTANCE: db2inst1 NODE : 006
APPHDL : 6-918 APPID: *N6.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "There is not enough memory available now."
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
134217728
DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
108269568
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
5505024
CALLSTCK:
[0] 0x090000000162DDF0 sqloLogMemoryCondition + 0x26C
[1] 0x090000000162DACC sqloLogMemoryCondition@glue212 + 0x74
[2] 0x09000000004D32E0 sqlogmblkEx + 0xC
[3] 0x090000000131B364 sqledConvertDDtoSqlda + 0x538
[4] 0x090000000131BAEC sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1BC
[5] 0x090000000131BF28 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0xEC
[6] 0x09000000014360BC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2UCinterface + 0xFFFFFFFFFFFFFFB8
[7] 0x0900000001435EA8 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x274
[8] 0x090000000143581C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x194
[9] 0x090000000157B150 @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4
2010-07-06-11.09.38.220755+480 E5881694A656 LEVEL: Warning
PID : 1814968 TID : 1 PROC : db2agent (instance) 6
INSTANCE: db2inst1 NODE : 006
APPHDL : 6-918 APPID: *N6.db2inst1.100706030935
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 :
Out of memory failure for Private Heap on node 6.
Requested block size : 108247716 bytes.
Physical heap size : 327680 bytes.
Configured heap size : 1099511824384 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2010-07-06-11.09.38.225220+480 I5882351A504 LEVEL: Severe
PID : 1814968 TID : 1 PROC : db2agent (instance) 6
INSTANCE: db2inst1 NODE : 006
APPHDL : 6-918 APPID: *N6.db2inst1.100706030935
AUTHID : ETL
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.
2010-07-06-11.17.44.640774+480 E5882856A1518 LEVEL: Warning (OS)
PID : 803010 TID : 1 PROC : db2agent (instance) 1
INSTANCE: db2inst1 NODE : 001
APPHDL : 1-1563 APPID: *N1.db2inst1.100706031745
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "There is not enough memory available now."
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
241700864
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
7012352
CALLSTCK:
[0] 0x090000000193FDF0 sqloLogMemoryCondition + 0x26C
[1] 0x090000000193FACC sqloLogMemoryCondition@glue212 + 0x74
[2] 0x09000000007E52E0 sqlogmblkEx + 0xC
[3] 0x090000000162D364 sqledConvertDDtoSqlda + 0x538
[4] 0x090000000162DAEC sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1BC
[5] 0x090000000162DF28 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0xEC
[6] 0x09000000017480BC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2UCinterface + 0xFFFFFFFFFFFFFFB8
[7] 0x0900000001747EA8 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x274
[8] 0x090000000174781C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x194
[9] 0x090000000188D150 @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4
2010-07-06-11.17.44.642975+480 E5884375A656 LEVEL: Warning
PID : 803010 TID : 1 PROC : db2agent (instance) 1
INSTANCE: db2inst1 NODE : 001
APPHDL : 1-1563 APPID: *N1.db2inst1.100706031745
AUTHID : ETL
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 :
Out of memory failure for Private Heap on node 1.
Requested block size : 241683456 bytes.
Physical heap size : 131072 bytes.
Configured heap size : 1099511824384 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2010-07-06-11.17.44.643176+480 I5885032A504 LEVEL: Severe
PID : 803010 TID : 1 PROC : db2agent (instance) 1
INSTANCE: db2inst1 NODE : 001
APPHDL : 1-1563 APPID: *N1.db2inst1.100706031745
AUTHID : ETL
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.
上述是diag.log的日志内容，请分析一下如何解决，需要调整哪些参数收起