informix 11.7报 “No reserve memory is allocated” 错误
最近刚装了informix11.7 FC3，简单配置了一下，启动运行查询时，发现oninit服务占用了100%的CPU。运行 onstat -g seg 命令打印结课最后跟着“No reserve memory is allocated”提示，各位大哥大姐谁知道怎么配置能让这个提示出现。（注：本机内存16G，启动完informix服务之后占用内存... 显示全部
查看其它 14 个回答hohos 的回答
看下了RESIDENT参数，默认是0，改为-1后问题照旧。
onstag -g seg仍然提示如此。
online.log::
00:01:40 IBM Informix Dynamic Server Started.
00:01:40 Warning: The IBM IDS Developer Edition license restriction limits
00:01:40 the total shared memory size for this server to 1048576 KB.
00:01:40 The maximum allowable shared memory was reset to this size to start the database server.
Sat Mar 10 00:01:41 2012
00:01:41 Event alarms enabled. ALARMPROG = '/home/informix/informix/etc/alarmprogram.sh'
00:01:41 Booting Language from module <>
00:01:41 Loading Module
00:01:41 Booting Language from module <>
00:01:41 Loading Module
00:01:46 DR: DRAUTO is 0 (Off)
00:01:46 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
00:01:46 Event notification facility epoll enabled.
00:01:46 IBM Informix Dynamic Server Version 11.70.FC4DE Software Serial Number AAA#B000000
00:01:47 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
00:01:47 Started 1 B-tree scanners.
00:01:47 B-tree scanner threshold set at 5000.
00:01:47 B-tree scanner range scan size set to -1.
00:01:47 B-tree scanner ALICE mode set to 6.
00:01:47 B-tree scanner index compression level set to med.
00:01:47 Physical Recovery Started at Page (2:634).
00:01:47 Physical Recovery Complete: 2 Pages Examined, 2 Pages Restored.
00:01:47 Logical Recovery Started.
00:01:47 10 recovery worker threads will be started.
00:01:47 Listen thread init SUCCESS
00:01:48 Logical Recovery has reached the transaction cleanup phase.
00:01:48 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
00:01:49 Onconfig parameter RESIDENT modified from -1 to 0.
00:01:50 Dataskip is now OFF for all dbspaces
00:01:50 Checkpoint Completed: duration was 0 seconds.
00:01:50 Sat Mar 10 - loguniq 16, logpos 0x8940c0, timestamp: 0xd1a84 Interval: 33
00:01:50 Maximum server connections 0
00:01:50 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 10, Llog used 1
00:01:50 On-Line Mode
00:01:51 SCHAPI: Started dbScheduler thread.
00:01:51 Booting Language from module <>
00:01:51 Loading Module
00:01:51 Auto Registration is synced
00:01:51 SCHAPI: Started 2 dbWorker threads.
00:01:54 Defragmenter cleaner thread now running
00:01:54 Defragmenter cleaner thread cleaned:0 partitions
00:02:51 Loading Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld>
00:02:51 pid 5177: ELF .eh_frame section missing in /home/informix/informix/gls/dll/64-libicudata.so.42
00:02:51 The C Language Module loaded
onstag -g seg仍然提示如此。
online.log::
00:01:40 IBM Informix Dynamic Server Started.
00:01:40 Warning: The IBM IDS Developer Edition license restriction limits
00:01:40 the total shared memory size for this server to 1048576 KB.
00:01:40 The maximum allowable shared memory was reset to this size to start the database server.
Sat Mar 10 00:01:41 2012
00:01:41 Event alarms enabled. ALARMPROG = '/home/informix/informix/etc/alarmprogram.sh'
00:01:41 Booting Language
00:01:41 Loading Module
00:01:41 Booting Language
00:01:41 Loading Module
00:01:46 DR: DRAUTO is 0 (Off)
00:01:46 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
00:01:46 Event notification facility epoll enabled.
00:01:46 IBM Informix Dynamic Server Version 11.70.FC4DE Software Serial Number AAA#B000000
00:01:47 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
00:01:47 Started 1 B-tree scanners.
00:01:47 B-tree scanner threshold set at 5000.
00:01:47 B-tree scanner range scan size set to -1.
00:01:47 B-tree scanner ALICE mode set to 6.
00:01:47 B-tree scanner index compression level set to med.
00:01:47 Physical Recovery Started at Page (2:634).
00:01:47 Physical Recovery Complete: 2 Pages Examined, 2 Pages Restored.
00:01:47 Logical Recovery Started.
00:01:47 10 recovery worker threads will be started.
00:01:47 Listen thread init SUCCESS
00:01:48 Logical Recovery has reached the transaction cleanup phase.
00:01:48 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
00:01:49 Onconfig parameter RESIDENT modified from -1 to 0.
00:01:50 Dataskip is now OFF for all dbspaces
00:01:50 Checkpoint Completed: duration was 0 seconds.
00:01:50 Sat Mar 10 - loguniq 16, logpos 0x8940c0, timestamp: 0xd1a84 Interval: 33
00:01:50 Maximum server connections 0
00:01:50 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 10, Llog used 1
00:01:50 On-Line Mode
00:01:51 SCHAPI: Started dbScheduler thread.
00:01:51 Booting Language
00:01:51 Loading Module
00:01:51 Auto Registration is synced
00:01:51 SCHAPI: Started 2 dbWorker threads.
00:01:54 Defragmenter cleaner thread now running
00:01:54 Defragmenter cleaner thread cleaned:0 partitions
00:02:51 Loading Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld>
00:02:51 pid 5177: ELF .eh_frame section missing in /home/informix/informix/gls/dll/64-libicudata.so.42
00:02:51 The C Language Module loaded