Home | Previous Page | Next Page   Appendix A. Files That the Database Server Uses >

Sample onconfig.std File

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.

Figure 84. Sample onconfig.std file
#*******************************************************************************
#
#      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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]