- 论坛徽章:
- 11
|
onconfig的样本,和以前的版本有些不一样!
###################################################################
# 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
ROOTPATH D:\IFMXDATA\myids11\rootdbs_dat.000 # Path for device containing root dbspace
ROOTOFFSET 0
ROOTSIZE 204800 # Size of root dbspace (Kbytes)
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
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 50000
PLOG_OVERFLOW_PATH
PHYSBUFF 128
###################################################################
# 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 6
LOGSIZE 10000
DYNAMIC_LOGS 2
LOGBUFF 64
###################################################################
# 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 70
LTXEHWM 80
###################################################################
# Server Message File Configuration Parameters
###################################################################
# MSGPATH - The path of the IDS message log file
# CONSOLE - The path of the IDS console message file
###################################################################
MSGPATH D:\IBM\Informix\myids11.log # System message log file path
CONSOLE D:\IBM\Informix\conmyids11.log # System console message path
###################################################################
# 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 0
TBLTBLNEXT 0
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
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 sbspace # Default sbspace
SYSSBSPACENAME sbspace # Default System sbspace
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 0 # Unique id corresponding to a server instance
DBSERVERNAME myids11 # Name of default Dynamic Server
DBSERVERALIASES svc_drda # List of alternate dbserver names
###################################################################
# 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
LISTEN_TIMEOUT 60
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 0
VPCLASS cpu,num=1,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 8
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 20000
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 0xc000000L
SHMVIRTSIZE 32656
SHMADD 8192
EXTSHMADD 8192
SHMTOTAL 0
SHMVIRT_ALLOCSEG 0,3
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 \\.\TAPE0
TAPEBLK 16
TAPESIZE 0
###################################################################
# 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 NUL
LTAPEBLK 16
LTAPESIZE 0
###################################################################
# 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 D:\IBM\Informix\bar_myids11.log #Path of log file for onbar.exe
BAR_DEBUG_LOG D:\IBM\Informix\bar_myids11.log #Path of the debug log for onbar.exe
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 D:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0
###################################################################
# 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 64
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)
# 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
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 128
DATASKIP
###################################################################
# 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_EXT_DIRECTIVES environment
# variable is enabled
# 2 Enabled even if the IFX_EXT_DIRECTIVES
# 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 -1
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 64
RA_THRESHOLD 16
###################################################################
# 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 0
#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
# informix 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
# 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
# informix
# 0 Only the user informix (Default)
# ADMIN_MODE_USERS - Specifies the user names, separated by
# commas, who can connect to IDS in
# administration mode, in addition to
# the user informix
# SSL_KEYSTORE_LABEL - The label, up to 512 characters, of
# the IDS certificate used in Secure
# Sockets Layer (SSL) protocol
# communications.
###################################################################
#DBCREATE_PERMISSION informix
#DB_LIBRARY_PATH
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
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
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH
###################################################################
# 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
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 - List of up to 16 temporary dbspaces used by an
# SDS server. The format for each dbspace entry is:
# <dbspace_name>,<path>,<pagesize>,<offset>,
# <offset_size>
# Separate entries with a space. Valid for SDS.
# SDS_PAGING - The paths of two buffer paging files,
# Separated by a comma. Valid for SDS only.
# REDIRECTED_WRITES - The number of SMX pipes for redirected writes
# between a primary and a secondary server. Valid
# for HDR, SDS, and RSS. Acceptable values are:
# 0 Disable redirected writes
# 1 through twice the number of CPU VPs
# 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.
#
# Warning: Always verify ROOTPATH before performing
# disk initialization (oninit -i or -iy) to
# avoid disk corruption of another instance
###################################################################
DRAUTO 0
DRINTERVAL 30
DRTIMEOUT 30
HA_ALIAS
DRLOSTFOUND $INFORMIXDIR\etc\dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT 20
SDS_TEMPDBS
SDS_PAGING
REDIRECTED_WRITES 0
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 D:\IBM\Informix\tmp # Preserve diagnostics in this directory
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 D:\IBM\Informix\etc\alarmprogram.bat # Alarm program path
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3
#SYSALARMPROGRAM $INFORMIXDIR\etc\evidence.bat
###################################################################
# 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 6250
RAS_LLOG_SPEED 0
###################################################################
# 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
# 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 D:\IBM\Informix\extend\krakatoa\jre # JDK installation root directory
JVPHOME D:\IBM\Informix\extend\krakatoa # Krakatoa installation directory
JVPPROPFILE D:\IBM\Informix\extend\krakatoa\.jvpprops_myids11 # JVP property file
JVPLOGFILE D:\IBM\Informix\extend\krakatoa\myids11_jvp.log # VP log file
JDKVERSION 1.4
JVPJAVALIB \bin\
JVPJAVAVM jsig;dbgmalloc;hpi;jvm;java;net;zip;jpeg
JVPCLASSPATH D:\IBM\Informix\extend\krakatoa\krakatoa.jar;D:\IBM\Informix\extend\krakatoa\jdbc.jar
###################################################################
# BUFFERPOOL and LRU Configuration Parameters
###################################################################
# BUFFERPOOL - Configure the buffer pool for each designated
# page size. The onconfig.std file contains one
# entry - the default. When a buffer pool must
# be created and the ONCONFIG file has no buffer
# pool specification for the page size, the
# default buffer pool is used.
# As you add dbspaces with different page sizes,
# IDS will add a BUFFERPOOL entry (with 'size=Nk'
# in place of default) to the onconfig file.
# LRU Tuning is included in BUFFERPOOL settings.
# With interval checkpoints, these values can
# now be set higher than in previous versions of
# IDS in an OLTP environment.
# AUTO_LRU_TUNING . Control whether IDS tunes LRUs automatically.
# When enabled (1), IDS will increase the LRU
# flushing if it is unable to find low priority
# buffer for a number page faults.
###################################################################
BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
BUFFERPOOL size=4K,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
AUTO_LRU_TUNING 1 |
|
免费注册
发表于 2008-05-06 15:23
发表于 2008-05-06 15:24
