云南龙网

  1. 首页 > 云知道 > >

SCO UNIX 5.06 + INFORMIX ONLINE 7.31安装和配置文档( 五 )

云知道


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]【SCO UNIX 5.06 INFORMIX ONLINE 7.31安装和配置文档】 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 PARAMETERSMultiprocessor 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 DBSPACEDbspace Name [ tempdbs ] Mirror [N ] Temp [Y ]PRIMARY CHUNK INFORMATION:Full Pathname [ /dbspaces/tempdbs ]Offset [ 0] Kbytes Size [ 2,000,000 ] KbytesMIRROR CHUNK INFORMATION:Full Pathname [ ]Offset [ 0] Kbytes
新建datadbs:
# onmonitor dbspaces > create［屏幕输出］
按ESC键建立新的DBspace 。
请按中断键取消该选项并返回Dbspaces菜单

推荐阅读


上一篇：如何让药用植物安全越冬

下一篇：荣耀v10配置怎么样？华为荣耀v10配置参数曝光