Chinaunix首页 | 论坛 | 博客
  • 博客访问: 5698086
  • 博文数量: 745
  • 博客积分: 10075
  • 博客等级: 上将
  • 技术积分: 7716
  • 用 户 组: 普通用户
  • 注册时间: 2005-04-29 12:09
文章分类

全部博文(745)

文章存档

2019年(1)

2016年(1)

2010年(31)

2009年(88)

2008年(129)

2007年(155)

2006年(197)

2005年(143)

分类: DB2/Informix

2008-08-01 10:15:52

3dbspace、日志设置

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 from module <>

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

阅读(3901) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~