分类: DB2/Informix
2008-08-01 10:15:52
3,dbspace、日志设置
n 以informix用户注册,执行oninit –iy或者执行onmonitor—〉parameters——〉initialize进入初始化配置界面,如下所示:
rx8640-2:/home/db/informix/> oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/home/db/informix/etc/onconfig.front'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/home/db/informix/etc/.infos.front" ... "/home/db/informix/etc/.conf.front" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 2268 kbytes...succeeded
Creating buffer pool 9998 kbytes...succeeded
Creating buffer pool 6 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Creating database partition
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
n 执行onstat –m查看日志,当‘sysmaster database built successfully’ 时,表明系统初始化结束,此时数据库状态为静态Quiescent,如下所示:
rx8640-2:/home/db/informix/> onstat -m
IBM Informix Dynamic Server Version 9.40.FC7 -- On-Line -- Up 00:01:33 -- 432024 Kbytes
Message Log File: /home/db/informix/online.log
14:33:30 Booting Language
14:33:30 Loading Module
14:33:30 Logical Log 3 Complete, timestamp: 0x8840.
14:33:32 Logical Log 4 Complete, timestamp: 0x8bc4.
14:33:33 Checkpoint Completed: duration was 0 seconds.
14:33:33 Checkpoint loguniq 5, logpos 0x18, timestamp: 0x8bdb
14:33:33 Maximum server connections 1
14:33:33 Unloading Module
14:33:34 Logical Log 5 Complete, timestamp: 0xb832.
14:33:34 Loading Module
14:33:35 Unloading Module
14:33:35 Logical Log 6 Complete, timestamp: 0xddaf.
14:33:36 Checkpoint Completed: duration was 0 seconds.
14:33:36 Checkpoint loguniq 7, logpos 0x154, timestamp: 0xdde7
14:33:36 Maximum server connections 1
14:33:36 'sysmaster' database built successfully.
14:33:36 'sysutils' database built successfully.
14:33:36 'sysuser' database built successfully.
初始化后,只存在rootdbs,如下所示:
rx8640-2:/home/db/informix/> onstat -d
IBM Informix Dynamic Server Version 9.40.FC7 -- On-Line -- Up 00:01:11 -- 432024 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
c0000000087e3030 1 0x1 1 1 N informix rootdbs
1 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
c0000000087e31e0 1 1 0 500000 245822 PO-- /home/db/informix/dbs/rootchunk0
1 active, 2047 maximum
Expanded chunk capacity mode: disabled
在Informix用户下,执行:
rx8640-2:/home/db/informix/bin/> onmode -BC 1
This command will enable creation of large chunks.
** WARNING ** This action cannot be undone.
** WARNING ** A level 0 archive of Root DBSpace will need to be done.
Do you wish to continue (y/n)? y
Expanded chunk capacity mode: enabled
rx8640-2:/home/db/informix/bin/> onmode -BC 2
This command will cause all chunks to be written in the new (big) format.
** WARNING ** This action cannot be undone.
** WARNING ** A level 0 archive of Root DBSpace will need to be done.
Do you wish to continue (y/n)? y
Expanded chunk capacity mode: always