################################################################### # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # Copyright IBM Corporation 1996, 2010. All rights reserved. # # Title: onconfig.std # Description: IBM Informix Dynamic Server Configuration Parameters # # Important: /informix now resolves to the environment # variable INFORMIXDIR. Replace the value of the INFORMIXDIR # environment variable only if the path you want is not under # /informix. # # 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 /informix/dbspaces/rootdbs_chk01 ROOTOFFSET 32 ROOTSIZE 32768000 MIRROR 0 MIRRORPATH /informix/ 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 32768000 PLOG_OVERFLOW_PATH /informix/tmp PHYSBUFF 1024 ################################################################### # 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 110 LOGSIZE 10000 DYNAMIC_LOGS 2 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 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 /informix_dump/online.log MSG_DATE 1 CONSOLE /informix_dump/online.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 5000 TBLTBLNEXT 2000 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 tempdbs1,tempdbs2,tempdbs3,tempdbs4,tempdbs5,tempdbs6,tempdbs7,tempdbs8 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 ONDBSPACEDOWN 0 ################################################################### # 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 DBSERVERNAME topas_sec DBSERVERALIASES ################################################################### # Network Configuration Parameters ################################################################### # NETTYPE - The configuration of poll threads # for a specific protocol. The # format is: # NETTYPE ,<# poll threads> # , # ,(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 soctcp,6,300,NET 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] # for example: # num=4,aff=(1-10/3) means assign 4 CPU VPs to processors # 1,4,7,10 # 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=27,noage VP_MEMORY_CACHE_KB 102400 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 - Specifies whether direct I/O is used for cooked # files used for dbspace chunks. # Acceptable values are: # 0 Disable # 1 Enable direct I/O # 2 Enable concurrent I/O ################################################################### #VPCLASS aio,num=1 CLEANERS 32 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 10000000 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 0x700000010000000L SHMVIRTSIZE 8192000 SHMADD 1024000 EXTSHMADD 32000 SHMTOTAL 30000000 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 0 RTO_SERVER_RESTART 0 BLOCKTIMEOUT 3600 ################################################################## # Conversion Guard Related Configuration Parameters ################################################################### # CONVERSION_GUARD - To turn on conversion guard feature. # - 0 - Off, # - 1 - On, Abort conversion on Conversion Guard error, # - 2 - On, Continue conversion; ignore Conversion # Guard error # # RESTORE_POINT_DIR - The directory, which stores the Conversion Guard # - feature generated files. ################################################################### CONVERSION_GUARD 2 RESTORE_POINT_DIR /informix/tmp ################################################################### # 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 /dev/null TAPEBLK 8192 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 /dev/null LTAPEBLK 8192 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 # /informix/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 /informix_dump/bar_act.log BAR_DEBUG_LOG /informix_dump/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 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 107 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 73 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 73 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 2 STMT_CACHE_HITS 2 STMT_CACHE_SIZE 20480 STMT_CACHE_NOLIMIT 1 STMT_CACHE_NUMPOOL 24 ################################################################### # 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 256 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 85 MAX_FILL_DATA_PAGES 0 BTSCANNER num=4,threshold=10000,rangesize=-1,alice=6,compression=default ONLIDX_MAXMEM 204800 ################################################################### # 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 ... Skip listed # dbspaces # - OFF Do not skip dbspaces (default) ################################################################### MAX_PDQPRIORITY 100 DS_MAX_QUERIES DS_TOTAL_MEMORY 4096000 DS_MAX_SCANS 1048576 DS_NONPDQ_QUERY_MEM 102400 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_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 0 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 0 AUTO_REPREPARE 1 ################################################################### # Scan 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 #BATCHEDREAD_TABLE - Turn on/off xps api for table scans ################################################################### RA_PAGES 128 RA_THRESHOLD 32 BATCHEDREAD_TABLE 0 ################################################################### # 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 # 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 # 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 # 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: # , # 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: # , # 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 - The temporary dbspace used by an SDS server. # The format is: # ,,,, # # 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. # DELAY_APPLY - Specifies a delay factor for RSS # secondary nodes. The format is ###[DHMS] where # D stands for days # H stands for hours # M stands for minutes # S stands for seconds (default) # STOP_APPLY - Halts the apply on an RSS node # 1 halts the apply # 0 resumes the apply (default) # YYYY:MM:DD:hh:mm:ss - time at which to stop # LOG_STAGING_DIR - Specifies a directory in which to stage log files ################################################################### DRAUTO 3 DRINTERVAL 30 DRTIMEOUT 15 HA_ALIAS DRLOSTFOUND /informix/etc/dr.lostfound DRIDXAUTO 0 LOG_INDEX_BUILDS SDS_ENABLE 1 SDS_TIMEOUT 60 SDS_TEMPDBS sdstemp2,/informix/dbspaces/sdstemp2_chk01,4,32,16384000 SDS_TEMPDBS sdstemp4,/informix/dbspaces/sdstemp4_chk01,4,32,16384000 SDS_TEMPDBS sdstemp6,/informix/dbspaces/sdstemp6_chk01,4,32,16384000 SDS_TEMPDBS sdstemp8,/informix/dbspaces/sdstemp8_chk01,4,32,16384000 SDS_TEMPDBS sdstemp10,/informix/dbspaces/sdstemp10_chk01,4,32,16384000 SDS_TEMPDBS sdstemp12,/informix/dbspaces/sdstemp12_chk01,4,32,16384000 SDS_PAGING /informix/tmp/sds_paging1,/informix/tmp/sds_paging2 UPDATABLE_SECONDARY 18 FAILOVER_CALLBACK TEMPTAB_NOLOG 1 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR ################################################################### # 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 19 OFF_RECVRY_THREADS 19 ################################################################### # 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 /informix_dump DUMPSHMEM 0 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: # 0 Logs only noteworthy events # 1 Logs all events # STORAGE_FULL_ALARM -