The Outputs are as follows
onstat -g iov
IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:38:57 -- 1548288 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors tempops
msc 0 i 0.7 1147469 0 0 0 1144991 1.0 0 1147469
aio 0 i 21.6 37452469 35650434 1801668 0 36708958 1.0 0 1988
aio 1 i 3.1 5384505 5150842 233649 0 5445682 1.0 0 516
aio 2 i 0.5 842074 662674 179393 0 719715 1.2 0 25
aio 3 i 0.3 463958 296716 167237 0 342645 1.4 0 5
aio 4 i 0.2 363956 205779 158176 0 261226 1.4 0 3
aio 5 i 0.2 316479 165640 150837 0 231247 1.4 0 3
aio 6 i 0.2 284546 139390 145154 0 211520 1.3 0 3
aio 7 i 0.1 252649 113369 139278 0 195123 1.3 0 2
aio 8 i 0.1 227720 93375 134344 0 180255 1.3 0 2
aio 9 i 0.1 207336 77346 129989 0 167261 1.2 0 1
aio 10 i 0.1 187348 61945 125403 0 153269 1.2 0 1
aio 11 i 0.1 169746 48705 121041 0 140114 1.2 0 1
aio 12 i 0.1 153348 37234 116114 0 126177 1.2 0 2
aio 13 i 0.1 139891 27808 112083 0 112298 1.2 0 1
aio 14 i 0.1 127518 20165 107353 0 98372 1.3 0 1
aio 15 i 0.1 116687 14639 102048 0 84006 1.4 0 1
aio 16 i 0.1 109887 10370 99517 0 69367 1.6 0 1
aio 17 i 0.1 104409 7060 97349 0 59116 1.8 0 2
aio 18 i 0.1 102756 5422 97334 0 50101 2.1 0 2
pio 0 i 0.0 32898 0 32898 0 32899 1.0 0 32898
lio 0 i 1.8 3168308 0 3168308 0 3168305 1.0 0 3168308
onstat –c
IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:39:37 -- 1548288 Kbytes
Configuration File: /u/informix11.5-3/etc/onconfig_01
###################################################################
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# Copyright IBM Corporation 1996, 2008 All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
# Important: $INFORMIXDIR now resolves to the environment
# variable INFORMIXDIR. Replace the value of the INFORMIXDIR
# environment variable only if the path you want is not under
# $INFORMIXDIR.
#
# For additional information on the parameters:
# http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
###################################################################
###################################################################
# Root Dbspace Configuration Parameters
###################################################################
# ROOTNAME - The root dbspace name to contain reserved pages and
# internal tracking tables.
# ROOTPATH - The path for the device containing the root dbspace
# ROOTOFFSET - The offset, in KB, of the root dbspace into the
# device. The offset is required for some raw devices.
# ROOTSIZE - The size of the root dbspace, in KB. The value of
# 200000 allows for a default user space of about
# 100 MB and the default system space requirements.
# MIRROR - Enable (1) or disable (0) mirroring
# MIRRORPATH - The path for the device containing the mirrored
# root dbspace
# MIRROROFFSET - The offset, in KB, into the mirrored device
#
# Warning: Always verify ROOTPATH before performing
# disk initialization (oninit -i or -iy) to
# avoid disk corruption of another instance
###################################################################
ROOTNAME rootdbs_01
ROOTPATH /u1/ids_space/rootdbs_01
ROOTOFFSET 0
ROOTSIZE 256000
MIRROR 0
MIRRORPATH
MIRROROFFSET 0
###################################################################
# Physical Log Configuration Parameters
###################################################################
# PHYSFILE - The size, in KB, of the physical log on disk.
# If RTO_SERVER_RESTART is enabled, the
# suggested formula for the size of PHSYFILE
# (up to about 1 GB) is:
# PHYSFILE = Size of BUFFERS * 1.1
# PLOG_OVERFLOW_PATH - The directory for extra physical log files
# if the physical log overflows during recovery
# or long transaction rollback
# PHYSBUFF - The size of the physical log buffer, in KB
###################################################################
PHYSFILE 150000
PLOG_OVERFLOW_PATH
PHYSBUFF 256
###################################################################
# Logical Log Configuration Parameters
###################################################################
# LOGFILES - The number of logical log files
# LOGSIZE - The size of each logical log, in KB
# DYNAMIC_LOGS - The type of dynamic log allocation.
# Acceptable values are:
# 2 Automatic. IDS adds a new logical log to the
# root dbspace when necessary.
# 1 Manual. IDS notifies the DBA to add new logical
# logs when necessary.
# 0 Disabled
# LOGBUFF - The size of the logical log buffer, in KB
###################################################################
LOGFILES 23
LOGSIZE 50000
DYNAMIC_LOGS 0
LOGBUFF 256
###################################################################
# Long Transaction Configuration Parameters
###################################################################
# If IDS cannot roll back a long transaction, the server hangs
# until more disk space is available.
#
# LTXHWM - The percentage of the logical logs that can be
# filled before a transaction is determined to be a
# long transaction and is rolled back
# LTXEHWM - The percentage of the logical logs that have been
# filled before the server suspends all other
# transactions so that the long transaction being
# rolled back has exclusive use of the logs
#
# When dynamic logging is on, you can set higher values for
# LTXHWM and LTXEHWM because the server can add new logical logs
# during long transaction rollback. Set lower values to limit the
# number of new logical logs added.
#
# If dynamic logging is off, set LTXHWM and LTXEHWM to
# lower values, such as 50 and 60 or lower, to prevent long
# transaction rollback from hanging the server due to lack of
# logical log space.
#
# When using Enterprise Replication, set LTXEHWM to at least 30%
# higher than LTXHWM to minimize log overruns.
###################################################################
LTXHWM 50
LTXEHWM 60
###################################################################
# Server Message File Configuration Parameters
###################################################################
# MSGPATH - The path of the IDS message log file
# CONSOLE - The path of the IDS console message file
###################################################################
MSGPATH /u/informix11.5-3/online_01.log
CONSOLE /u/informix11.5-3/online_01.con
###################################################################
# Tblspace Configuration Parameters
###################################################################
# TBLTBLFIRST - The first extent size, in KB, for the tblspace
# tblspace. Must be in multiples of the page size.
# TBLTBLNEXT - The next extent size, in KB, for the tblspace
# tblspace. Must be in multiples of the page size.
# The default setting for both is 0, which allows IDS to manage
# extent sizes automatically.
#
# TBLSPACE_STATS - Enables (1) or disables (0) IDS to maintain
# tblspace statistics
###################################################################
TBLTBLFIRST 5120
TBLTBLNEXT 5120
TBLSPACE_STATS 1
###################################################################
# Temporary dbspace and sbspace Configuration Parameters
###################################################################
# DBSPACETEMP - The list of dbspaces used to store temporary
# tables and other objects. Specify a colon
# separated list of dbspaces that exist when the
# server is started. If no dbspaces are specified,
# or if all specified dbspaces are not valid,
# temporary files are created in the /tmp directory
# instead.
# SBSPACETEMP - The list of sbspaces used to store temporary
# tables for smart large objects. If no sbspace
# is specified, temporary files are created in
# a standard sbspace.
###################################################################
DBSPACETEMP tempdbs_01
SBSPACETEMP
###################################################################
# Dbspace and sbspace Configuration Parameters
###################################################################
# SBSPACENAME - The default sbspace name where smart large objects
# are stored if no sbspace is specified during
# smart large object creation. Some DataBlade
# modules store smart large objects in this
# location.
# SYSSBSPACENAME - The default sbspace for system statistics
# collection. Otherwise, IDS stores statistics
# in the sysdistrib system catalog table.
# ONDBSPACEDOWN - Specifies how IDS behaves when it encounters a
# dbspace that is offline. Acceptable values
# are:
# 0 Continue
# 1 Stop
# 2 Wait for DBA action
###################################################################
SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 2
###################################################################
# System Configuration Parameters
###################################################################
# SERVERNUM - The unique ID for the IDS instance. Acceptable
# values are 0 through 255, inclusive.
# DBSERVERNAME - The name of the default database server
# DBSERVERALIASES - The list of up to 32 alternative dbservernames,
# separated by commas
###################################################################
SERVERNUM 05
DBSERVERNAME ids_rep05
DBSERVERALIASES ids_net_rep05
###################################################################
# Network Configuration Parameters
###################################################################
# NETTYPE - The configuration of poll threads
# for a specific protocol. The
# format is:
# NETTYPE <protocol>,<# poll threads>
# ,<number of connections/thread>
# ,(NET|CPU)
# You can include multiple NETTYPE
# entries for multiple protocols.
# LISTEN_TIMEOUT - The number of seconds that IDS
# waits for a connection
# MAX_INCOMPLETE_CONNECTIONS - The maximum number of incomplete
# connections before IDS logs a Denial
# of Service (DoS) error
# FASTPOLL - Enables (1) or disables (0) fast
# polling of your network, if your
# operating system supports it.
###################################################################
NETTYPE ipcshm,23,250,CPU
NETTYPE tlitcp,23,250,NET
LISTEN_TIMEOUT 10
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
###################################################################
# CPU-Related Configuration Parameters
###################################################################
# MULTIPROCESSOR - Specifies whether the computer has multiple
# CPUs. Acceptable values are: 0 (single
# processor), 1 (multiple processors or
# multi-core chips)
# VPCLASS cpu - Configures the CPU VPs. The format is:
# VPCLASS cpu,num=<#>[,max=<#>][,aff=<#>]
# [,noage]
# VP_MEMORY_CACHE_KB - Specifies the amount of private memory
# blocks of your CPU VP, in KB, that the
# database server can access.
# Acceptable values are:
# 0 (disable)
# 800 through 40% of the value of SHMTOTAL
# SINGLE_CPU_VP - Optimizes performance if IDS runs with
# only one CPU VP. Acceptable values are:
# 0 multiple CPU VPs
# Any nonzero value (optimize for one CPU VP)
###################################################################
MULTIPROCESSOR 1
VPCLASS cpu,num=23,aff=0-23,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0
###################################################################
# AIO and Cleaner-Related Configuration Parameters
###################################################################
# VPCLASS aio - Configures the AIO VPs. The format is:
# VPCLASS aio,num=<#>[,max=<#>][,aff=<#>][,noage]
# CLEANERS - The number of page cleaner threads
# AUTO_AIOVPS - Enables (1) or disables (0) automatic management
# of AIO VPs
# DIRECT_IO - Enables (1) or disables (0) direct I/O for chunks
###################################################################
#VPCLASS aio,num=1
CLEANERS 24
AUTO_AIOVPS 1
DIRECT_IO 0
###################################################################
# Lock-Related Configuration Parameters
###################################################################
# LOCKS - The initial number of locks when IDS starts.
# Dynamic locking can add extra locks if needed.
# DEF_TABLE_LOCKMODE - The default table lock mode for new tables.
# Acceptable values are ROW and PAGE (default).
###################################################################
LOCKS 200000
DEF_TABLE_LOCKMODE ROW
###################################################################
# Shared Memory Configuration Parameters
###################################################################
# RESIDENT - Controls whether shared memory is resident.
# Acceptable values are:
# 0 off (default)
# 1 lock the resident segment only
# n lock the resident segment and the next n-1
# virtual segments, where n < 100
# -1 lock all resident and virtual segments
# SHMBASE - The shared memory base address; do not change
# SHMVIRTSIZE - The initial size, in KB, of the virtual
# segment of shared memory
# SHMADD - The size, in KB, of additional virtual shared
# memory segments
# EXTSHMADD - The size, in KB, of each extension shared
# memory segment
# SHMTOTAL - The maximum amount of shared memory for IDS,
# in KB. A 0 indicates no specific limit.
# SHMVIRT_ALLOCSEG - Controls when IDS adds a memory segment and
# the alarm level if the memory segment cannot
# be added.
# For the first field, acceptable values are:
# - 0 Disabled
# - A decimal number indicating the percentage
# of memory used before a segment is added
# - The number of KB remaining when a segment
# is added
# For the second field, specify an alarm level
# from 1 (non-event) to 5 (fatal error).
# SHMNOACCESS - A list of up to 10 memory address ranges
# that IDS cannot use to attach shared memory.
# Each address range is the start and end memory
# address in hex format, separated by a hyphen.
# Use a comma to separate each range in the list.
###################################################################
RESIDENT 0
SHMBASE 0x10a000000
SHMVIRTSIZE 131072
SHMADD 131072
EXTSHMADD 131072
SHMTOTAL 3072000
SHMVIRT_ALLOCSEG 0.000000
SHMNOACCESS
###################################################################
# Checkpoint and System Block Configuration Parameters
###################################################################
# CKPINTVL - Specifies how often, in seconds, IDS checks
# if a checkpoint is needed. 0 indicates that
# IDS does not check for checkpoints. Ignored
# if RTO_SERVER_RESTART is set.
# AUTO_CKPTS - Enables (1) or disables (0) monitoring of
# critical resource to trigger checkpoints
# more frequently if there is a chance that
# transaction blocking might occur.
# RTO_SERVER_RESTART - Specifies, in seconds, the Recovery Time
# Objective for IDS restart after a server
# failure. Acceptable values are 0 (off) and
# any number from 60-1800, inclusive.
# BLOCKTIMEOUT - Specifies the amount of time, in seconds,
# for a system block.
###################################################################
CKPTINTVL 300
AUTO_CKPTS 1
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600
###################################################################
# Transaction-Related Configuration Parameters
###################################################################
# TXTIMEOUT - The distributed transaction timeout, in seconds
# DEADLOCK_TIMEOUT - The maximum time, in seconds, to wait for a
# lock in a distributed transaction.
# HETERO_COMMIT - Enables (1) or disables (0) heterogeneous
# commits for a distributed transaction
# involving an EGM gateway.
###################################################################
TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0
###################################################################
# ontape Tape Device Configuration Parameters
###################################################################
# TAPEDEV - The tape device path for backups. To use standard
# I/O instead of a device, set to stdio.
# TAPEBLK - The tape block size, in KB, for backups
# TAPESIZE - The maximum amount of data to put on one backup
# tape. Acceptable values are 0 (unlimited) or any
# positive integral multiple of TAPEBLK.
###################################################################
TAPEDEV /u4/ids_backup/data_01
TAPEBLK 128
TAPESIZE 2048000000
###################################################################
# ontape Logial Log Tape Device Configuration Parameters
###################################################################
# LTAPEDEV - The tape device path for logical logs
# LTAPEBLK - The tape block size, in KB, for backing up logical
# logs
# LTAPESIZE - The maximum amount of data to put on one logical
# log tape. Acceptable values are 0 (unlimited) or any
# positive integral multiple of LTAPEBLK.
###################################################################
LTAPEDEV /u/ids_backup/llog_01_d
LTAPEBLK 128
LTAPESIZE 2048000
###################################################################
# Backup and Restore Configuration Parameters
###################################################################
# BAR_ACT_LOG - The ON-Bar activity log file location.
# Do not use the /tmp directory. Use a
# directory with restricted permissions.
# BAR_DEBUG_LOG - The ON-Bar debug log file location.
# Do not use the /tmp directory. Use a
# directory with restricted permissions.
# BAR_DEBUG - The debug level for ON-Bar. Acceptable
# values are 0 (off) through 9 (high).
# BAR_MAX_BACKUP - The number of backup threads used in a
# backup. Acceptable values are 0 (unlimited)
# or any positive integer.
# BAR_RETRY - Specifies the number of time to retry a
# backup or restore operation before reporting
# a failure
# BAR_NB_XPORT_COUNT - Specifies the number of data buffers that
# each onbar_d process uses to communicate
# with the database server
# BAR_XFER_BUF_SIZE - The size, in pages, of each data buffer.
# Acceptable values are 1 through 15 for
# 4 KB pages and 1 through 31 for 2 KB pages.
# RESTARTABLE_RESTORE - Enables ON-Bar to continue a backup after a
# failure. Acceptable values are OFF or ON.
# BAR_PROGRESS_FREQ - Specifies, in minutes, how often progress
# messages are placed in the ON-Bar activity
# log. Acceptable values are: 0 (record only
# completion messages) or 5 and above.
# BAR_BSALIB_PATH - The shared library for ON-Bar and the
# storage manager. The default value is
# $INFORMIXDIR/lib/ibsad001 (with a
# platform-specific file extension).
# BACKUP_FILTER - Specifies the pathname of a filter program
# to transform data during a backup, plus any
# program options
# RESTORE_FILTER - Specifies the pathname of a filter program
# to transform data during a restore, plus any
# program options
# BAR_PERFORMANCE - Specifies the type of performance statistics
# to report to the ON-Bar activity log for backup
# and restore operations.
# Acceptable values are:
# 0 = Turn off performance monitoring (Default)
# 1 = Display the time spent transferring data
# between the IDS instance and the storage
# manager
# 2 = Display timestamps in microseconds
# 3 = Display both timestamps and transfer
# statistics
###################################################################
BAR_ACT_LOG /u/informix11.5-3/bar_act.log
BAR_DEBUG_LOG /u/informix11.5-3/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
###################################################################
# Informix Storage Manager (ISM) Configuration Parameters
###################################################################
# ISM_DATA_POOL - Specifies the name for the ISM data pool
# ISM_LOG_POOL - Specifies the name for the ISM log pool
###################################################################
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
###################################################################
# Data Dictionary Cache Configuration Parameters
###################################################################
# DD_HASHSIZE - The number of data dictionary pools. Set to any
# positive integer; a prime number is recommended.
# DD_HASHMAX - The number of entries per pool.
# Set to any positive integer.
###################################################################
DD_HASHSIZE 31
DD_HASHMAX 10
###################################################################
# Data Distribution Configuration Parameters
###################################################################
# DS_HASHSIZE - The number of data Ddstribution pools.
# Set to any positive integer; a prime number is
# recommended.
# DS_POOLSIZE - The maximum number of entries in the data
# distribution cache. Set to any positive integer.
###################################################################
DS_HASHSIZE 31
DS_POOLSIZE 127
##################################################################
# User Defined Routine (UDR) Cache Configuration Parameters
##################################################################
# PC_HASHSIZE - The number of UDR pools. Set to any
# positive integer; a prime number is recommended.
# PC_POOLSIZE - The maximum number of entries in the
# UDR cache. Set to any positive integer.
###################################################################
PC_HASHSIZE 31
PC_POOLSIZE 127
###################################################################
# SQL Statement Cache Configuration Parameters
###################################################################
# STMT_CACHE - Controls SQL statement caching. Acceptable
# values are:
# 0 Disabled
# 1 Enabled at the session level
# 2 All statements are cached
# STMT_CACHE_HITS - The number of times an SQL statement must be
# executed before becoming fully cached.
# 0 indicates that all statements are
# fully cached the first time.
# STMT_CACHE_SIZE - The size, in KB, of the SQL statement cache
# STMT_CACHE_NOLIMIT - Controls additional memory consumption.
# Acceptable values are:
# 0 Limit memory to STMT_CACHE_SIZE
# 1 Obtain as much memory, temporarily, as needed
# STMT_CACHE_NUMPOOL - The number of pools for the SQL statement
# cache. Acceptable value is a positive
# integer between 1 and 256, inclusive.
###################################################################
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 - The precision of SQL statement timing.
# Accepted values are 0 (precision to seconds)
# and 1 (precision to subseconds). Subsecond
# precision can degrade performance.
# STACKSIZE - The size, in KB, for a session stack
# ALLOW_NEWLINE - Controls whether embedded new line characters
# in string literals are allowed in SQL
# statements. Acceptable values are 1 (allowed)
# and any number other than 1 (not allowed).
# USELASTCOMMITTED - Controls the committed read isolation level.
# Acceptable values are:
# - NONE Waits on a lock
# - DIRTY READ Uses the last committed value in
# place of a dirty read
# - COMMITTED READ Uses the last committed value
# in place of a committed read
# - ALL Uses the last committed value in place
# of all isolation levels that support the last
# committed option
###################################################################
USEOSTIME 0
STACKSIZE 128
ALLOW_NEWLINE 0
USELASTCOMMITTED NONE
###################################################################
# Index Related Configuration Parameters
###################################################################
# FILLFACTOR - The percentage of index page fullness
# MAX_FILL_DATA_PAGES - Enables (1) or disables (0) filling data
# pages that have variable length rows as
# full as possible
# BTSCANNER - Specifies the configuration settings for all
# btscanner threads. The format is:
# BTSCANNER num=<#>,threshold=<#>,rangesize=<#>,
# alice=(0-12),compression=[low|med|high|default]
# ONLIDX_MAXMEM - The amount of memory, in KB, allocated for
# the pre-image pool and updator log pool for
# each partition.
###################################################################
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 - The maximum amount of resources, as a
# percentage, that PDQ can allocate to any
# one decision support query
# DS_MAX_QUERIES - The maximum number of concurrent decision
# support queries
# DS_TOTAL_MEMORY - The maximum amount, in KB, of decision
# support query memory
# DS_MAX_SCANS - The maximum number of concurrent decision
# support scans
# DS_NONPDQ_QUERY_MEM - The amount of non-PDQ query memory, in KB.
# Acceptable values are 128 to 25% of
# DS_TOTAL_MEMORY.
# DATASKIP - Specifies whether to skip dbspaces when
# processing a query. Acceptable values are:
# - ALL Skip all unavailable fragments
# - ON <dbspace1> <dbspace2>... Skip listed
# dbspaces
# - OFF Do not skip dbspaces (default)
###################################################################
MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 1024
DATASKIP off
###################################################################
# Optimizer Configuration Parameters
###################################################################
# OPTCOMPIND - Controls how the optimizer determines the best
# query path. Acceptable values are:
# 0 Nested loop joins are preferred
# 1 If isolation level is repeatable read,
# works the same as 0, otherwise works same as 2
# 2 Optimizer decisions are based on cost only
# DIRECTIVES - Specifies whether optimizer directives are
# enabled (1) or disabled (0). Default is 1.
# EXT_DIRECTIVES - Controls the use of external SQL directives.
# Acceptable values are:
# 0 Disabled
# 1 Enabled if the IFX_EXTDIRECTIVES environment
# variable is enabled
# 2 Enabled even if the IFX_EXTDIRECTIVES
# environment is not set
# OPT_GOAL - Controls how the optimizer should optimize for
# fastest retrieval. Acceptable values are:
# -1 All rows in a query
# 0 The first rows in a query
# IFX_FOLDVIEW - Enables (1) or disables (0) folding views that
# have multiple tables or a UNION ALL clause.
# Disabled by default.
# AUTO_REPREPARE - Enables (1) or disables (0) automatically
# re-optimizing stored procedures and re-preparing
# prepared statements when tables that are referenced
# by them change. Minimizes the occurrence of the
# -710 error.
####################################################################
OPTCOMPIND 2
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL 0
IFX_FOLDVIEW 0
AUTO_REPREPARE 1
###################################################################
# Read-ahead Configuration Parameters
###################################################################
#RA_PAGES - The number of pages, as a positive integer, to
# attempt to read ahead
#RA_THRESHOLD - The number of pages, as a postive integer, left
# before the next read-ahead group
###################################################################
RA_PAGES 30
RA_THRESHOLD 25
###################################################################
# SQL Tracing and EXPLAIN Plan Configuration Parameters
###################################################################
# EXPLAIN_STAT - Enables (1) or disables (0) including the Query
# Statistics section in the EXPLAIN output file
# SQLTRACE - Configures SQL tracing. The format is:
# SQLTRACE level=(low|med|high),ntraces=<#>,size=<#>,
# mode=(global|user)
###################################################################
EXPLAIN_STAT 1
SQLTRACE level=low,ntraces=1000,size=2,mode=global
###################################################################
# Security Configuration Parameters
###################################################################
# DBCREATE_PERMISSION - Specifies the users who can create
# databases (by default, any user can).
# Add a DBCREATE_PERMISSION entry
# for each user who needs database
# creation privileges. Ensure user
# informix11.5 is authorized when you
# first initialize IDS.
# DB_LIBRARY_PATH - Specifies the locations, separated
# by commas, from which IDS can use
# UDR or UDT shared libraries. If set,
# make sure that all directories containing
# the blade modules are listed, to
# ensure all DataBlade modules will
# work.
# IFX_EXTEND_ROLE - Controls whether administrators
# can use the EXTEND role to specify
# which users can register external
# routines. Acceptable values are:
# 0 Any user can register external
# routines
# 1 Only users granted the ability
# to register external routines
# can do so (Default)
# SECURITY_LOCALCONNECTION - Specifies whether IDS performs
# security checking for local
# connections. Acceptable values are:
# 0 Off
# 1 Validate ID
# 2 Validate ID and port
# UNSECURE_ONSTAT - Controls whether non-DBSA users are
# allowed to run all onstat commands.
# Acceptable values are:
# 1 Enabled
# 0 Disabled (Default)
# ADMIN_USER_MODE_WITH_DBSA - Controls who can connect to IDS
# in administration mode. Acceptable
# values are:
# 1 DBSAs, users specified by
# ADMIN_MODE_USERS, and the user
# informix11.5
# 0 Only the user informix11.5 (Default)
# ADMIN_MODE_USERS - Specifies the user names, separated by
# commas, who can connect to IDS in
# administration mode, in addition to
# the user informix11.5
# SSL_KEYSTORE_LABEL - The label, up to 512 characters, of
# the IDS certificate used in Secure
# Sockets Layer (SSL) protocol
# communications.
###################################################################
#DBCREATE_PERMISSION informix11.5
#DB_LIBRARY_PATH
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION 0
UNSECURE_ONSTAT 0
ADMIN_USER_MODE_WITH_DBSA 0
SSL_KEYSTORE_LABEL
###################################################################
# LBAC Configuration Parameters
###################################################################
# PLCY_POOLSIZE - The maximum number of entries in each hash
# bucket of the LBAC security information cache
# PLCY_HASHSIZE - The number of hash buckets in the LBAC security
# information cache
# USRC_POOLSIZE - The maximum number of entries in each hash
# bucket of the LBAC credential memory cache
# USRC_HASHSIZE - The number of hash buckets in the LBAC credential
# memory cache
###################################################################
PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31
###################################################################
# Optical Configuration Parameters
###################################################################
# STAGEBLOB - The name of the optical blobspace. Must be set to
# use the optical-storage subsystem.
# OPCACHEMAX - Maximum optical cache size, in KB
###################################################################
STAGEBLOB
OPCACHEMAX 0
###################################################################
# High Availability and Enterprise Replication Security
# Configuration Parameters
###################################################################
# ENCRYPT_HDR - Enables (1) or disables (0) encryption for HDR.
# ENCRYPT_SMX - Controls the level of encryption for RSS and
# SDS servers. Acceptable values are:
# 0 Do not encrypt (Default)
# 1 Encrypt if possible
# 2 Always encrypt
# ENCRYPT_CDR - Controls the level of encryption for ER.
# Acceptable values are:
# 0 Do not encrypt (Default)
# 1 Encrypt if possible
# 2 Always encrypt
# ENCRYPT_CIPHERS - A list of encryption ciphers and modes,
# separated by commas. Default is all.
# ENCRYPT_MAC - Controls the level of message authentication
# code (MAC). Acceptable values are off, high,
# medium, and low. List multiple values separated
# by commas; the highest common level between
# servers is used.
# ENCRYPT_MACFILE - The paths of the MAC key files, separated
# by commas. Use the builtin keyword to specify
# the built-in key. Default is builtin.
# ENCRYPT_SWITCH - Defines the frequencies, in minutes, at which
# ciphers and keys are renegotiated. Format is:
# <cipher_switch_time>,<key_switch_time>
# Default is 60,60.
###################################################################
ENCRYPT_HDR 0
ENCRYPT_SMX 0
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC medium
ENCRYPT_MACFILE builtin,builtin,builtin
ENCRYPT_SWITCH 0,0
###################################################################
# Enterprise Replication (ER) Configuration Parameters
###################################################################
# CDR_EVALTHREADS - The number of evaluator threads per
# CPU VP and the number of additional
# threads, separated by a comma.
# Acceptable values are: a non-zero value
# followed by a non-negative value
# CDR_DSLOCKWAIT - The number of seconds the Datasync
# waits for database locks.
# CDR_QUEUEMEM - The maximum amount of memory, in KB,
# for the send and receive queues.
# CDR_NIFCOMPRESS - Controls the network interface
# compression level.
# Acceptable values are:
# -1 Never
# 0 None
# 1-9 Compression level
# CDR_SERIAL - Specifies the incremental size and
# the starting value of replicated
# serial columns. The format is:
# <delta>,<offset>
# CDR_DBSPACE - The dbspace name for the syscdr
# database.
# CDR_QHDR_DBSPACE - The name of the transaction record
# dbspace. Default is the root dbspace.
# CDR_QDATA_SBSPACE - The names of sbspaces for spooled
# transaction data, separated by commas.
# CDR_MAX_DYNAMIC_LOGS - The maximum number of dynamic log
# requests that ER can make within one
# server session. Acceptable values are:
# -1 (unlimited), 0 (disabled),
# 1 through n (limit to n requests)
# CDR_SUPPRESS_ATSRISWARN - The Datasync error and warning code
# numbers to be suppressed in ATS and RIS
# files. Acceptable values are: numbers
# or ranges of numbers separated by commas.
# Separate numbers in a range by a hyphen.
###################################################################
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0,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 - Controls automatic failover of primary
# servers. Valid for HDR, SDS, and RSS.
# Acceptable values are:
# 0 Manual
# 1 Retain server type
# 2 Reverse server type
# 3 Connection Manager Arbitrator controls
# server type
# DRINTERVAL - The maximum interval, in seconds, between HDR
# buffer flushes. Valid for HDR only.
# DRTIMEOUT - The time, in seconds, before a network
# timeout occurs. Valid for HDR only.
# DRLOSTFOUND - The path of the HDR lost-and-found file.
# Valid of HDR only.
# DRIDXAUTO - Enables (1) or disables (0) automatic index
# repair for an HDR pair. Default is 0.
# HA_ALIAS - The server alias for a high-availability
# cluster. Must be the same as a value of
# DBSERVERNAME or DBSERVERALIASES that uses a
# network-based connection type. Valid for HDR,
# SDS, and RSS.
# LOG_INDEX_BUILDS - Enable (1) or disable (0) index page logging.
# Required for RSS. Optional for HDR and SDS.
# SDS_ENABLE - Enables (1) or disables (0) an SDS server.
# Set this value on an SDS server after setting
# up the primary. Valid for SDS only.
# SDS_TIMEOUT - The time, in seconds, that the primary waits
# for an acknowledgement from an SDS server
# while performing page flushing before marking
# the SDS server as down. Valid for SDS only.
# SDS_TEMPDBS - The temporary dbspace used by an SDS server.
# The format is:
# <dbspace_name>,<path>,<pagesize in KB>,<offset in KB>,
# <size in KB>
# You can include up to 16 entries of SDS_TEMPDBS to
# specify additional dbspaces. Valid for SDS.
# SDS_PAGING - The paths of two buffer paging files,
# Separated by a comma. Valid for SDS only.
# UPDATABLE_SECONDARY - Controls whether secondary servers can accept
# update, insert, and delete operations from clients.
# If enabled, specifies the number of connection
# threads between the secondary and primary servers
# for transmitting updates from the secondary.
# Acceptable values are:
# 0 Secondary server is read-only (default)
# 1 through twice the number of CPU VPs, threads
# for performing updates from the secondary.
# Valid for HDR, SDS, and RSS.
# FAILOVER_CALLBACK - Specifies the path and program name called when a
# secondary server transitions to a standard or
# primary server. Valid for HDR, SDS, and RSS.
# TEMPTAB_NOLOG - Controls the default logging mode for temporary
# tables that are explicitly created with the
# CREATE TEMP TABLE or SELECT INTO TEMP statements.
# Secondary servers must not have logged temporary
# tables. Acceptable values are:
# 0 Create temporary tables with logging enabled by
# default.
# 1 Create temporary tables without logging.
# Required to be set to 1 on HDR, RSS, and SDS
# secondary servers.
###################################################################
DRAUTO 0
DRINTERVAL 30
DRTIMEOUT 30
HA_ALIAS ids_net_rep05
DRLOSTFOUND /u/informix11.5-3/etc/dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS 1
SDS_ENABLE 0
SDS_TIMEOUT 20
SDS_PAGING
FAILOVER_CALLBACK
TEMPTAB_NOLOG 0
###################################################################
# Logical Recovery Parameters
###################################################################
# ON_RECVRY_THREADS - The number of logical recovery threads that
# run in parallel during a warm restore.
# OFF_RECVRY_THREADS - The number of logical recovery threads used
# in a cold restore. Also, the number of
# threads used during fast recovery.
###################################################################
ON_RECVRY_THREADS 1
OFF_RECVRY_THREADS 10
###################################################################
# Diagnostic Dump Configuration Parameters
###################################################################
# DUMPDIR - The location Assertion Failure (AF) diagnostic
# files
# DUMPSHMEM - Controls shared memory dumps. Acceptable values
# are:
# 0 Disabled
# 1 Dump all shared memory
# 2 Exclude the buffer pool from the dump
# DUMPGCORE - Enables (1) or disables (0) whether IDS dumps a
# core using gcore
# DUMPCORE - Enables (1) or disables (0) whether IDS dumps a
# core after an AF
# DUMPCNT - The maximum number of shared memory dumps or
# core files for a single session
###################################################################
DUMPDIR /u/informix11.5-3/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1
###################################################################
# Alarm Program Configuration Parameters
###################################################################
# ALARMPROGRAM - Specifies the alarm program to display event
# alarms. To enable automatic logical log backup,
# edit alarmprogram.sh and set BACKUPLOGS=Y.
# ALRM_ALL_EVENTS - Controls whether the alarm program runs for
# every event. Acceptable values are:
# 1 Logs only noteworthy events
# 2 Logs all events
# STORAGE_FULL_ALARM - <time interval in seconds>,<alarm severity>
# specifies in what interval:
# - a message will be printed to the online.log file
# - an alarm will be raised
# when
# - a dbspace becomes full
# (ISAM error -131)
# - a partition runs out of pages or extents
# (ISAM error -136)
# time interval = 0 : OFF
# severity = 0 : no alarm, only message
# SYSALARMPROGRAM - Specifies the system alarm program triggered
# when an AF occurs
###################################################################
ALARMPROGRAM /u/informix11.5-3/etc/alarmprogram.sh
ALRM_ALL_EVENTS 1
STORAGE_FULL_ALARM 600,3
SYSALARMPROGRAM /u/informix11.5-3/etc/evidence.sh
###################################################################
# RAS Configuration Parameters
###################################################################
# RAS_PLOG_SPEED - Technical Support diagnostic parameter.
# Do not change; automatically updated.
# RAS_LLOG_SPEED - Technical Support diagnostic parameter.
# Do not change; automatically updated.
###################################################################
RAS_PLOG_SPEED 7238
RAS_LLOG_SPEED 2549
###################################################################
# Character Processing Configuration Parameter
###################################################################
# EILSEQ_COMPAT_MODE - Controls whether when processing characters,
# IDS checks if the characters are valid for
# the locale and returns error -202 if they are
# not. Acceptable values are:
# 0 Return an error for characters that are not
# valid (Default)
# 1 Allow characters that are not valid
####################################################################
EILSEQ_COMPAT_MODE 0
###################################################################
# Statistic Configuration Parameters
###################################################################
# QSTATS - Enables (1) or disables (0) the collection of queue
# statistics that can be viewed with onstat -g qst
# WSTATS - Enables (1) or disables (0) the collection of wait
# statistics that can be viewed with onstat -g wst
####################################################################
QSTATS 0
WSTATS 0
###################################################################
# Java Configuration Parameters
###################################################################
# VPCLASS jvp - Configures the Java VP. The format is:
# VPCLASS jvp,num=<#>[,max=<#>][,aff=<#>][,noage]
# JVPJAVAHOME - The JRE root directory
# JVPHOME - The Krakatoa installation directory
# JVPPROPFILE - The Java VP property file
# JVPLOGFILE - The Java VP log file
# JDKVERSION - The version of JDK supported by this server
# This parameter is deprecated and is no longer required
# JVPJAVALIB - The location of the JRE libraries, relative
# to JVPJAVAHOME
# JVPJAVAVM - The JRE libraries to use for the Java VM
# JVPARGS - Configures the Java VM. To display JNI calls,
# use JVPARGS -verbose:jni. Separate options with
# semicolons.
# JVPCLASSPATH - The Java classpath to use. Use krakatoa_g.jar
# for debugging. Comment out the JVPCLASSPATH
# entry you do not want to use.
###################################################################
#VPCLASS jvp,num=1
JVPJAVAHOME /u/informix11.5-3/extend/krakatoa/jre/
JVPHOME /u/informix11.5-3/extend/krakatoa
JVPPROPFILE /u/informix11.5-3/extend/krakatoa/.jvpprops
JVPLOGFILE /u/informix11.5-3/jvp.log
#JDKVERSION 1.5
JVPJAVALIB /lib/sparcv9
JVPJAVAVM hpi:server:verify:java:net:zip:jpeg
#JVPARGS -verbose:jni
#JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar
JVPCLASSPATH /u/informix11.5-3/extend/krakatoa/krakatoa.jar:/u/informix11.5-3/extend/krak
###################################################################
# Buffer pool and LRU Configuration Parameters
###################################################################
# BUFFERPOOL - Specifies the default values for buffers and LRU
# queues in each buffer pool. Each page size used
# by a dbspace has a buffer pool and needs a
# BUFFERPOOL entry. The onconfig.std file contains
# two initial entries: a default entry from which
# to base new page size entries on, and an entry
# for the operating system default page size.
# When you add a dbspace with a different page size,
# IDS adds a BUFFERPOOL entry to the onconfig file
# with values that are the same as the default
# BUFFERPOOL entry, except that the default
# keyword is replaced by size=Nk, where N is the
# new page size. With interval checkpoints, these
# values can now be set higher than in previous
# versions of IDS in an OLTP environment.
# AUTO_LRU_TUNING - Enables (1) or disables (0) automatic tuning of
# LRU queues. When this parameter is enabled, IDS
# increases the LRU flushing if it cannot find low
# priority buffers for number page faults.
###################################################################
BUFFERPOOL size=2K,buffers=120000,lrus=46,lru_min_dirty=50.000000,lru_max_dirty=60.000000
AUTO_LRU_TUNING 1
#VPCLASS cpu,num=1,noage
REDIRECTED_WRITES 0
ADMIN_MODE_USERS
BAR_PERFORMANCE 0
UPDATABLE_SECONDARY 0
