LOGFILES 10 # Number of logical log files LOGSIZE 50000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /opt/informix/online.log # System message log file path CONSOLE /dev/console # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /opt/informix/etc/alarmprogram.sh # Alarm program path TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
#TAPEDEV /dev/null # Tape device path TAPEDEV /usr/informixdata TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 20400000 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
#LTAPEDEV /dev/null # Log tape device path LTAPEDEV /opt/informix/data/logbackdev LTAPEBLK 64 # Log tape block size (Kbytes) LTAPESIZE 8192000 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLine instance DBSERVERNAME hostname_online # Name of default database server DBSERVERALIASES hostname_online_net # List of alternate dbservernames NETTYPE # Configure poll thread(s) for nettype 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 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 500000 # Maximum number of locks BUFFERS 50000 # Maximum number of shared buffers NUMAIOVPS # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) CLEANERS 1 # Number of buffer cleaner processes SHMBASE 0x700000010000000 # 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) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit TXTIMEOUT 300 # Transaction timeout (in sec) STACKSIZE 64
MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
不同的系统,SHMBASE的值不太一样,这里一定要注意,否则,数据库初始化会报错。 informix 9.4在3种小型机上安装的时候,SHMBASE的参数各不相同。 Solaris:SHMBASE 0x10A000000L # Shared memory base address AIX:SHMBASE 0x700000010000000 # Shared memory base address HP-UX:SHMBASE 0 # Shared memory base address