互联网服务db2 9.1
数据库报错There are not enough system resources to process the request
如题，数据库运行一些命令时老是报错如下：2014-08-18-14.03.03.254913+480 E518946233A1490 LEVEL: Warning (OS)PID : 1699904 TID : 1 &nb...显示全部
查看其它 11 个回答wonder_191的回答
回复 2# 繁华如梦
vmstat的同时执行db2 "select * from sysibmadm.snapdyn_sql"
System configuration: lcpu=32 mem=126464MB
kthr memory page faults cpu
------- --------------------- ------------------------------------ ------------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
2 0 24852159 10022899 0 0 0 0 0 0 3165 49302 6198 8 2 75 15
2 0 24852972 10022044 0 0 0 0 0 0 2629 113281 6614 21 1 63 15
7 0 24852980 10022030 0 0 0 0 0 0 2630 45932 6382 11 1 72 15
7 0 24855077 10019926 0 0 0 0 0 0 3084 48631 16481 23 2 63 12
5 0 24856185 10018808 0 0 0 0 0 0 3609 82282 7758 20 2 60 18
3 0 24856186 10018804 0 0 0 0 0 0 3469 57218 5890 8 1 72 18
4 0 24856814 10018165 0 0 0 0 0 0 3592 63775 7928 13 7 64 15
$ db2mtrk -i -d -v
Tracking Memory on: 2014/08/18 at 15:44:38
Memory for instance
Database Monitor Heap is of size 589824 bytes
Other Memory is of size 14221312 bytes
Total: 14811136 bytes
Memory for database: PJT
Backup/Restore/Util Heap is of size 327680 bytes
Package Cache is of size 2355691520 bytes
Catalog Cache Heap is of size 23789568 bytes
Buffer Pool Heap (3) is of size 23058710528 bytes
Buffer Pool Heap (2) is of size 11182735360 bytes
Buffer Pool Heap (1) is of size 2795765760 bytes
Buffer Pool Heap (System 32k buffer pool) is of size 1114112 bytes
Buffer Pool Heap (System 16k buffer pool) is of size 851968 bytes
Buffer Pool Heap (System 8k buffer pool) is of size 720896 bytes
Buffer Pool Heap (System 4k buffer pool) is of size 655360 bytes
Shared Sort Heap is of size 29163520 bytes
Lock Manager Heap is of size 2248015872 bytes
Database Heap is of size 25100288 bytes
Other Memory is of size 196608 bytes
Total: 41722839040 bytes
vmstat的同时执行db2 "select * from sysibmadm.snapdyn_sql"
System configuration: lcpu=32 mem=126464MB
kthr memory page faults cpu
------- --------------------- ------------------------------------ ------------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
2 0 24852159 10022899 0 0 0 0 0 0 3165 49302 6198 8 2 75 15
2 0 24852972 10022044 0 0 0 0 0 0 2629 113281 6614 21 1 63 15
7 0 24852980 10022030 0 0 0 0 0 0 2630 45932 6382 11 1 72 15
7 0 24855077 10019926 0 0 0 0 0 0 3084 48631 16481 23 2 63 12
5 0 24856185 10018808 0 0 0 0 0 0 3609 82282 7758 20 2 60 18
3 0 24856186 10018804 0 0 0 0 0 0 3469 57218 5890 8 1 72 18
4 0 24856814 10018165 0 0 0 0 0 0 3592 63775 7928 13 7 64 15
$ db2mtrk -i -d -v
Tracking Memory on: 2014/08/18 at 15:44:38
Memory for instance
Database Monitor Heap is of size 589824 bytes
Other Memory is of size 14221312 bytes
Total: 14811136 bytes
Memory for database: PJT
Backup/Restore/Util Heap is of size 327680 bytes
Package Cache is of size 2355691520 bytes
Catalog Cache Heap is of size 23789568 bytes
Buffer Pool Heap (3) is of size 23058710528 bytes
Buffer Pool Heap (2) is of size 11182735360 bytes
Buffer Pool Heap (1) is of size 2795765760 bytes
Buffer Pool Heap (System 32k buffer pool) is of size 1114112 bytes
Buffer Pool Heap (System 16k buffer pool) is of size 851968 bytes
Buffer Pool Heap (System 8k buffer pool) is of size 720896 bytes
Buffer Pool Heap (System 4k buffer pool) is of size 655360 bytes
Shared Sort Heap is of size 29163520 bytes
Lock Manager Heap is of size 2248015872 bytes
Database Heap is of size 25100288 bytes
Other Memory is of size 196608 bytes
Total: 41722839040 bytes
浏览3420