SCO UNIX+ INFORMIX 安装和配置文档
共享内存的初始化：
[第二屏]
SHARED MEMORY：进行期望的改变并按ESC 键记录这一改变。
按中断键中止改变。按F2或CTRL-F获取显示字段级的帮助。
SHARED MEMORY PARAMETERS
Server Number [ 8] Server Name [cld3300b_tcp ]
Server Aliases [cld3300b_shm ]
Dbspace Temp [tempdbs ]
Deadlock Timeout [ 60] Secs Number of Page Cleaners [ 1]
Forced Residency [N] Stack Size (K) [ 32]
Non Res. SegSize (K) [ 32768] Optical Cache Size (K) [ 0]
Dbspace Down Option [1]
Preserve Log For Log Backup [N]
Heterogeneous Commit [N] Transaction Timeout [ 300]
Physical Log Buffer Size [ 2048] K Long TX HWM [ 50]
Logical Log Buffer Size [ 2048] K Long TX HWM Exclusive [ 60]
Max # of Logical Logs [ 20] Index Page Fill Factor [ 90]
Max # of Locks [ 200000] Add SegSize (K) [ 8192]
Max # of Buffers [ 200000] Total Memory (K) [ 0]
Resident Shared Memory size [ 440686] Kbytes Page Size [ 2] Kbytes
Enter a unique value to be associated with this version of INFORMIX-OnLine.
注解：
* 系统参数配置：
Server Number [ 8] 每个服务器的唯一值
Server Name [cld3300b_tcp ] 数据库服务器主名
Server Aliases [cld3300b_tcp ] 数据库服务器别名
Dbspace Temp [cld3300b_tcp ] 临时数据库空间
Deadlock Timeout [ 60 ] 在分布环境下等待锁的最长时间
Forced Residency [ N ] 强制驻留标志
Stack Size (K) [ 32 ] 堆栈大小
Non Res. SegSize (K) [32768] 非驻留段大小
Transaction Timeout [ 300] 交易超时间隔
Physical Log Buffer Size [2048] K 物理日志缓冲区大小
Logical Log Buffer Size [2048] K 逻辑日志缓冲区大小
Max # of Logical Logs [ 20] 逻辑日志最大数
Max # of Locks [200000] 锁最大数
Max # of Buffers [200000] 缓冲区最大值
Index Page Fill Factor [ 90] 索引页填充因子
Resident Shared Memory size [440686] Kb共享内存驻留区大小
Page Size [ 2] Kb页大小
* 同样的，键入ESC 确认正确后，进入下一步：
[第三屏]
性能：作所需要的修改然后敲 ESC 来记录改动。
按中断键中止改变。按F2或CTRL-F获取显示字段级的帮助。
PERFORMANCE TUNING PARAMETERS
Multiprocessor Machine [N] LRU Max Dirty [ 20]
Num Procs to Affinity [0] LRU Min Dirty [ 10]
Proc num to start with [0] Checkpoint Interval [300]
Num of Read Ahead Pages [ ]
CPU VPs [ 1] Read Ahead Threshold [ ]
AIO VPs [ 12]
Single CPU VP [N] NETTYPE settings:
Use OS Time [N] Protocol Threads Users VP-class
Disable Priority Aging [Y] [tlitcp] [ 1] [ 20] [NET]
Off-Line Recovery Threads [ 10] [ipcshm] [ 1] [ 20] [CPU]
On-Line Recovery Threads [ 1] [ ] [ ] [ ] [ ]
Num of LRUS queues [ 8] [ ] [ ] [ ] [ ]
Are you running on a multiprocessor machine?
注解：
* 系统参数配置：
Multiprocessor Machine [N] 0 单处理器，1 多处理器
CPU VPs [ 1] 用户CPU VPS 数量
NETTYPE settings: 为NETTYPE配置轮询线索
Protocol Threads Users VP-class
[ipcshm] [ 1] [ ２0] [CPU]
说明：此处的参数在初次初始化Informix的时只需修改Protocol Threads Users VP-class，Protocol Threads
VP-class 三个参数的设置见上表， usr下的数值应设置成你所购买的数据库的用户数。
* 键入ESC 确认正确后，进入下一步：
接下来几屏都默认，然后初始化。
(7)、新建tempdbs、datadbs和add chunk
新建tempdbs:
# onmonitor dbspaces > create
[屏幕输出]
按ESC键建立新的DBspace。
请按中断键取消该选项并返回Dbspaces菜单
按F2或CTRL-F获取显示字段级的帮助。
CREATE DBSPACE
Dbspace Name [ tempdbs ] Mirror [N ] Temp [Y ]
PRIMARY CHUNK INFORMATION:
Full Pathname [ /dbspaces/tempdbs ]
Offset [ 0] Kbytes Size [ 2,000,000 ] Kbytes
MIRROR CHUNK INFORMATION:
Full Pathname [ ]
Offset [ 0] Kbytes
新建datadbs:
# onmonitor dbspaces > create
［屏幕输出］
按ESC键建立新的DBspace。
请按中断键取消该选项并返回Dbspaces菜单
按F2或CTRL-F获取显示字段级的帮助。
CREATE DBSPACE
Dbspace Name [ datadbs ] Mirror [ N] Temp [N]
PRIMARY CHUNK INFORMATION:
Full Pathname [ /dbspaces/chunk00 ]
Offset [ 0] Kbytes Size [ 2,000,000] Kbytes
MIRROR CHUNK INFORMATION:
Full Pathname [ ]
Offset [ 0] Kbytes
为datadbs加chunk:
# onmonitor dbspaces > add_chunk
［屏幕输出］
按ESC键增加新的大块。
按中断键取消该选项并返回Dbspaces菜单
按F2或CTRL-F获取显示字段级的帮助。
ADD CHUNK TO DBSPACE
Dbspace Name [datadbs ] Mirror [N] Temp [N]
PRIMARY CHUNK INFORMATION:
Full Pathname [ /dbspaces/chunk01 （添加你想要的chunk） ]
Offset [ 0] Kbytes Size [ 2,000,000] Kbytes
MIRROR CHUNK INFORMATION:
Full Pathname [ ]
Offset [ 0] Kbytes
然后执行 onitit –iy
至此，数据库安装、配置和初始化基本完成。
最新相关文章发表评论