The following file is a sample copy of the onconfig.std file. Some of the values might be different from the ones in your onconfig.std file because some values are platform dependent.
#******************************************************************************* # # IBM Corporation # # Title: onconfig.std # Sccsid: @(#)onconfig.std 9.24 9/30/93 10:04:32 # Description: Extended Parallel Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/online_root # 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 PHYSDBS rootdbs # Location (dbspace) 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 DB server instance DBSERVERNAME # 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 100 # 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, etc. # 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 root dbspaces and dbspaces containing # log files. # The list can also be specified as an explicit list of dbspaces/dbslices # that exist when the database server 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 dbspace 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: aborts XPS) 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 pdqpriority 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_WORKER_MAX 0 # Do not auto-start onbar workers BAR_IDLE_TIMEOUT 0 # Never timeout onbar workers BAR_XPORT_COUNT 10 # Number of transport buffers per onbar worker BAR_XFER_BUFSIZE 8 # Size of each transport buffer BAR_BSALIB_PATH /usr/lib/ibsad001.so # Full pathname of storage-manager # XBSA shared library (platform dependent) BAR_HISTORY 0 # ON-Bar message history level BAR_PROGRESS_FREQ 0 # ON-Bar progress output interval ISM_DATA_POOL ISMData # Default volume pool for spaces ISM_LOG_POOL ISMLogs # Default volume pool for logical log files LOG_BACKUP_MODE MANUAL # When to back up logical log files: # CONT - backup as soon as the file fills # MANUAL - user must perform log backups # NONE - do not back up logs and re-use them # as soon as they fill. Use of NONE is not # recommended as data will be lost if the # database server must be restored.