informix数据库手册

性能会好一些。

DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.

RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor

NUMCPUVPS 1 # Number of user (cpu) vps

不大于

c pu

的个数

SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

NOAGE 0 # Process aging

AFF_SPROC 0 # Affinity start processor

AFF_NPROCS 0 # Affinity number of processors

# Shared Memory Parameters

LOCKS 200000 # Maximum number of locks

每个锁占用

44

个字节

BUFFERS 200000 # Maximum number of shared buffers

为内存的

20-30%

NUMAIOVPS # Number of IO vps

PHYSBUFF 128 # Physical log buffer size (Kbytes)

LOGBUFF 64 # Logical log buffer size (Kbytes)

LOGSMAX 100 # Maximum number of logical log files

CLEANERS 1 # Number of buffer cleaner processes

SHMBASE 0x200000000 # Shared memory base address

SHMVIRTSIZE 8000 # initial virtual shared memory segment size

SHMADD 8192 # Size of new shared memory segments (Kbytes)

SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited

CKPTINTVL 300 # Check point interval (in sec)

当数据的修改达到物理日志的

75

％，系统会自动做

checkpoin t

，

checkpoint

时间在智能 网的应

用里不要超过

15

秒。

LRUS 8 # Number of LRU queues

LRU_MAX_DIRTY 30 # LRU percent dirty begin cleaning limit

LRU_MIN_DIRTY 20 # LRU percent dirty end cleaning limit

LTXHWM 50 # Long transaction high water mark percentage

LTXEHWM 60 # Long transaction high water mark (exclusive)

TXTIMEOUT 0x12c # Transaction timeout (in sec)

共

74

页

第

18

页

[ Informix

数据库手册

]

STACKSIZE 64 # Stack size (Kbytes)

# System Page Size

# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.

# To determine the page size used by Dynamic Server on your platform

# see the last line of output from the command, 'onstat -b'.

# Recovery Variables

# OFF_RECVRY_THREADS:

# Number of parallel worker threads during fast recovery or an offline restore.

# ON_RECVRY_THREADS:

# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10 # Default number of offline worker threads

ON_RECVRY_THREADS 1 # Default number of online worker threads

# Data Replication Variables

# DRAUTO: 0 manual, 1 retain type, 2 reverse type

DRAUTO 2 # DR automatic switchover

DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)

注意：在

HDR

环境下由于网络环境的影响建议用

30

，不要用 同步方式

(-1)

DRTIMEOUT 30 # DR network timeout (in sec)

DRLOSTFOUND /usr/informix/etc/und # DR lost+found file path

# CDR Variables

CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)

CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)

CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)

CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)

CDR_LOGDELTA 30 # % of log space allowed in queue memory

CDR_NUMCONNECT 16 # Expected connections per server

CDR_NIFRETRY 300 # Connection retry (seconds)

CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)

# Backup/Restore variables

BAR_ACT_LOG /tmp/bar_

BAR_MAX_BACKUP 0

BAR_RETRY 1

BAR_NB_XPORT_COUNT 10

BAR_XFER_BUF_SIZE 31

# Informix Storage Manager variables

ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to

# update $$INFORMIXDIR/bin/onbar. Change to

# ism_catalog -create_bootstrap -pool

ISM_LOG_POOL ISMLogs

# Read Ahead Variables

RA_PAGES # Number of pages to attempt to read ahead

RA_THRESHOLD # Number of pages left before next group

# DBSPACETEMP:

# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces

共

74

页

第

19

页

[ Informix

数据库手册

]

# that the Dynamic Server SQL Engine will use to create temp tables etc.

# If specified it must be a colon separated list of dbspaces that exist

# when the Dynamic Server system is brought online. If not specified, or if

# all dbspaces specified are invalid, various ad hoc queries will create

# temporary files in /tmp instead.

DBSPACETEMP tempdbs # Default temp dbspaces

# DUMP*:

# The following parameters control the type of diagnostics information which

# is preserved when an unanticipated error condition (assertion failure) occurs

# during Dynamic Server operations.

# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR /tmp # Preserve diagnostics in this directory

DUMPSHMEM 1 # Dump a copy of shared memory

DUMPGCORE 0 # Dump a core image using 'gcore'

DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic Server)

DUMPCNT 1 # Number of shared memory or gcore dumps for

# a single user's session

FILLFACTOR 90 # Fill factor for building indexes

# method for Dynamic Server to use when determining current time

USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

# Parallel Database Queries (pdq)

MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority

DS_MAX_QUERIES # Maximum number of decision support queries

DS_TOTAL_MEMORY # Decision support memory (Kbytes)

DS_MAX_SCANS 1048576 # Maximum number of decision support scans

DATASKIP off # List of dbspaces to skip

# OPTCOMPIND

# 0 => Nested loop joins will be preferred (where

# possible) over sortmerge joins and hash joins.

# 1 => If the transaction isolation mode is not

#

# below. Otherwise it behaves as in (0) above.

# 2 => Use costs regardless of the transaction isolation

# mode. Nested loop joins are not necessarily

# preferred. Optimizer bases its decision purely

# on costs.

OPTCOMPIND 2 # To hint the optimizer

ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT

LBU_PRESERVE 0 # Preserve last log for log backup

OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)

# 1 => Heterogeneous Commit is enabled

# 0 (or any other value) => Heterogeneous Commit is disabled

HETERO_COMMIT 0

共

74

页

第

20

页

[ Informix

数据库手册

]

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS

OPT_GOAL -1

# Optimizer DIRECTIVES ON (1/Default) or OFF (0)

DIRECTIVES 1

# Status of restartable restore

RESTARTABLE_RESTORE off

2.1.9

初始化

OnLine

（基本成功）

在

informix

用户下，执行

oninit -i

OnLine

，创建

root dbspace

。

检 查初始化是否成功。在

oninit

命令结束后，等待大约

1

分钟左右，执行

onstat