informix 11.7报 “No reserve memory is allocated” 错误
最近刚装了informix11.7 FC3，简单配置了一下，启动运行查询时，发现oninit服务占用了100%的CPU。
运行 onstat -g seg 命令打印结课最后跟着“No reserve memory is allocated”提示，各位大哥大姐谁知道怎么配置能让这个提示出现。（注：本机内存16G，启动完informix服务之后占用内存才3G左右），下面贴 onstat -g seg 打印的结课：
附onconfig.std配置文件
运行 onstat -g seg 命令打印结课最后跟着“No reserve memory is allocated”提示，各位大哥大姐谁知道怎么配置能让这个提示出现。（注：本机内存16G，启动完informix服务之后占用内存才3G左右），下面贴 onstat -g seg 打印的结课：
附onconfig.std配置文件
附件：
onconfig.std (73.97 KB)
15同行回答
浏览2028
回复 10# aphuse
我记得informix大哥好像发表过他测试11.70FC4版本的帖子，我找了下这个http://www.informixchina.net/hom ... 201&do=blog&id=1677
你先看看。他在六楼，你私下mail他一下。我这边还没有11.70的环境，基本也都在11.50上面。这几天比较忙，没有时间看资料啊。。。。收起
我记得informix大哥好像发表过他测试11.70FC4版本的帖子，我找了下这个http://www.informixchina.net/hom ... 201&do=blog&id=1677
你先看看。他在六楼，你私下mail他一下。我这边还没有11.70的环境，基本也都在11.50上面。这几天比较忙，没有时间看资料啊。。。。收起
浏览2035
浏览2342
看下了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收起
浏览2546
楼主提示的错误是内存分配问题，有可能是系统内存有些问题。
于Informix如下参数有关系，
# RESIDENT - Controls whether shared memory is resident.
# Acceptable values are:
# 0 off (default)
# 1 lock the resident segment only
# n lock the resident segment and the next n-1
# virtual segments, where n < 100
# -1 lock all resident and virtual segments
RESIDENT 1
可以尝试将RESIDENT修改为0，或者-1，是否仍然出现如上错误。
另外，需要将启动过程的online.log发上来。收起
于Informix如下参数有关系，
# RESIDENT - Controls whether shared memory is resident.
# Acceptable values are:
# 0 off (default)
# 1 lock the resident segment only
# n lock the resident segment and the next n-1
# virtual segments, where n < 100
# -1 lock all resident and virtual segments
RESIDENT 1
可以尝试将RESIDENT修改为0，或者-1，是否仍然出现如上错误。
另外，需要将启动过程的online.log发上来。收起
浏览2364