################################################################## # Licensed Material - Property of IBM Corporation # # "Restricted Materials of IBM Corporation" # # IBM Informix Dynamic Server # Copyright IBM Corporation 2001, 2019. 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://www.ibm.com/support/knowledgecenter/SSGU8G/welcomeIfxServers.html ################################################################### ################################################################### # 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 /DATA/IFMXDATA/d530_db1/rootdbs.000 ROOTOFFSET 0 #ROOTSIZE 6801038 ROOTSIZE 13602076 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 29792 PHYSFILE 800000 PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp # PHYSBUFF 512 #PHYSBUFF 256 - FeG PHYSBUFF 4096 ################################################################### # 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. The server adds a new logical log to the # root dbspace when necessary. # 1 Manual. The server notifies the DBA to add new logical # logs when necessary. # 0 Disabled # LOGBUFF - The size of the logical log buffer, in KB # AUTO_LLOG - Add logical logs automatically to improve performance ################################################################### LOGFILES 200 # LOGSIZE 7680 LOGSIZE 30000 DYNAMIC_LOGS 2 #LOGBUFF 128 -FeG LOGBUFF 4096 ################################################################### # Long Transaction Configuration Parameters ################################################################### # If The server 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 server message log file # MSG_DATE - When set to 1, each message in the log will be # preceded by a date in MM/DD/YY format. # CONSOLE - The path of the server console message file ################################################################### MSGPATH /opt/IBM/informix_1410/log/d530_db1.log CONSOLE /dev/console MSG_DATE 0 # CONSOLE $INFORMIXDIR/tmp/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 the server to manage # extent sizes automatically. # # TBLSPACE_STATS - Enables (1) or disables (0) the server 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, the server stores statistics # in the sysdistrib system catalog table. # ONDBSPACEDOWN - Specifies how the server behaves when it encounters a # dbspace that is offline. Acceptable values # are: # 0 Continue # 1 Stop # 2 Wait for DBA action ################################################################### # SBSPACENAME sbspace # SYSSBSPACENAME # ONDBSPACEDOWN 2 SBSPACENAME sblobdbs SYSSBSPACENAME sblobdbs ONDBSPACEDOWN 2 ################################################################### # System Configuration Parameters ################################################################### # SERVERNUM - The unique ID for the server 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 # FULL_DISK_INIT - Specifies if oninit -i can run: # 0 allows full disk initialization only if no # instance is detected at the rootchunk location. # For oninit -ie allows full disk initialization # only if no existing encryption key database or # stashfile are found. # 1 required if an existing instance is detected at # the rootchunk location. For oninit -ie, # required if an existing encryption key database # or stashfile is found. ################################################################### SERVERNUM 7 DBSERVERNAME d530_db1 DBSERVERALIASES FULL_DISK_INIT 0 ################################################################### # 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 the server # waits for a connection # MAX_INCOMPLETE_CONNECTIONS - The maximum number of incomplete # connections before the server logs a Denial # of Service (DoS) error # FASTPOLL - Enables (1) or disables (0) fast # polling of your network, if your # operating system supports it. # NUMFDSERVERS - The maximum number of poll threads to handle # network connections migrating between VPs # NS_CACHE - The number of seconds for Informix name service # cache (host, service, user, group, sqlhosts) # expiration time. A value of 0 disables the cache. # NET_IO_TIMEOUT_ALARM - Controls notifications about blocked network # write operations # DRDA_COMMBUFFSIZE - Specifies size of the DRDA communications buffe ################################################################### NETTYPE ipcshm,1,50,CPU #20210921 NETTYPE soctcp,1,250,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 NUMFDSERVERS 4 #20210921 #NS_CACHE host=900,service=900,user=900,group=900,sqlhosts=900 NS_CACHE host=900,service=900,user=0,group=900,sqlhosts=900 NET_IO_TIMEOUT_ALARM 0 DRDA_COMMBUFFSIZE 32 ################################################################### # 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 and whether # the memory changes dynamically (default). # Format is: [,DYNAMIC|STATIC] # Acceptable values for are: # 0 (disable) # 800 through 40% of the value of SHMTOTAL # SINGLE_CPU_VP - Optimizes performance if the server 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=8,noage --FeG VP_MEMORY_CACHE_KB 0 SINGLE_CPU_VP 0 VPCLASS cpu,autotune=1 VPCLASS aio,autotune=1 ################################################################### # # AUTO_TUNE - The value of this parameter serves as the default value for # the following AUTO_* parameters: # AUTO_AIOVPS # AUTO_CKPTS # AUTO_REPREPARE # AUTO_STAT_MODE # AUTO_READAHEAD # AUTO_LRU_TUNING # # Any of the above parameters that are not present in your config file # will default to the value of AUTO_TUNE, which can be set to either 0 or 1. # If an AUTO_* parameter is set in your config file, the given value overrides # that of AUTO_TUNE. Information on individual AUTO_* parameters is below. # # AUTO_LRU_TUNING - Enables (1) or disables (0) automatic LRU tuning, which # adjusts flushing thresholds for individual buffer pools # if the server discovers they are sub-optimal # AUTO_AIOVPS - Enables (1) or disables (0) automatic management # of AIO VPs # 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. # 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. # AUTO_STAT_MODE - Enables (1) or disables (0) update statistics # automatic mode. In automatic mode, statistics of # table, fragment or index are rebuilt only if existing # statistics are considered stale. A table, fragment # or index can change by STATCHANGE percentage before # its statistics are regarded as stale. # # RA_PAGES & RA_THRESHOLD have been replaced with AUTO_READAHEAD. # # AUTO_READAHEAD mode[,readahead_cnt] # mode 0 = Disable (Not recommended) # 1 = Passive (Default) # 2 = Aggressive (Not recommended) # readahead_cnt Optional Range 4-4096 # readahead_cnt allows for tuning the # of # pages that automatic readahead will request # to be read ahead. When not set, the default # is 128 pages. # # Notes: # The threshold for starting the next readahead request, which # used to be known as RA_THRESHOLD, is always set to 1/2 of the # readahead_cnt. RA_THRESHOLD is deprecated and no longer used. # # If RA_PAGES & AUTO_READAHEAD are not present in the ONCONFIG file, # AUTO_READAHEAD will default to the value of AUTO_TUNE. # # If RA_PAGES is present in the ONCONFIG file and AUTO_READAHEAD is # not, the server will set AUTO_READAHEAD to AUTO_TUNE,RA_PAGES # ################################################################### AUTO_TUNE 1 # FeG AUTO_READAHEAD 1,1024 AUTO_LRU_TUNING 1 AUTO_AIOVPS 1 AUTO_REPREPARE 1 AUTO_STAT_MODE 1 AUTO_CKPTS 1 ################################################################### # AIO and Cleaner-Related Configuration Parameters ################################################################### # VPCLASS aio - Configures the AIO VPs. The format is: # VPCLASS aio,num=<#>[,max=<#>][,aff=<#>][,noage] # Example: # VPCLASS aio,num=1 # CLEANERS - The number of page cleaner threads # DIRECT_IO - Set of flags that may be combined to control "special" I/O # 0x0 = Neither direct I/O nor concurrent I/O is used # 0x1 = Direct I/O is used if available # 0x2 = Concurrent I/O is enabled (on AIX operating systems) # 0x4 = Special I/O is enabled for TEMP DBspaces ################################################################### #CLEANERS 2 -- FeG CLEANERS 32 DIRECT_IO 1 ################################################################### # Lock-Related Configuration Parameters ################################################################### # LOCKS - The initial number of locks when the server 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 4000000 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 the server, # in KB. A 0 indicates no specific limit. # SHMVIRT_ALLOCSEG - Controls when the server 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 total percentage # of virtual memory used before a segment is added # - The total KB virtual memory 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 the server 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 0x44000000L SHMVIRTSIZE 409600 #SHMADD 32768 -- FeG SHMADD 9175040 EXTSHMADD 8192 SHMTOTAL 0 SHMVIRT_ALLOCSEG 0,3 SHMNOACCESS ################################################################### # Checkpoint and System Block Configuration Parameters ################################################################### # CKPINTVL - Specifies how often, in seconds, the server checks # if a checkpoint is needed. 0 indicates that # the server does not check for checkpoints. Ignored # if RTO_SERVER_RESTART is set. # RTO_SERVER_RESTART - Specifies, in seconds, the Recovery Time # Objective for the server 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 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 $INFORMIXDIR/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 TAPEDEV /BKUP/IFMXBKUP/d530_db1.ontape TAPEBLK 32 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 32 LTAPESIZE 10240 ################################################################### # 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 or restore processes used # in a backup or restore. Acceptable values are # 0 (unlimited) or any positive integer. # BAR_MAX_RESTORE - The number of restore processes used in a # restore. Acceptable values are 0 (unlimited) # or any positive integer. If set, overrides # the value of BAR_MAX_BACKUP during restore. # 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. # If PSM is the storage manager, higher values # can be used. # 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 server instance and the storage # manager # 2 = Display timestamps in microseconds # 3 = Display both timestamps and transfer # statistics # BAR_CKPTSEC_TIMEOUT - Time in seconds to wait for an archive # checkpoint to complete in the secondary server # BAR_HISTORY - Specifies whether the sysutils database maintains # a backup history when you use onsmsync to expire # old backups. # BAR_ENCRYPTION - Specifies a cipher algorithm and either a # keyfile or credential store # use to retrieve encryption key to encrypt # both dbspace and log backups # BAR_DECRYPTION - Specifies a keyfile or credential store # to decrypt backups that were encrypted using # BAR_ENCRYPTION, this parameter is optional. # ################################################################### BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_MAX_RESTORE 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 BAR_CKPTSEC_TIMEOUT 15 BAR_HISTORY 0 ################################################################### # Primary Storage Manager (PSM) Configuration Parameters ################################################################### # PSM_ACT_LOG - The ON-Bar activity log file location. # Do not use the /tmp directory. Use a # directory with restricted permissions. # If not set the value of BAR_ACT_LOG is used. # PSM_DEBUG_LOG - The PSM debug log file location. # Do not use the /tmp directory. Use a # directory with restricted permissions. # If not set the value of BAR_DEBUG_LOG is used. # PSM_DEBUG - The debug level for PSM. Acceptable # values are 0 (off) through 9 (high). # If not set the value of BAR_DEBUG is used. # PSM_CATALOG_PATH - The directory that will hold the PSM catalog # The default is $INFORMIXDIR/etc/psm. # PSM_DBS_POOL - The Pool where to place dbspace data. # The default is "DBSPOOL" # PSM_LOG_POOL - The Pool where to place log data. # The default is "LOGPOOL" # ################################################################### PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL ################################################################### # 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 1013 DD_HASHMAX 10 ################################################################### # Data Distribution Configuration Parameters ################################################################### # DS_HASHSIZE - The number of data distribution 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 503 DS_POOLSIZE 2000 ################################################################## # User Defined Routine (UDR) 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. # PRELOAD_DLL_FILE - Specifies a C UDR shared library path name # to load when the server starts. Each # shared library file needs a separate # PRELOAD_DLL_FILE entry. ################################################################### PC_HASHSIZE 503 PC_POOLSIZE 2000 PRELOAD_DLL_FILE ################################################################### # 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_QUERY_PLAN - Stores query plan for each SQL statement # Acceptable values are: # 0 Disabled # 1 Enabled ################################################################### STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 STMT_CACHE_QUERY_PLAN 0 ################################################################### # 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 512 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 ... 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 256 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. # STATCHANGE - In automatic mode, rebuild statistics only for # table, fragment or index changed by STATCHANGE # percentage since last statistics run. # USTLOW_SAMPLE - Enables (1) or disables (0) the use of sampling # during update statistics low operations that gather # index statistics for large indexes. #################################################################### OPTCOMPIND 2 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 1 STATCHANGE 10 USTLOW_SAMPLE 1 ################################################################### # Scan Configuration Parameters ################################################################### #BATCHEDREAD_TABLE - Turn on/off xps api for table scans. #BATCHEDREAD_INDEX - Turn on/off xps api for index scans. ################################################################### BATCHEDREAD_TABLE 1 BATCHEDREAD_INDEX 1 ################################################################### # 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) # Example: # SQLTRACE level=low,ntraces=1000,size=2,mode=global ################################################################### EXPLAIN_STAT 1 ################################################################### # 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 the server. # Example: # DBCREATE_PERMISSION informix # DB_LIBRARY_PATH - Specifies the locations, separated # by commas, from which the server 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 the server 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 the server # 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 the server in # administration mode, in addition to # the user informix # SSL_KEYSTORE_LABEL - The label, up to 512 characters, of # the server certificate used in Secure # Sockets Layer (SSL) protocol # communications. # TLS_VERSION - Specifies which TLS levels will be # allowed. Default is 1.2 ################################################################### IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION UNSECURE_ONSTAT ADMIN_USER_MODE_WITH_DBSA 1 ADMIN_MODE_USERS informix, jupi SSL_KEYSTORE_LABEL TLS_VERSION ################################################################### # 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 ################################################################### # Built-in Character Data Types Parameters ################################################################### # SQL_LOGICAL_CHAR - Enable/Disable the expansion of size # specification for built-in character data # types ################################################################### SQL_LOGICAL_CHAR OFF ################################################################### # Sequence Cache Parameters ################################################################### # SEQ_CACHE_SIZE - Maximum number of sequence objects that can # have preallocated values in sequence cache ################################################################### SEQ_CACHE_SIZE 10 ################################################################### # 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_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_DELAY_PURGE_DTC - Specifies the time at which delete table purge # can be delayed. # CDR_LOG_LAG_ACTION - Specifies the action when ER log # processing lags behind the current log. # Separate multiple actions with a plus sign (+). # Actions are prioritized from left to right. # Supported options are: # logstag: Enable compressed logical log staging. # Stage log files in the directory # specified by the LOG_STAGING_DIR # configuration parameter. The # CDR_LOG_STAGING_MAXSIZE # configuration parameter must also be set. # dlog: Enable adding dynamic logs. The # CDR_MAX_DYNAMIC_LOGS and # DYNAMIC_LOGS configuration parameters # must be enabled. # ignore: Prevents blocking client update activity. # The replay position can be overrun. # ddrblock: (Default) Block client update activity # to avoid overrunning the log replay position. # shutdown: Shut down ER if the log replay # position is in danger of being overrun. # Restart ER using the cdr cleanstart # command and resynchronize the data. # Supported combinations: # logstage+dlog+ddrblock # logstage+dlog+ignore # logstage+dlog+shutdown # logstage+ddrblock # logstage+ignore # logstage+shutdown # dlog+ddrblock # dlog+ignore # dlog+shutdown # ddrblock # ignore # shutdown # # CDR_LOG_STAGING_MAXSIZE - Maximum size, in KB (default), # MB, GB, or TB, that ER can use to stage log files in # the directory specified by the LOG_STAGING_DIR # configuration parameter. ER temporarily stops # staging log files, at a log file boundary, when the # staging directory reaches this value. # 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) # # GRIDCOPY_DIR Staging Directory for the ifx_grid_copy # procedure. # # CDR_TSINSTANCEID Server specific unique id to make timeseries instance # id unique across all Enterprise Replication servers. # Acceptable values are: 0 (default) through 32768. # # CDR_MAX_FLUSH_SIZE The max number of replicated transactions # applied before a log flush is performed. # # CDR_AUTO_DISCOVER Enables (1) or disables (0) trusted-host file # and SQLHOSTS file # auto-configuration on Enterprise Replication nodes # and high-availability replication servers. Set this # parameter to 1 to use 'cdr autoconfig server' and # 'ifxclone --autoconf' commands. # # CDR_MEM Defines the strategy that Enterprise Replication # uses to allocate memory. # # Allowed values are: # 0 - Allocate memory from a single memory pool # 1 - Allocate memory by CPUVP # 2 - Allocate memory by fixed block sizes # # When CDR_MEM is 0, then the memory pool size # tends to be the smallest, but memory allocations # can take longer. # When CDR_MEM is 1, then the memory pool sizes will # tend to be somewhere between 0 and 2. Memory # allocations can take longer, but other threads # can allocate memory in parallel. # When CDR_MEM is 2, then memory allocations tend # to be very fast, but at the expense of a # significantly larger memory pool. # ################################################################### CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 131072 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_QDATA_SBSPACE CDR_SUPPRESS_ATSRISWARN CDR_DELAY_PURGE_DTC 0 CDR_LOG_LAG_ACTION ddrblock CDR_LOG_STAGING_MAXSIZE 0 CDR_MAX_DYNAMIC_LOGS 0 GRIDCOPY_DIR $INFORMIXDIR CDR_TSINSTANCEID 0 CDR_MAX_FLUSH_SIZE 50 CDR_AUTO_DISCOVER 0 CDR_MEM 0 ################################################################### # Parallel Sharded Queries # Configuration Parameters # # SHARD_MEM Defines the strategy that parallel sharded queries # use to allocate memory. # # Allowed values are: # 0 - Allocate memory from a single memory pool # 1 - Allocate memory by CPUVP # 2 - Allocate memory by fixed block sizes # # When SHARD_MEM is 0, then the memory pool size # tends to be the smallest, but memory allocations # can take longer. # When SHARD_MEM is 1, then the memory pool sizes will # tend to be somewhere between 0 and 2. Memory # allocations can take longer, but other threads # can allocate memory in parallel. # When SHARD_MEM is 2, then memory allocations tend # to be very fast, but at the expense of a # significantly larger memory pool. # # SHARD_ID Used to identify this node in the shard cluster # # 0 - Default. Parallel sharded queries are disabled. # 1-65535 - Each shard server must have a different number # # SHARD_EDGE_NODE Used to designate local server as shard edge server # where local server can participate in shard query # as a edge server without having to define # Enterprise Replication for local server. # Edge server cannot be used as a coordinator for for shard query. # 0 - Default. Disabled. # 1 - Shard edge server. # ################################################################## SHARD_MEM 0 SHARD_ID 0 SHARD_EDGE_NODE 0 ################################################################### # High Availability Cluster (HDR, SDS, and RSS) # Configuration Parameters ################################################################### # DRAUTO - Controls automatic failover for HDR systems. # If the connection manager is providing failover, # then the only value which should be used is '3'. # Additionally, if the connection manager is being # used to provide failover services, then a manual # failover (onmode -d standard or onmode -d make primary) # should not be performed without first # bringing down the connection managers. # # Acceptable values are: # 0 No automatic failover # 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. # If set to zero then DRINTERVAL is not used and # HDR_TXN_SCOPE will be used instead. # HDR_TXN_SCOPE - Defines transactional synchronization in the # HDR primary when DRINTERVAL is turned off # The default is NEAR_SYNC. # Valid values are # ASYNC - Commits are not synced # NEAR_SYNC - The committed transaction has been # sent to the HDR secondary but not yet # applied. # FULL_SYNC - The transaction has been sent and # applied on the HDR secondary. # 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. # HA_FOC_ORDER - The cluster failover rules. # Values are MANUAL or some order of SDS,HDR,RSS. # Individual server names are not allowed. The default # of SDS,HDR,RSS is the preferred failover order. # If you do not have one of the secondary types # then that type is skipped. If for any reason none # of the server types are available, then a manual failover # will be performed. # # This parameter will override any FOC parameter contained # in the cmsm configuration file. # 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_ALTERNATE - Define an alternate means of communicating between # the primary and SDS node. This is used if the # normal network communication between the primary # and secondary becomes unavailable. # SDS_FLOW_CONTROL - Defines the point at which SDS flow control will # be activated. Values defined as being # SDS_FLOW_CONTROL , # where start is the point at which flow control # is activated and end is the point at which it # deactivated. Valid values are # -1 - Never use flow control - can result in a # log wrap # 0 Default (12 times log buffer size) # Start,Stop - where start should be a larger value # than Stop. The values can have a scale # factor of 'K', 'M', 'G' for kilobytes, # megabyte, gigabyte. # Example: # SDS_FLOW_CONTROL 10000K,9000K # SDS_PAGING - The paths of two buffer paging files, # Separated by a comma. Valid for SDS only. # SDS_LOGCHECK - The time, in seconds, that the SDS server waits # to detect if the primary server is generating # log activity before allowing failover to the # secondary server. # Acceptable values are: # 0 Do not detect. Allow failover. (default) # n Wait up to n seconds. If detected that the # primary is generating log activity, then failover # is stopped. Otherwise, failover is allowed. # 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 - On an RS secondary server, specifies an amount # of time to delay application of received logical logs. # ###[unit] using one of the following units: # D - Days # H - Hours # M - Minutes # S - Seconds (default unit) # STOP_APPLY - On an RS secondary server, stops, or specifies # a time to stop the application of logical logs. # 1 Stop application. # 0 Do not stop application (default). # YYYY:MM:DD-hh:mm:ss Stop application at this # data and time. # Y - Year # M - Month # D - Day # h - Hour (24-hour notation) # m - Minute # s - Second # LOG_STAGING_DIR - Specifies a directory in which to stage log files # RSS_FLOW_CONTROL - Defines the point at which RSS flow control will # be activated. Values defined as being # RSS_FLOW_CONTROL , # where start is the point at which flow control # is activated and end is the point at which it # deactivated. Valid values are # -1 - Never use flow control - can result in a # log wrap # 0 Default (12 times log buffer size) # Start,Stop - where start should be a larger value # than Stop. The values can have a scale # factor of 'K', 'M', 'G' for kilobytes, # megabyte, gigabyte. # Example: # RSS_FLOW_CONTROL 10000K,9000K # FAILOVER_TX_TIMEOUT - Specifies the timeout for a failover to take # before transaction survival is abandonded # ENABLE_SNAPSHOT_COPY- Specifies whether we can clone this instance # Directly to another machine using the # Snapshot Clone facility. # 1 - Enable snapshot copies # 0 - Disable snapshot copies # SMX_NUMPIPES - Defines the number of network pipes to be used by # RSS. This value is used to set the level of # network threading for SMX, which can increase the # transfer rates on slower network connections. # The valid values are 1 and above. # SMX_COMPRESS - Controls the network interface compression level. # Acceptable values are: # -1 - Never # 0 - None # 1-9 - Compression level # SMX_PING_INTERVAL - Specifies the maximum number of seconds to wait before # closing a network connection to an unresponsive # peer server. # Acceptable values are: # 0 Connections are not closed # 1-60 Number of seconds to wait # SMX_PING_RETRY - Specifies the number of times to repeat # SMX_PING_INTERVAL before closing a connection. # Can be any positive numeric value. # CLUSTER_TXN_SCOPE - Defines the scope of the awareness of a transaction # executing on a cluster. This defines the scope of # that transaction's updates as part of the commit. # The default is SERVER # SESSION - The session is made aware of the changes # SERVER - The sessions running on the secondary server # are made aware of the transaction's changes. # CLUSTER - Any session running on the cluster is made # aware of the transactions's changes. # RSS_NONBLOCKING_CKPT- Enable non-blocking checkpoint at RS secondary server. # 1 - Enable non-blocking checkpoints, continue log replay # while flushing modified buffers to disk during # checkpoint operation. # 0 - (Default) Disable non-blocking checkpoints # SEC_APPLY_POLLTIME - In micro seconds, how long apply thread should # poll for new work before yielding. # Recommended value for smaller systems # (between 1 to 8 CPUVPs): 0 # Recommended value for medium systems # (between 8 and 16 CPUVPS): 10 # Recommended value for larger systems # (> 16 CPUVPS): 1000 # Note: with poll time > 0,recommended to configure poll # threads to run on NET VP. See NETTYPE config parameter. # SEC_LOGREC_MAXBUFS - Configure number of 16K buffers to be used # for replaying log records. # If set to zero, default value: # 5 * OFF_RECVRY_THREADS. # Recommended value : 1000 buffers # SEC_DR_BUFS - Configure number of DR buffers to be used # for replicating log records to secondary server. # Buffer size is same as LOGBUFF config value. # Default value: 12 ################################################################### DRAUTO 0 DRINTERVAL 0 HDR_TXN_SCOPE NEAR_SYNC DRTIMEOUT 30 HA_ALIAS HA_FOC_ORDER SDS,HDR,RSS DRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound DRIDXAUTO 0 LOG_INDEX_BUILDS SDS_ENABLE SDS_TIMEOUT 20 SDS_TEMPDBS SDS_PAGING SDS_LOGCHECK 10 SDS_ALTERNATE NONE SDS_FLOW_CONTROL 0 UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK FAILOVER_TX_TIMEOUT 0 TEMPTAB_NOLOG 0 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR RSS_FLOW_CONTROL 0 SMX_NUMPIPES 1 ENABLE_SNAPSHOT_COPY 0 SMX_COMPRESS 0 SMX_PING_INTERVAL 10 SMX_PING_RETRY 6 CLUSTER_TXN_SCOPE SERVER RSS_NONBLOCKING_CKPT 0 SEC_LOGREC_MAXBUFS 1000 SEC_DR_BUFS 12 SEC_APPLY_POLLTIME 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 # 5 Managed shared memory dumps, dumping all shared memory # 6 Managed shared memory dumps, excluding the buffer pool # DUMPGCORE - Enables (1) or disables (0) whether the server dumps a # core using gcore # DUMPCORE - Enables (1) or disables (0) whether the server dumps a # core after an AF # DUMPCNT - An integer representing the maximum number of shared memory # dumps or core files for a single thread, or, for managed # shared memory dumps, the extended format: # thrdlimit=<#>,instlimit=<#>,insttime=<#>,interval=<#> # where all parameters are optional and have these meanings: # - thrdlimit = max number of shared memory dumps per thread # - instlimit = max number of shared memory dumps for the # instance in the time period defined by # insttime. The default value value of 0 # implies no limit. # - insttime = time period in seconds for the limit of shared # memory dumps defined by instlimit. The default # is 0 which means no time limit and instlimit # then becomes a maximum count until the instance # is restarted. # - interval = minimum interval in seconds between the # completion of one shared memory dump before # another is permitted. The default is 300 seconds. ################################################################### DUMPDIR $INFORMIXDIR/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: # 0 Logs only noteworthy events # 1 Logs all events # STORAGE_FULL_ALARM -