回复 3# liaosnet sqlhost:
demo_on onipcshm on_hostname on_servername
testserver onsoctcp 122 9088
onconfig:
# Root Dbspace Configuration Parameters
ROOTNAME rootdbs
ROOTPATH /opt/informix/chunks/rootchk
ROOTOFFSET 5000
ROOTSIZE 1500000
MIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRROROFFSET 0
# Physical Log Configuration Parameters
PHYSFILE 50000
PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp
PHYSBUFF 128
# Logical Log Configuration Parameters
LOGFILES 6
LOGSIZE 10000
DYNAMIC_LOGS 2
LOGBUFF 64
# Long Transaction Configuration Parameters
LTXHWM 70
LTXEHWM 80
# Server Message File Configuration Parameters
MSGPATH $INFORMIXDIR/tmp/online.log
CONSOLE $INFORMIXDIR/tmp/online.con
# Tblspace Configuration Parameters
TBLTBLFIRST 0
TBLTBLNEXT 0
TBLSPACE_STATS 1
# Temporary dbspace and sbspace Configuration Parameters
DBSPACETEMP
SBSPACETEMP
# Dbspace and sbspace Configuration Parameters
SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 2
# System Configuration Parameters
SERVERNUM 0
DBSERVERNAME testserver
DBSERVERALIASES testserver
# Network Configuration Parameters
NETTYPE ipcshm,1,50,CPU
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
# CPU-Related Configuration Parameters
MULTIPROCESSOR 0
VPCLASS cpu,num=1,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0
# AIO and Cleaner-Related Configuration Parameters
#VPCLASS aio,num=1
CLEANERS 8
AUTO_AIOVPS 1
DIRECT_IO 0
# Lock-Related Configuration Parameters
LOCKS 20000
DEF_TABLE_LOCKMODE page
# Shared Memory Configuration Parameters
RESIDENT 0
SHMBASE 0x44000000L
SHMVIRTSIZE 32656
SHMADD 8192
EXTSHMADD 8192
SHMTOTAL 65312
SHMVIRT_ALLOCSEG 0,3
SHMNOACCESS
# Checkpoint and System Block Configuration Parameters
CKPTINTVL 300
AUTO_CKPTS 1
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600
# Conversion Guard Related Configuration Parameters
CONVERSION_GUARD 2
RESTORE_POINT_DIR $INFORMIXDIR/tmp
# Transaction-Related Configuration Parameters
TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0
# ontape Tape Device Configuration Parameters
TAPEDEV /dev/null
TAPEBLK 32
TAPESIZE 0
# ontape Logial Log Tape Device Configuration Parameters
LTAPEDEV /dev/null
LTAPEBLK 32
LTAPESIZE 0
# Backup and Restore Configuration Parameters
BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log
BAR_DEBUG 0
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE ON
BAR_PROGRESS_FREQ 0
BAR_BSALIB_PATH
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0
# Informix Storage Manager (ISM) Configuration Parameters
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Data Dictionary Cache Configuration Parameters
DD_HASHSIZE 31
DD_HASHMAX 10
# Data Distribution Configuration Parameters
DS_HASHSIZE 31
DS_POOLSIZE 127
# User Defined Routine (UDR) Cache Configuration Parameters
PC_HASHSIZE 31
PC_POOLSIZE 127
# SQL Statement Cache Configuration Parameters
STMT_CACHE 0
STMT_CACHE_HITS 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1
# Operating System Session-Related Configuration Parameters
USEOSTIME 0
STACKSIZE 64
ALLOW_NEWLINE 0
USELASTCOMMITTED NONE
# Index Related Configuration Parameters
FILLFACTOR 90
MAX_FILL_DATA_PAGES 0
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default
ONLIDX_MAXMEM 5120
# Parallel Database Query (PDQ) Configuration Parameters
MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 128
DATASKIP
# Optimizer Configuration Parameters
OPTCOMPIND 2
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL -1
IFX_FOLDVIEW 0
AUTO_REPREPARE 1
# Scan Configuration Parameters
RA_PAGES 64
RA_THRESHOLD 16
BATCHEDREAD_TABLE 0
# SQL Tracing and EXPLAIN Plan Configuration Parameters
EXPLAIN_STAT 1
#SQLTRACE level=low,ntraces=1000,size=2,mode=global
# Security Configuration Parameters
#DBCREATE_PERMISSION informix
#DB_LIBRARY_PATH
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL
# LBAC Configuration Parameters
PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31
# Optical Configuration Parameters
STAGEBLOB
OPCACHEMAX 0
# Built-in Character Data Types Parameters
SQL_LOGICAL_CHAR OFF
# Sequence Cache Parameters
SEQ_CACHE_SIZE 10
# High Availability and Enterprise Replication Security
# Configuration Parameters
ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH
# Enterprise Replication (ER) Configuration Parameters
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_MAX_DYNAMIC_LOGS 0
CDR_SUPPRESS_ATSRISWARN
# High Availability Cluster (HDR, SDS, and RSS)
# Configuration Parameters
DRAUTO 0
DRINTERVAL 30
DRTIMEOUT 30
HA_ALIAS
DRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT 20
SDS_TEMPDBS
SDS_PAGING
SDS_LOGCHECK 0
UPDATABLE_SECONDARY 0
FAILOVER_CALLBACK
TEMPTAB_NOLOG 0
DELAY_APPLY 0
STOP_APPLY 0
LOG_STAGING_DIR
RSS_FLOW_CONTROL 0
# Logical Recovery Parameters
ON_RECVRY_THREADS 1
OFF_RECVRY_THREADS 10
# Diagnostic Dump Configuration Parameters
DUMPDIR $INFORMIXDIR/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1
# Alarm Program Configuration Parameters
ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3
SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh
# RAS Configuration Parameters
RAS_PLOG_SPEED 25000
RAS_LLOG_SPEED 0
# Character Processing Configuration Parameter
EILSEQ_COMPAT_MODE 0
# Statistic Configuration Parameters
QSTATS 0
WSTATS 0
# Low Memory Parameter
LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0
# GSKit Library Version
GSKIT_VERSION
# Java Configuration Parameters
#VPCLASS jvp,num=1
JVPJAVAHOME $INFORMIXDIR/extend/krakatoa/jre
JVPHOME $INFORMIXDIR/extend/krakatoa
JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops
JVPLOGFILE $INFORMIXDIR/jvp.log
#JDKVERSION 1.5
JVPJAVALIB /bin/j9vm
JVPJAVAVM jvm
#JVPARGS -verbose:jni
#JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar
JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar
# Buffer pool and LRU Configuration Parameters
BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
BUFFERPOOL size=2K,buffers=50000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
AUTO_LRU_TUNING 1
以上是两个文件的主要内容,我重新看了一次,不知是否onconfig里SERVERNUM 的值的问题?
谢谢大神的回复
收起