The following file is a sample copy of the onconfig.xps file for Extended Parallel Server. A few of the values might be different from the ones in your onconfig.xps file because some values are platform dependent.
#*******************************************************************************
#
# IBM Corporation
#
# Title: onconfig.xps
# Description: Extended Parallel Server Configuration Parameters
#
#*******************************************************************************
# Root Dbspace Configuration
ROOTSLICE rootdbs # Root dbspace name
ROOTPATH /dev/online_root.%c # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
# On some UNIX platforms, it is an error to set ROOTOFFSET to 0.
# When this parameter is incorrectly set, you might have to
# reinitialize the disk space and reload the data before
# resuming proper operation of the database server.
# Always check the machine notes to get machine-specific information
# before setting your configuration parameters.
ROOTSIZE 20000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSSLICE rootdbs # Location (dbslice) of physical log
PHYSFILE 1500 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 1024 # Logical log size (Kbytes)
# Configuration Manager
CONFIGSIZE STANDARD # Amt of rootdbs space to reserve for CM data
# Only applies to CM coservers
# Diagnostics
MSGPATH /usr/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM # Alarm program path
SYSALARMPROGRAM evidence.sh # System Alarm program path (a relative path
# is expanded to $INFORMIXDIR/etc/<path>)
# System Configuration SERVERNUM 0 # Unique ID corresponding to a database serverinstance DBSERVERNAME xps # Name of default database server DBSERVERALIASES # List of alternate dbservernames NETTYPE # Override sqlhosts nettype parameters RESIDENT 0 # Forced residency flag: All = -1, No = 0, or >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 PAGESIZE 4096 # System pagesize # Shared Memory Parameters LOCKS 2000 # Maximum number of locks BUFFERS 1000 # Maximum number of shared buffers NUMAIOVPS # Number of IO vps NUMFIFOVPS 2 # Number of FIFO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) CLEANERS 1 # Number of buffer cleaner processes SHMBASE SHMBASE_DIST # Shared memory base address SHMVIRTSIZE 8192 # 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 60 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water mark percentage LTXEHWM 60 # Long transaction high water mark (exclusive) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - The database server no longer supports this configuration parameter. # To determine the page size used 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 operation
OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Read Ahead Variables
RA_PAGES # Number of pages to attempt to read ahead
RA_THRESHOLD # Number of pages left before next group
IDX_RA_PAGES # Number of index pages to attempt to read ahead
IDX_RA_THRESHOLD # Number of index pages left before next group
# DBSPACETEMP:
# This is the list of dbspaces
# that the SQL engine will use to create temp tables.
# The list can be specified using various preset "sets" that are
# ALL - all dbspaces can be used for temp files
# TEMP - use only temporary dbspaces for temp files
# NOTCRITICAL - use only noncritical dbspaces for temp files.
# Critical dbspaces are the rootdbspaces and dbspaces containing
# log files.
# The list can also be specified as an explicit list of dbspaces/dbslices
# that exist when the database serfer is brought online. If not specified,
# or if all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead. If a dbspaces in this list is
# added to the system at a later point in time, it is automatically added
# to the list of dbspaces that can be used for temp purposes.
DBSPACETEMP NOTCRITICAL # 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 database 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 db 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 the database server to use when determining current time
USEOSTIME 0 # 0: use internal time (fast), 1: get time from OS (slow)
# Parallel Database Queries (pdq)
PDQPRIORITY 0 # Degree of parallelism: 0 => OFF, 1 => LOW,
# -2 => HIGH, max of 100.
MAX_PDQPRIORITY 100 # Maximum allowed pdqprioirity
DS_ADM_POLICY FAIR # Decision-support admission and allocation policy
# FAIR: service queries based on scheduling level
# but preferring lower pdqpriority queries,
# STRICT: service queries based on scheduling level
# (highest before lowest) and FCFS within each level
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 # List of dbspaces to skip
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
2 = WAIT
CAMPORT 10300 # start of UDP port range used to monitor coservers
PLAN_MONITORING 1 # Turns on Plan Monitoring for the Query Monitor.
# To leave Plan Monitoring inactive, set it to 0.
# Backup/Restore variables
BAR_ACT_LOG /tmp/bar_act.log # File for errors, warnings, and
messages
BAR_BOOT_DIR /usr/informix/etc
BAR_RETRY 0 # Number of times to retry failures
BAR_XPORT_COUNT 10 # Number of transport buffers per worker
BAR_XFER_BUFSIZE 8 # Size of each transport buffer
BAR_HISTORY 0 # ON-Bar message history level
BAR_PROGRESS_FREQ 0 # ON-Bar progress output interval
LOG_BACKUP_MODE MANUAL # When to backup logical log files:
# CONT - backup as soon as the file fills
# MANUAL - user must perform log backups
# NONE - do not backup logs and re-use
them
# as soon as they fill. Use of
# NONE is not recommended as data
# will belost if the database
server
# must be restored
# Storage Manager instances
BAR_SM 1 # Storage manager ID
BAR_SM_NAME # Storage manager name
BAR_WORKER_COSVR 1 # Storage manager is located on coserver 1
BAR_DBS_COSVR 1 # Route dbspaces from this coserver to this
# storage-manager instance
BAR_LOG_COSVR 1 # Route logical log files from this coserver to this
# storage-manager instance
BAR_WORKER_MAX 0 # Number of backup/restore objects this storage
# manager can support concurrently
BAR_IDLE_TIMEOUT 0 # Number of idle minutes before an onbar_w
# process is stopped
BAR_BSALIB_PATH /usr/lib/ibsad001.so # full pathname of storage-manager
# XBSA shared library (platform dependent)
ISM_DATA_POOL ISMData # Default volume pool for spaces
ISM_LOG_POOL ISMLogs # Default volume pool for logical log files
END
COSERVER 1
NODE node1
END
COSERVER 2
NODE node2
END