aix上报SQL1084C Shared memory segments cannot be allocated?

aix上报这个SQL1084C Shared memory segments cannot be allocated,不知道调整哪些参数,有什么调优的步骤吗

bash-4.3$ ulimit -a
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) unlimited
pipe size (512 bytes, -p) 64
stack size (kbytes, -s) 4194304
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited

db2diag.log
2018-01-18-15.00.22.846449+480 I1941024A848 LEVEL: Warning
PID : 10289214 TID : 1 PROC : db2agent (TEST2) 0
INSTANCE: db2inst2 NODE : 000
APPHDL : 0-23 APPID: *LOCAL.db2inst2.180118070023
AUTHID : DB2INST2
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:1516
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG

      "No Storage Available for allocation"
      DIA8305C Memory allocation failure occurred.

DATA #1 : String, 286 bytes
Failed to allocate the desired database shared memory set.
Check to make sure the configured DATABASE_MEMORY + overflow
does not exceed the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
72876032

2018-01-18-15.00.22.860798+480 I1941873A763 LEVEL: Severe
PID : 10289214 TID : 1 PROC : db2agent (TEST2) 0
INSTANCE: db2inst2 NODE : 000
APPHDL : 0-23 APPID: *LOCAL.db2inst2.180118070023
AUTHID : DB2INST2
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:1718
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG

      "No Storage Available for allocation"
      DIA8305C Memory allocation failure occurred.

DATA #1 : String, 202 bytes
Failed to allocate the minimum possible database shared memory set.
There is insufficient system resources to allocate the database
shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
67502080

2018-01-18-15.00.22.863034+480 I1942637A485 LEVEL: Severe
PID : 10289214 TID : 1 PROC : db2agent (TEST2) 0
INSTANCE: db2inst2 NODE : 000

APPHDL : 0-23 APPID: *LOCAL.db2inst2.180118070023
AUTHID : DB2INST2
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:20
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG

      "No Storage Available for allocation"
      DIA8305C Memory allocation failure occurred.

2018-01-18-15.00.22.863574+480 I1943123A302 LEVEL: Error
PID : 17629196 TID : 1 PROC : db2bp
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpsrllf, probe:317
MESSAGE : Rollforward failed to connect to database. sqlcode -1084.

2018-01-18-15.02.28.514163+480 I1943426A446 LEVEL: Severe
PID : 26738808 TID : 1 PROC : db2agent (instance) 0
INSTANCE: db2inst2 NODE : 000
APPHDL : 0-24 APPID: *LOCAL.db2inst2.180118070228
AUTHID : DB2INST2
FUNCTION: DB2 UDB, oper system services, sqloInitShrEDUWaitElem, probe:210
DATA #1 : Hexdump, 8 bytes
0x09001000A1CAD730 : 0780 0000 0001 CD40 .......@

9B867864E569C09B476E60DDE54736EC.jpg

9B867864E569C09B476E60DDE54736EC.jpg

79E9B6CE7546B49216E35043A6B9973C.jpg
79E9B6CE7546B49216E35043A6B9973C.jpg

7277FAE355255EE5A9CDC8C20E344846.jpg
7277FAE355255EE5A9CDC8C20E344846.jpg

参与5

1同行回答

wangmjwangmj系统运维工程师CES
这个报错是db2数据库报出来的,你可以直接在db2对应的sql文档里面查下,我看其他同事查询出来的结果也有解决的建议一般。显示全部

这个报错是db2数据库报出来的,你可以直接在db2对应的sql文档里面查下,我看其他同事查询出来的结果也有解决的建议一般。

收起
银行 · 2018-01-18
浏览2733

提问者

lmj92
研发工程师seabed

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2018-01-18
  • 关注会员:2 人
  • 问题浏览:2971
  • 最近回答:2018-01-18
  • X社区推广