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 .......@