服务器内存16G,原始备份也是从相同内存环境的服务器上拷贝过来的。
但是在另一台全新安装了DB2的服务器上恢复成功之后发出connect to db_name命令之后
服务器报出SQL1084c Shared memory segments cannot be allocated. SQLSTATE=57019
查看db2diag.log 发现如下问题,该如何解决?
2015-11-07-03.02.53.806902+480 E1588E948 LEVEL: Warning
PID : 3041 TID : 140357962557184PROC : db2sysc
INSTANCE: db2admin NODE : 000 DB : RMIS
APPHDL : 0-8 APPID: *LOCAL.db2admin.151106190253
AUTHID : DB2ADMIN
EDUID : 18 EDUNAME: db2agent (RMIS)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCalcAutoScaleFactor, probe:100
MESSAGE : Current DB configuration exceeds free INSTANCE_MEMORY. Self-tuning
memory manager resetting automatic memory consumers to default
values.
DATA #1 : unsigned integer, 8 bytes
2737438720
DATA #2 : unsigned integer, 8 bytes
2712797184
DATA #3 : unsigned integer, 8 bytes
2147483648
DATA #4 : unsigned integer, 8 bytes
6651170816
DATA #5 : unsigned integer, 8 bytes
2081947648
DATA #6 : unsigned integer, 8 bytes
51076056
DATA #7 : unsigned integer, 8 bytes
2030871592
DATA #8 : Decimal, 8 bytes
-1
2015-11-07-03.02.53.808364+480 I2537E892 LEVEL: Warning
PID : 3041 TID : 140357962557184PROC : db2sysc
INSTANCE: db2admin NODE : 000 DB : RMIS
APPHDL : 0-8 APPID: *LOCAL.db2admin.151106190253
AUTHID : DB2ADMIN
EDUID : 18 EDUNAME: db2agent (RMIS)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:130
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM
"No Memory Available (reason code is id of requested heap)"
DIA8300C A memory heap error has occurred.
DATA #1 : String, 23 bytes
Could not steal memory.
DATA #2 : String, 11 bytes
DB-RMIS
DATA #3 : unsigned integer, 8 bytes
0
DATA #4 : unsigned integer, 8 bytes
2737438720
DATA #5 : String, 7 bytes
PRIVATE
DATA #6 : unsigned integer, 8 bytes
3276800
DATA #7 : unsigned integer, 8 bytes
720896
2015-11-07-03.02.53.808489+480 I3430E919 LEVEL: Warning
PID : 3041 TID : 140357962557184PROC : db2sysc
INSTANCE: db2admin NODE : 000 DB : RMIS
APPHDL : 0-8 APPID: *LOCAL.db2admin.151106190253
AUTHID : DB2ADMIN
EDUID : 18 EDUNAME: db2agent (RMIS)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:150
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM
"No Memory Available (reason code is id of requested heap)"
DIA8300C A memory heap error has occurred.
DATA #1 : String, 36 bytes
Not enough cached memory, giving up.
DATA #2 : String, 11 bytes
DB-RMIS
DATA #3 : unsigned integer, 8 bytes
0
DATA #4 : unsigned integer, 8 bytes
2737438720
DATA #5 : unsigned integer, 8 bytes
720896
DATA #6 : unsigned integer, 8 bytes
66453504
DATA #7 : unsigned integer, 8 bytes
2147483648
2015-11-07-03.02.53.808587+480 I4350E994 LEVEL: Error
PID : 3041 TID : 140357962557184PROC : db2sysc
INSTANCE: db2admin NODE : 000 DB : RMIS
APPHDL : 0-8 APPID: *LOCAL.db2admin.151106190253
AUTHID : DB2ADMIN
EDUID : 18 EDUNAME: db2agent (RMIS)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM
"No Memory Available (reason code is id of requested heap)"
DIA8300C A memory heap error has occurred.
DATA #1 : String, 60 bytes
Insufficient instance_memory to allocate new memory consumer
DATA #2 : String, 11 bytes
DB-RMIS
DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
2737438720
DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes
66453504
DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes
2147483648
2015-11-07-03.02.53.808692+480 I5345E725 LEVEL: Error
PID : 3041 TID : 140357962557184PROC : db2sysc
INSTANCE: db2admin NODE : 000 DB : RMIS
APPHDL : 0-8 APPID: *LOCAL.db2admin.151106190253
AUTHID : DB2ADMIN
EDUID : 18 EDUNAME: db2agent (RMIS)
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr, probe:149
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 8 bytes
RMIS
DATA #2 : String, 56 bytes
Insufficient INSTANCE_MEMORY to allocate new memory set.
DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes
41770
收起