#**************************************************************************
#
#			   INFORMIX SOFTWARE, INC.
#
#  Title:	onconfig.std
#  Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************

# Root Dbspace Configuration

ROOTNAME	rootdbs		# Root dbspace name
ROOTPATH	D:\IFMXDATA\ol_cooper\rootdbs_dat.000	# Path for device containing root dbspace
ROOTOFFSET	0		# Offset of root dbspace into device (Kbytes)
ROOTSIZE	1000720		# 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	2000		# Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES	20		# Number of logical log files
LOGSIZE		1000		# Logical log size (Kbytes)
LOG_BACKUP_MODE MANUAL          # Logical log backup mode (MANUAL, CONT)

# Diagnostics 

MSGPATH	C:\Informix\ol_cooper.log	# System message log file path
CONSOLE	C:\Informix\conol_cooper.log	# System console message path
ALARMPROGRAM                    # Alarm program path

# System Diagnostic Script.
# SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
# 		    c:\informix\etc\evidence.bat.) Set this parameter 
#                   if you want a different Diagnostic Script than 
#                   {INFORMIXDIR}\etc\evidence.bat, which is default.

# System Archive Tape Device

TAPEDEV		D:\IFMXBKUP\ifmxbkup.bak	# Tape device path	
TAPEBLK		32		# Tape block size (Kbytes)
TAPESIZE	10240		# Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV	D:\IFMXBKUP\ifmxbklg.bak	# Log tape device path
LTAPEBLK	32		# Log tape block size (Kbytes)
LTAPESIZE	10240		# Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB                       # Informix Dynamic Server/Optical staging area
OPTICAL_LIB_PATH		# Location of Optical Subsystem driver DLL 

# System Configuration

SERVERNUM	0	# Unique id corresponding to a server instance
stance
DBSERVERNAME	ol_cooper		# Name of default Dynamic Server
DBSERVERALIASES			# List of alternate dbservernames
NETTYPE		onsoctcp,1,,NET	# Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT	60	# Max time to wait of lock in distributed env.
RESIDENT	0		# Forced residency flag (Yes = 1, No = 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

# Shared Memory Parameters

LOCKS		32000		# Maximum number of locks
BUFFERS		40000#2000		# Maximum number of shared buffers
NUMAIOVPS	1  		# Number of IO vps
PHYSBUFF	32		# Physical log buffer size (Kbytes)
LOGBUFF		32		# Logical log buffer size (Kbytes)
LOGSMAX		20		# Maximum number of logical log files
CLEANERS        1               # Number of buffer cleaner processes
SHMBASE         0xC000000L	# Shared memory base address
SHMVIRTSIZE	307200#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)
TXTIMEOUT	300		# Transaction timeout (in sec)
STACKSIZE	32		# Stack size (Kbytes)

# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
#            To determine the page size used by Dynamic Server 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.

OFF_RECVRY_THREADS	10	# Default number of offline worker threads
ON_RECVRY_THREADS	1	# Default number of online worker threads

# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO   	0 		# DR automatic switchover
DRINTERVAL	30		# DR max time between DR buffer flushes (in sec)
DRTIMEOUT	30		# DR network timeout (in sec)
DRLOSTFOUND	\tmp		# DR lost+found file path

# CDR Variables
CDR_LOGBUFFERS  2048    # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2     # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT  5       # DS lockwait timeout (seconds)
CDR_QUEUEMEM    4096    # Maximum amount of memory for any CDR queue (Kbytes)
CDR_LOGDELTA    30      # % of log space allowed in queue memory
CDR_NUMCONNECT  16      # Expected connections per server
CDR_NIFRETRY    300     # Connection retry (seconds)
CDR_NIFCOMPRESS 0       # Link level compression (-1 never, 0 none, 9 max)

# Backup/Restore variables
BAR_ACT_LOG		C:\Informix\bar_ol_cooper.log	#Path of log file for onbar.exe
BAR_MAX_BACKUP	0
BAR_RETRY	1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
BAR_BSALIB_PATH	C:\ISM\2.20\bin\libbsa.dll	# Location of ISM XBSA DLL

RESTARTABLE_RESTORE OFF #To support restartable restore..values on/off

# Informix Storage Manager variables
ISM_DATA_POOL   ISMData
ISM_LOG_POOL    ISMLogs

# Read Ahead Variables
RA_PAGES	  	        # Number of pages to attempt to read ahead
RA_THRESHOLD	  	        # Number of pages left before next group

# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the Dynamic Server system is brought online.  If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP			# 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 Dynamic 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 Dynamic
 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 Dynamic Server to use when determining current time
USEOSTIME	0	# 0: use internal time(fast), 1: get time from OS(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY	100    # Maximum allowed pdqpriority
DS_MAX_QUERIES  32     # Maximum number of decision support queries 
DS_TOTAL_MEMORY 4096   # Decision support memory (Kbytes) 
DS_MAX_SCANS 1048576   # Maximum number of decision support scans	
DATASKIP	       # List of dbspaces to skip

# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where 
#      possible) over sortmerge joins and hash joins. 
# 1 => If the transaction isolation mode is not  
#      "repeatable read", optimizer behaves as in (2) 
#      below.  Otherwise it behaves as in (0) above. 
# 2 => Use costs regardless of the transaction isolation
#      mode.  Nested loop joins are not necessarily  
#      preferred.  Optimizer bases its decision purely  
#      on costs. 
OPTCOMPIND      2      # To hint the optimizer

ONDBSPACEDOWN   2      # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE    1      # Preserve last log for log backup 
OPCACHEMAX      0      # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT   0

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL        -1

# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES      1