DRAUTO                  0
DRINTERVAL              -1 
DRTIMEOUT               30
HA_ALIAS
DRLOSTFOUND             $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO               0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT             20
SDS_TEMPDBS
SDS_PAGING
UPDATABLE_SECONDARY     0
FAILOVER_CALLBACK
FAILOVER_TX_TIMEOUT     0
TEMPTAB_NOLOG           0
DELAY_APPLY             0
STOP_APPLY              0

04:08:16  DR: ping timeout
04:08:16  DR: Receive error
04:08:17  ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = : Network connection is broken.
 System error = 4.
04:08:17  DR_ERR set to -1
04:08:18  DR: Turned off on primary server
04:08:18  DR: Cannot connect to secondary server
04:08:29  DR: Primary server connected
04:08:29  DR: Secondary server needs failure recovery

04:08:17  DR: Send error
04:08:17  ASF Echo-Thread Server: asfcode = -25580: oserr = 32: errstr = : System error occurred in network function. 
 System error = 32.
04:08:17  DR_ERR set to -2
04:08:17  DR: Turned off on secondary server
04:08:27  DR: Secondary server connected
04:08:28  DR: Secondary server needs failure recovery

IBM Informix Dynamic Server Version 11.50.FC5W3   -- On-Line (Prim) (CKPT INP) -- Up 00:14:55 -- 23458472 Kbytes

Userthreads
address          flags   sessid   user     tty      wait             tout locks nreads   nwrites
55ea6d028        ---P--D 1        root     -        0                0    0     119      353
55ea6d878        ---P--F 0        root     -        0                0    0     0        39220
55ea6e0c8        ---P--F 0        root     -        0                0    0     0        134275
55ea6e918        ---P--F 0        root     -        0                0    0     0        46455
55ea6f168        ---P--F 0        root     -        0                0    0     0        40266
55ea6f9b8        ---P--F 0        root     -        0                0    0     0        56633
55ea70208        ---P--F 0        root     -        0                0    0     0        0
55ea70a58        ---P--F 0        root     -        0                0    0     0        0
55ea712a8        ---P--F 0        root     -        0                0    0     0        0
55ea71af8        ---P--F 0        root     -        0                0    0     0        0
55ea72348        ---P--F 0        root     -        0                0    0     0        0
55ea72b98        ---P--F 0        root     -        0                0    0     0        0
55ea733e8        ---P--F 0        root     -        0                0    0     0        0
55ea73c38        ---P--F 0        root     -        0                0    0     0        0
55ea74488        ---P--F 0        root     -        0                0    0     0        0
55ea74cd8        ---P--F 0        root     -        0                0    0     0        0
55ea75528        ---P--F 0        root     -        0                0    0     0        0
55ea75d78        ---P--F 0        root     -        0                0    0     0        0
55ea765c8        ---P--F 0        root     -        0                0    0     0        0
55ea76e18        ---P--F 0        root     -        0                0    0     0        0
55ea77668        ---P--F 0        root     -        0                0    0     0        0
55ea77eb8        ---P--F 0        root     -        0                0    0     0        0
55ea78708        ---P--F 0        root     -        0                0    0     0        0
55ea78f58        ---P--F 0        root     -        0                0    0     0        0
55ea797a8        ---P--F 0        root     -        0                0    0     0        0
55ea79ff8        ---P--F 0        root     -        0                0    0     0        0
55ea7a848        ---P--F 0        root     -        0                0    0     0        0
55ea7b098        ---P--F 0        root     -        0                0    0     0        0
55ea7b8e8        ---P--F 0        root     -        0                0    0     0        0
55ea7c138        ---P--F 0        root     -        0                0    0     0        0
55ea7c988        ---P--F 0        root     -        0                0    0     0        0
55ea7d1d8        ---P--- 11       root     -        0                0    0     0        0
55ea7da28        ---P--B 12       root     -        0                0    0     42536    0
55ea7e278        Y--P--- 31       root     -        560926e68        0    1     334430   0
55ea7eac8        ---P--D 17       root     -        0                0    0     0        1
55ea7f318        Y--P--- 16       informix 0        560c8f7e8        0    0     0        0
55ea7fb68        ---P--D 18       root     -        0                0    0     2        0
55ea803b8        Y--P--D 24       root     -        5608f5a90        0    0     168449   9
55ea80c08        ---P--- 26       informix -        0                0    1     238      13
55ea81458        ---P--D 27       root     -        0                0    0     0        0
55ea81ca8        ---P--D 28       root     -        0                0    0     0        0
55ea824f8        ---P--- 29       informix -        0                0    1     292      16
55ea82d48        ---P--- 30       informix -        0                0    1     119      10
55ea83598        Y--P--- 32       root     -        560c8ff88        0    0     0        0
55ea83de8        Y--P--D 34       root     -        5356a838         0    0     0        0
55ea84638        Y--P--- 35       onusr    -        560fa4c68        0    1     78       0
55ea84e88        Y--P--- 36       onusr    -        56100eac8        0    1     184      0
55ea856d8        G-BPX-- 37       onusr    -        55fffcdd8        0    1     35441    33833
55ea85f28        Y--P--- 38       onusr    -        561008c88        0    1     35904    33700
55ea86778        Y--P--- 39       onusr    -        56129a550        0    1     35610    33946
55ea86fc8        Y--P--- 40       onusr    -        5612ffc88        0    1     35465    35323
55ea87818        Y--P--- 41       onusr    -        561371d30        0    1     35523    33799
55ea88068        G-BPX-- 42       onusr    -        55fffcdd8        0    1     35549    29735
55ea888b8        Y--P--- 43       onusr    -        56143ddd8        0    1     35428    34653
55ea89108        G-BPX-- 44       onusr    -        55fffcdd8        0    1     35381    31162
55ea89958        Y--P--- 89       root     -        565562d18        0    0     0        0
55ea8a1a8        Y--P--- 46       onusr    -        5628f0848        0    1     29       0
55ea8a9f8        --AP--M 5        root     0        0                0    0     588      0
55ea8b248        --BPX-- 50       onusr    -        0                0    1     1735002  1341943
55ea8ba98        Y--P--- 54       onusr    -        562bbae68        0    1     0        0
55ea8c2e8        Y--P--- 53       onusr    -        562ac0418        0    1     0        0
55ea8cb38        Y--P--- 55       onusr    -        562f217a8        0    1     0        0
55ea8d388        G-BPX-- 56       onusr    -        55fffcdd8        0    1     35239    49099
55ea8dbd8        G-BPX-- 57       onusr    -        55fffcdd8        0    1     36015    50993
55ea8e428        G-BPX-- 58       onusr    -        55fffcef8        0    1     35469    53740
55ea8ec78        Y--P--- 59       onusr    -        5631944c0        0    1     0        0
55ea8f4c8        Y--P--- 60       onusr    -        5634dabe0        0    1     0        0
55ea8fd18        Y--P--- 61       onusr    -        563542370        0    1     0        0
55ea90568        Y--P--- 62       onusr    -        5635a9b38        0    1     0        0
55ea90db8        Y--P--- 63       onusr    -        5635bdf90        0    1     0        0
55ea91608        Y--P--- 64       onusr    -        56367d9e8        0    1     0        0
55ea91e58        Y--P--- 65       onusr    -        5636ea178        0    1     0        0
55ea926a8        Y--P--- 66       onusr    -        563756898        0    1     0        0
55ea92ef8        Y--P--- 67       onusr    -        5637c2028        0    1     0        0
55ea93748        Y--P--- 68       onusr    -        56382e7f0        0    1     0        0
55ea93f98        Y--P--- 69       onusr    -        563899f28        0    1     0        0
55ea947e8        Y--P--- 70       onusr    -        5639096a0        0    1     3        0
55ea95038        Y--P--- 71       onusr    -        563970df0        0    1     0        0
55ea95888        Y--P--- 72       onusr    -        5639e2710        0    1     0        0
55ea960d8        Y--P--- 73       onusr    -        563a4bf98        0    1     0        0
55ea96928        Y--P--- 74       onusr    -        563a4ff88        0    1     0        0
55ea97178        ------- 5        root     0        0                0    0     2630667  0
55ea979c8        ------- 5        root     0        0                0    0     0        185813
 83 active, 128 total, 84 maximum concurrent

[root@onldb23 ~]# onstat -b

IBM Informix Dynamic Server Version 11.50.FC5W3   -- On-Line (Prim) -- Up 00:14:03 -- 23458472 Kbytes

Buffers
address           userthread        flgs pagenum          memaddr           nslots pgflgs xflgs owner             waitlist

Buffer pool page size: 2048
60dcb118         0                84   10:1572145       c1644800         0      0      80    ffffffffffffffff 55ea856d8
 14320 modified, 4000000 total, 4194304 hash buckets, 2048 buffer size

Buffer pool page size: 8192
92609c18         0                802  20:1339112       46ebfe000        150    850    10    0                0
95196278         0                0    20:1033496       4fa1ac000        0      0      80    55ea84638        0
 38474 modified, 1500000 total, 2097152 hash buckets, 8192 buffer size

BUFFERPOOL	size=2K,buffers=4000000,lrus=256,lru_min_dirty=0.100000,lru_max_dirty=0.300000
BUFFERPOOL	size=8K,buffers=1500000,lrus=256,lru_min_dirty=0.500000,lru_max_dirty=1.000000

IBM Informix Dynamic Server Version 11.50.FC5W3   -- On-Line (Prim) -- Up 01:17:51 -- 23458472 Kbytes

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-2  55       128      1319910    35621      37.05
      phybegin         physize    phypos     phyused    %used
      2:53             8250000    2422032    138918     1.68

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-2  3        32       7631596    981379     611378     7.8        1.6
        Subsystem    numrecs    Log Space used
        OLDRSAM      7631565    1172648160
        HA           31         1364

Buffer Waiting
Buffer  ioproc   flags
  L-1   0        0x1      0
  L-2   0        0x1      0

address          number   flags    uniqid   begin                size     used    %used
55d8e1f98        13       U-B----  1129     3:53               500000   500000   100.00
55eac8f50        14       U-B----  1130     3:500053           500000   500000   100.00
55eac8fb8        15       U-B----  1131     3:1000053          500000   500000   100.00
55eaafb50        16       U-B----  1132     3:1500053          500000   500000   100.00
55eaafbb8        17       U-B----  1133     3:2000053          500000   500000   100.00
55eaafc20        18       U-B----  1134     3:2500053          500000   500000   100.00
55eaafc88        19       U-B----  1135     3:3000053          500000   500000   100.00
55eaafcf0        20       U-B----  1136     3:3500053          500000   500000   100.00
55eaafd58        21       U-B----  1137     3:4000053          500000   500000   100.00
55eaafdc0        22       U-B----  1138     3:4500053          500000   500000   100.00
55eaafe28        23       U-B----  1139     3:5000053          500000   500000   100.00
55eaafe90        24       U-B----  1140     3:5500053          500000   298812    59.76
55eaafef8        25       U-B----  1141     3:6000053          500000   268693    53.74
55eaaff60        26       U-B----  1142     3:6500053          500000   500000   100.00
55d8e2418        27       U---C-L  1143     3:7000053          500000   482781    96.56
55d8e2480        28       U-B----  1128     3:7500053          500000   500000   100.00

###################################################################
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# Copyright IBM Corporation 1996, 2009. All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
# Important: $INFORMIXDIR now resolves to the environment
# variable INFORMIXDIR. Replace the value of the INFORMIXDIR  
# environment variable only if the path you want is not under 
# $INFORMIXDIR.
#
# For additional information on the parameters:
# http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
###################################################################

###################################################################
# Root Dbspace Configuration Parameters
###################################################################
# ROOTNAME     - The root dbspace name to contain reserved pages and
#                internal tracking tables.
# ROOTPATH     - The path for the device containing the root dbspace
# ROOTOFFSET   - The offset, in KB, of the root dbspace into the 
#                device. The offset is required for some raw devices. 
# ROOTSIZE     - The size of the root dbspace, in KB.  The value of 
#                200000 allows for a default user space of about 
#                100 MB and the default system space requirements.
# MIRROR       - Enable (1) or disable (0) mirroring
# MIRRORPATH   - The path for the device containing the mirrored 
#                root dbspace
# MIRROROFFSET - The offset, in KB, into the mirrored device 
#
# Warning: Always verify ROOTPATH before performing
#          disk initialization (oninit -i or -iy) to
#          avoid disk corruption of another instance
###################################################################

ROOTNAME rootdbs
ROOTPATH /home/informix/data/rootdbs01
ROOTOFFSET 0
ROOTSIZE 400000
MIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
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        16500000        
PLOG_OVERFLOW_PATH  $INFORMIXDIR/tmp
PHYSBUFF 256

###################################################################
# Logical Log Configuration Parameters
###################################################################
# LOGFILES     - The number of logical log files
# LOGSIZE      - The size of each logical log, in KB
# DYNAMIC_LOGS - The type of dynamic log allocation.
#                Acceptable values are:
#                2 Automatic. IDS adds a new logical log to the
#                  root dbspace when necessary.
#                1 Manual. IDS notifies the DBA to add new logical
#                  logs when necessary.
#                0 Disabled
# LOGBUFF      - The size of the logical log buffer, in KB
###################################################################

LOGFILES        16              
LOGSIZE 300	# logical logs: 16x1Gb
DYNAMIC_LOGS 2
LOGBUFF 64

###################################################################
# Long Transaction Configuration Parameters
###################################################################
# If IDS cannot roll back a long transaction, the server hangs
# until more disk space is available.
#
# LTXHWM       - The percentage of the logical logs that can be
#                filled before a transaction is determined to be a
#                long transaction and is rolled back
# LTXEHWM      - The percentage of the logical logs that have been
#                filled before the server suspends all other
#                transactions so that the long transaction being 
#                rolled back has exclusive use of the logs
#
# When dynamic logging is on, you can set higher values for
# LTXHWM and LTXEHWM because the server can add new logical logs
# during long transaction rollback. Set lower values to limit the 
# number of new logical logs added.
#
# If dynamic logging is off, set LTXHWM and LTXEHWM to
# lower values, such as 50 and 60 or lower, to prevent long 
# transaction rollback from hanging the server due to lack of 
# logical log space.
#
# When using Enterprise Replication, set LTXEHWM to at least 30%
# higher than LTXHWM to minimize log overruns.
###################################################################

LTXHWM 70
LTXEHWM 80

###################################################################
# Server Message File Configuration Parameters
###################################################################
# MSGPATH      - The path of the IDS message log file
# CONSOLE      - The path of the IDS console message file
###################################################################

MSGPATH $INFORMIXDIR/online.log
CONSOLE $INFORMIXDIR/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 0
TBLTBLNEXT 0
TBLSPACE_STATS 0

###################################################################
# 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 tempdbs01, tempdbs02, tempdbs03
SBSPACETEMP

###################################################################
# Dbspace and sbspace Configuration Parameters
###################################################################
# SBSPACENAME    - The default sbspace name where smart large objects
#                  are stored if no sbspace is specified during
#                  smart large object creation. Some DataBlade
#                  modules store smart large objects in this 
#                  location.
# SYSSBSPACENAME - The default sbspace for system statistics 
#                  collection. Otherwise, IDS stores statistics 
#                  in the sysdistrib system catalog table.
# ONDBSPACEDOWN  - Specifies how IDS behaves when it encounters a
#                  dbspace that is offline. Acceptable values 
#                  are:
#                  0 Continue
#                  1 Stop
#                  2 Wait for DBA action
###################################################################

SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 2


###################################################################
# System Configuration Parameters
###################################################################
# SERVERNUM       - The unique ID for the IDS instance. Acceptable 
#                   values are 0 through 255, inclusive.
# DBSERVERNAME    - The name of the default database server
# DBSERVERALIASES - The list of up to 32 alternative dbservernames, 
#                   separated by commas
###################################################################

SERVERNUM 0
DBSERVERNAME	idsipc
DBSERVERALIASES dbnode1

###################################################################
# Network Configuration Parameters
###################################################################
# NETTYPE                    - The configuration of poll threads
#                              for a specific protocol. The
#                              format is:
#                              NETTYPE <protocol>,<# poll threads>
#                              ,<number of connections/thread>
#                              ,(NET|CPU)
#                              You can include multiple NETTYPE
#                              entries for multiple protocols.
# LISTEN_TIMEOUT             - The number of seconds that IDS
#                              waits for a connection
# MAX_INCOMPLETE_CONNECTIONS - The maximum number of incomplete
#                              connections before IDS logs a Denial
#                              of Service (DoS) error
# FASTPOLL		     - Enables (1) or disables (0) fast  
#                              polling of your network, if your  
#                              operating system supports it.
###################################################################

LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1

###################################################################
# CPU-Related Configuration Parameters
###################################################################
# MULTIPROCESSOR      - Specifies whether the computer has multiple
#                       CPUs. Acceptable values are: 0 (single
#                       processor), 1 (multiple processors or
#                       multi-core chips)
# VPCLASS cpu         - Configures the CPU VPs. The format is:
#                       VPCLASS cpu,num=<#>[,max=<#>][,aff=<#>]
#                       [,noage]
# VP_MEMORY_CACHE_KB  - Specifies the amount of private memory 
#                       blocks of your CPU VP, in KB, that the 
#                       database server can access. 
#                       Acceptable values are:
#                       0 (disable)
#                       800 through 40% of the value of SHMTOTAL
# SINGLE_CPU_VP       - Optimizes performance if IDS runs with
#                       only one CPU VP. Acceptable values are:
#                       0 multiple CPU VPs 
#                       Any nonzero value (optimize for one CPU VP)
###################################################################

MULTIPROCESSOR 1
VPCLASS cpu,num=3,noage
VP_MEMORY_CACHE_KB 2048
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
###################################################################

CLEANERS 15
AUTO_AIOVPS 1
DIRECT_IO 1

###################################################################
# Lock-Related Configuration Parameters
###################################################################
# LOCKS              - The initial number of locks when IDS starts.
#                      Dynamic locking can add extra locks if needed.
# DEF_TABLE_LOCKMODE - The default table lock mode for new tables.
#                      Acceptable values are ROW and PAGE (default).
###################################################################

LOCKS 20000	# 20091112
DEF_TABLE_LOCKMODE page 

###################################################################
# 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        -1               RTO_SERVER_RESTART
RESIDENT	0
SHMBASE 0x44000000L 
SHMVIRTSIZE 2097152
SHMADD 131072
EXTSHMADD 131072
SHMTOTAL 0
SHMVIRT_ALLOCSEG 0,3
SHMNOACCESS

###################################################################
# Checkpoint and System Block Configuration Parameters
###################################################################
# CKPINTVL           - Specifies how often, in seconds, IDS checks
#                      if a checkpoint is needed. 0 indicates that
#                      IDS does not check for checkpoints. Ignored 
#                      if RTO_SERVER_RESTART is set.
# AUTO_CKPTS         - Enables (1) or disables (0) monitoring of 
#                      critical resource to trigger checkpoints 
#                      more frequently if there is a chance that 
#                      transaction blocking might occur.
# RTO_SERVER_RESTART - Specifies, in seconds, the Recovery Time 
#                      Objective for IDS restart after a server 
#                      failure. Acceptable values are 0 (off) and
#                      any number from 60-1800, inclusive.
# BLOCKTIMEOUT       - Specifies the amount of time, in seconds,
#                      for a system block.
###################################################################

CKPTINTVL 150
AUTO_CKPTS 1
#RTO_SERVER_RESTART 60               #20091112
RTO_SERVER_RESTART 0

BLOCKTIMEOUT 3600

###################################################################
# Transaction-Related Configuration Parameters
###################################################################
# TXTIMEOUT        - The distributed transaction timeout, in seconds
# DEADLOCK_TIMEOUT - The maximum time, in seconds, to wait for a 
#                    lock in a distributed transaction.
# HETERO_COMMIT    - Enables (1) or disables (0) heterogeneous 
#                    commits for a distributed transaction
#                    involving an EGM gateway. 
###################################################################

TXTIMEOUT 600
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 64
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
#LTAPEDEV /var/backup/loglogs/
LTAPEBLK 64
LTAPESIZE 0

###################################################################
# Backup and Restore Configuration Parameters
###################################################################
# BAR_ACT_LOG         - The ON-Bar activity log file location.
#                       Do not use the /tmp directory. Use a 
#                       directory with restricted permissions.
# BAR_DEBUG_LOG       - The ON-Bar debug log file location.
#                       Do not use the /tmp directory. Use a 
#                       directory with restricted permissions.
# BAR_DEBUG           - The debug level for ON-Bar. Acceptable
#                       values are 0 (off) through 9 (high).
# BAR_MAX_BACKUP      - The number of backup threads used in a
#                       backup. Acceptable values are 0 (unlimited)
#                       or any positive integer.
# BAR_RETRY           - Specifies the number of time to retry a
#                       backup or restore operation before reporting 
#                       a failure
# BAR_NB_XPORT_COUNT  - Specifies the number of data buffers that
#                       each onbar_d process uses to communicate
#                       with the database server
# BAR_XFER_BUF_SIZE   - The size, in pages, of each data buffer.
#                       Acceptable values are 1 through 15 for 
#                       4 KB pages and 1 through 31 for 2 KB pages.
# RESTARTABLE_RESTORE - Enables ON-Bar to continue a backup after a
#                       failure. Acceptable values are OFF or ON.
# BAR_PROGRESS_FREQ   - Specifies, in minutes, how often progress
#                       messages are placed in the ON-Bar activity
#                       log. Acceptable values are: 0 (record only
#                       completion messages) or 5 and above.
# BAR_BSALIB_PATH     - The shared library for ON-Bar and the 
#                       storage manager. The default value is
#                       $INFORMIXDIR/lib/ibsad001 (with a 
#                       platform-specific file extension). 
# BACKUP_FILTER       - Specifies the pathname of a filter program 
#                       to transform data during a backup, plus any 
#                       program options
# RESTORE_FILTER      - Specifies the pathname of a filter program 
#                       to transform data during a restore, plus any 
#                       program options
# BAR_PERFORMANCE     - Specifies the type of performance statistics
#                       to report to the ON-Bar activity log for backup
#                       and restore operations.
#                       Acceptable values are:
#                        0 = Turn off performance monitoring (Default)
#                        1 = Display the time spent transferring data
#                            between the IDS instance and the storage
#                            manager
#                        2 = Display timestamps in microseconds
#                        3 = Display both timestamps and transfer
#                            statistics
###################################################################

BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
BAR_DEBUG_LOG $INFORMIXDIR/tmp/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 31
DD_HASHMAX  10

###################################################################
# Data Distribution Configuration Parameters
###################################################################
# DS_HASHSIZE  - The number of data Ddstribution pools.
#                Set to any positive integer; a prime number is 
#                recommended.
# DS_POOLSIZE  - The maximum number of entries in the data 
#                distribution cache. Set to any positive integer.
###################################################################

DS_HASHSIZE 31
DS_POOLSIZE 127

##################################################################
# User Defined Routine (UDR) Cache Configuration Parameters
##################################################################
# PC_HASHSIZE  - The number of UDR pools. Set to any
#                positive integer; a prime number is recommended.
# PC_POOLSIZE  - The maximum number of entries in the
#                UDR cache. Set to any positive integer.
###################################################################

PC_HASHSIZE 31
PC_POOLSIZE 127

###################################################################
# SQL Statement Cache Configuration Parameters
###################################################################
# STMT_CACHE         - Controls SQL statement caching. Acceptable
#                      values are: 
#                      0 Disabled
#                      1 Enabled at the session level
#                      2 All statements are cached
# STMT_CACHE_HITS    - The number of times an SQL statement must be
#                      executed before becoming fully cached.
#                      0 indicates that all statements are
#                      fully cached the first time.
# STMT_CACHE_SIZE    - The size, in KB, of the SQL statement cache
# STMT_CACHE_NOLIMIT - Controls additional memory consumption.
#                      Acceptable values are:
#                      0 Limit memory to STMT_CACHE_SIZE
#                      1 Obtain as much memory, temporarily, as needed
# STMT_CACHE_NUMPOOL - The number of pools for the SQL statement
#                      cache. Acceptable value is a positive
#                      integer between 1 and 256, inclusive.
###################################################################

STMT_CACHE 0
STMT_CACHE_HITS 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1

###################################################################
# Operating System Session-Related Configuration Parameters
###################################################################
# USEOSTIME        - The precision of SQL statement timing.
#                    Accepted values are 0 (precision to seconds)
#                    and 1 (precision to subseconds). Subsecond
#                    precision can degrade performance.
# STACKSIZE        - The size, in KB, for a session stack
# ALLOW_NEWLINE    - Controls whether embedded new line characters
#                    in string literals are allowed in SQL 
#                    statements. Acceptable values are 1 (allowed) 
#                    and any number other than 1 (not allowed).
# USELASTCOMMITTED - Controls the committed read isolation level.
#                    Acceptable values are:
#                    - NONE Waits on a lock 
#                    - DIRTY READ Uses the last committed value in 
#                      place of a dirty read 
#                    - COMMITTED READ Uses the last committed value 
#                      in place of a committed read  
#                    - ALL Uses the last committed value in place  
#                      of all isolation levels that support the last
#                      committed option 
###################################################################

USEOSTIME 0
STACKSIZE 64
ALLOW_NEWLINE 0
USELASTCOMMITTED NONE

###################################################################
# Index Related Configuration Parameters
###################################################################
# FILLFACTOR          - The percentage of index page fullness
# MAX_FILL_DATA_PAGES - Enables (1) or disables (0) filling data
#                       pages that have variable length rows as
#                       full as possible
# BTSCANNER           - Specifies the configuration settings for all
#                       btscanner threads. The format is:
#                       BTSCANNER num=<#>,threshold=<#>,rangesize=<#>,
#                       alice=(0-12),compression=[low|med|high|default]
# ONLIDX_MAXMEM       - The amount of memory, in KB, allocated for 
#                       the pre-image pool and updator log pool for 
#                       each partition.
###################################################################

FILLFACTOR 90
MAX_FILL_DATA_PAGES 0
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default
ONLIDX_MAXMEM 5120

###################################################################
# Parallel Database Query (PDQ) Configuration Parameters
###################################################################
# MAX_PDQPRIORITY     - The maximum amount of resources, as a
#                       percentage, that PDQ can allocate to any
#                       one decision support query
# DS_MAX_QUERIES      - The maximum number of concurrent decision
#                       support queries
# DS_TOTAL_MEMORY     - The maximum amount, in KB, of decision 
#                       support query memory
# DS_MAX_SCANS        - The maximum number of concurrent decision
#                       support scans
# DS_NONPDQ_QUERY_MEM - The amount of non-PDQ query memory, in KB.
#                       Acceptable values are 128 to 25% of
#                       DS_TOTAL_MEMORY.
# DATASKIP            - Specifies whether to skip dbspaces when
#                       processing a query. Acceptable values are:
#                       - ALL Skip all unavailable fragments
#                       - ON <dbspace1> <dbspace2>... Skip listed 
#                         dbspaces
#                       - OFF Do not skip dbspaces (default)
###################################################################

MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 128
DATASKIP

###################################################################
# Optimizer Configuration Parameters
###################################################################
# OPTCOMPIND     - Controls how the optimizer determines the best
#                  query path. Acceptable values are:
#                  0 Nested loop joins are preferred
#                  1 If isolation level is repeatable read,
#                    works the same as 0, otherwise works same as 2
#                  2 Optimizer decisions are based on cost only
# DIRECTIVES     - Specifies whether optimizer directives are
#                  enabled (1) or disabled (0). Default is 1.
# EXT_DIRECTIVES - Controls the use of external SQL directives.
#                  Acceptable values are:
#                  0 Disabled
#                  1 Enabled if the IFX_EXTDIRECTIVES environment
#                     variable is enabled
#                  2 Enabled even if the IFX_EXTDIRECTIVES 
#                     environment is not set
# OPT_GOAL       - Controls how the optimizer should optimize for
#                  fastest retrieval. Acceptable values are:
#                  -1 All rows in a query
#                  0 The first rows in a query
# IFX_FOLDVIEW   - Enables (1) or disables (0) folding views that  
#                  have multiple tables or a UNION ALL clause. 
#                  Disabled by default.
# AUTO_REPREPARE - Enables (1) or disables (0) automatically 
#                  re-optimizing stored procedures and re-preparing 
#                  prepared statements when tables that are referenced 
#                  by them change. Minimizes the occurrence of the 
#                  -710 error.
####################################################################

OPTCOMPIND 2
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL -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     16 # best for 8k pages
#RA_THRESHOLD 8  # best for 8k pages

RA_PAGES     32
RA_THRESHOLD 16 
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 0
SQLTRACE level=low,ntraces=1000,size=2,mode=user

###################################################################
# 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:
#                   <cipher_switch_time>,<key_switch_time>
#                   Default is 60,60.
###################################################################

ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH


###################################################################
# Enterprise Replication (ER) Configuration Parameters
###################################################################
# CDR_EVALTHREADS         - The number of evaluator threads per
#                           CPU VP and the number of additional 
#                           threads, separated by a comma. 
#                           Acceptable values are: a non-zero value
#                           followed by a non-negative value
# CDR_DSLOCKWAIT          - The number of seconds the Datasync
#                           waits for database locks.
# CDR_QUEUEMEM            - The maximum amount of memory, in KB,
#                           for the send and receive queues.
# CDR_NIFCOMPRESS         - Controls the network interface 
#                           compression level.
#                           Acceptable values are: 
#                           -1 Never 
#                           0 None
#                           1-9 Compression level
# CDR_SERIAL              - Specifies the incremental size and
#                           the starting value of replicated 
#                           serial columns. The format is:
#                           <delta>,<offset>
# CDR_DBSPACE             - The dbspace name for the syscdr
#                           database.
# CDR_QHDR_DBSPACE        - The name of the transaction record
#                           dbspace. Default is the root dbspace.
# CDR_QDATA_SBSPACE       - The names of sbspaces for spooled
#                           transaction data, separated by commas.
# CDR_MAX_DYNAMIC_LOGS    - The maximum number of dynamic log
#                           requests that ER can make within one
#                           server session. Acceptable values are:
#                           -1 (unlimited), 0 (disabled),
#                           1 through n (limit to n requests)
# CDR_SUPPRESS_ATSRISWARN - The Datasync error and warning code 
#                           numbers to be suppressed in ATS and RIS 
#                           files. Acceptable values are: numbers
#                           or ranges of numbers separated by commas.  
#                           Separate numbers in a range by a hyphen.
###################################################################

CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_MAX_DYNAMIC_LOGS 0
CDR_SUPPRESS_ATSRISWARN


###################################################################
# High Availability Cluster (HDR, SDS, and RSS) 
# Configuration Parameters
###################################################################
# DRAUTO            - Controls automatic failover of primary  
#                     servers. Valid for HDR, SDS, and RSS.
#                     Acceptable values are: 
#                     0 Manual
#                     1 Retain server type
#                     2 Reverse server type
#                     3 Connection Manager Arbitrator controls 
#                       server type                    
# DRINTERVAL        - The maximum interval, in seconds, between HDR
#                     buffer flushes. Valid for HDR only.
# DRTIMEOUT         - The time, in seconds, before a network
#                     timeout occurs. Valid for HDR only.
# DRLOSTFOUND       - The path of the HDR lost-and-found file.
#                     Valid of HDR only.
# DRIDXAUTO         - Enables (1) or disables (0) automatic index 
#                     repair for an HDR pair. Default is 0. 
# HA_ALIAS          - The server alias for a high-availability 
#                     cluster. Must be the same as a value of 
#                     DBSERVERNAME or DBSERVERALIASES that uses a  
#                     network-based connection type. Valid for HDR, 
#                     SDS, and RSS.
# LOG_INDEX_BUILDS  - Enable (1) or disable (0) index page logging.
#                     Required for RSS. Optional for HDR and SDS.
# SDS_ENABLE        - Enables (1) or disables (0) an SDS server.
#		      Set this value on an SDS server after setting 
#		      up the primary. Valid for SDS only.
# SDS_TIMEOUT       - The time, in seconds, that the primary waits  
# 		      for an acknowledgement from an SDS server  
#		      while performing page flushing before marking  
#                     the SDS server as down. Valid for SDS only.
# SDS_TEMPDBS       - The temporary dbspace used by an  SDS server.
#                     The format is:
#		      <dbspace_name>,<path>,<pagesize in KB>,<offset in KB>,
#                     <size in KB> 
#                     You can include up to 16 entries of SDS_TEMPDBS to 
#		      specify additional dbspaces. Valid for SDS.
# SDS_PAGING        - The paths of two buffer paging files, 
#                     Separated by a comma. Valid for SDS only.
# UPDATABLE_SECONDARY - Controls whether secondary servers can accept 
#                     update, insert, and delete operations from clients.
#                     If enabled, specifies the number of connection 
#                     threads between the secondary and primary servers 
#                     for transmitting updates from the secondary. 
#                     Acceptable values are: 
#                         0  Secondary server is read-only (default)
#                         1 through twice the number of CPU VPs, threads 
#                            for performing updates from the secondary.
#                     Valid for HDR, SDS, and RSS.
# FAILOVER_CALLBACK - Specifies the path and program name called when a 
#                     secondary server transitions to a standard or 
#                     primary server. Valid for HDR, SDS, and RSS.
# FAILOVER_TX_TIMEOUT - During failover, the maximum time in seconds,
#                     to wait for the failover node and surviving nodes
#                     to synchronize open transactions.
#                     0 means no rollback open transactions
# 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                  0
#DRINTERVAL              30
DRINTERVAL              -1 # synchronous mode
DRTIMEOUT               60
HA_ALIAS
DRLOSTFOUND             $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO               0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT             20
SDS_TEMPDBS
SDS_PAGING
UPDATABLE_SECONDARY     0
FAILOVER_CALLBACK
FAILOVER_TX_TIMEOUT     0
TEMPTAB_NOLOG           0
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  1
OFF_RECVRY_THREADS 10

###################################################################
# Diagnostic Dump Configuration Parameters
###################################################################
# DUMPDIR      - The location Assertion Failure (AF) diagnostic 
#                files
# DUMPSHMEM    - Controls shared memory dumps. Acceptable values 
#                are:
#                0 Disabled
#                1 Dump all shared memory
#                2 Exclude the buffer pool from the dump
# DUMPGCORE    - Enables (1) or disables (0) whether IDS dumps a 
#                core using gcore
# DUMPCORE     - Enables (1) or disables (0) whether IDS dumps a 
#                core after an AF
# DUMPCNT      - The maximum number of shared memory dumps or 
#                core files for a single session
###################################################################

DUMPDIR $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 - <time interval in seconds>,<alarm severity>
#                      specifies in what interval:
#                      - a message will be printed to the online.log file
#                      - an alarm will be raised
#                      when
#                      - a dbspace becomes full
#                        (ISAM error -131)
#                      - a partition runs out of pages or extents
#                        (ISAM error -136)
#                      time interval = 0 : OFF
#                      severity = 0 : no alarm, only message
# SYSALARMPROGRAM    - Specifies the system alarm program triggered
#                      when an AF occurs
###################################################################

ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3
SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh

###################################################################
# RAS Configuration Parameters
###################################################################
# RAS_PLOG_SPEED - Technical Support diagnostic parameter.
#                  Do not change; automatically updated.
# RAS_LLOG_SPEED - Technical Support diagnostic parameter.
#                  Do not change; automatically updated.
###################################################################

RAS_PLOG_SPEED  130827          
RAS_LLOG_SPEED  535             

###################################################################
# Character Processing Configuration Parameter
###################################################################
# EILSEQ_COMPAT_MODE - Controls whether when processing characters,  
#		       IDS checks if the characters are valid for  
#		       the locale and returns error -202 if they are 
#                      not. Acceptable values are:
#	               0 Return an error for characters that are not
# 		         valid (Default)
# 	               1 Allow characters that are not valid
####################################################################

EILSEQ_COMPAT_MODE  0

###################################################################
# Statistic Configuration Parameters
###################################################################
# QSTATS  - Enables (1) or disables (0) the collection of queue  
#           statistics that can be viewed with onstat -g qst 
# WSTATS  - Enables (1) or disables (0) the collection of wait  
#           statistics that can be viewed with onstat -g wst 
####################################################################

QSTATS 0
WSTATS 0
###################################################################
# Java Configuration Parameters
###################################################################
# VPCLASS jvp  - Configures the Java VP. The format is:
#                VPCLASS jvp,num=<#>[,max=<#>][,aff=<#>][,noage]
# JVPJAVAHOME  - The JRE root directory
# JVPHOME      - The Krakatoa installation directory
# JVPPROPFILE  - The Java VP property file
# JVPLOGFILE   - The Java VP log file
#                This parameter is deprecated and is no longer required
# JDKVERSION   - The version of JDK supported by this server
# JVPJAVALIB   - The location of the JRE libraries, relative
#                to JVPJAVAHOME
# JVPJAVAVM    - The JRE libraries to use for the Java VM
# JVPARGS      - Configures the Java VM. To display JNI calls,
#                use JVPARGS -verbose:jni. Separate options with
#                semicolons.
# JVPCLASSPATH - The Java classpath to use. Use krakatoa_g.jar
#                for debugging. Comment out the JVPCLASSPATH
#                entry you do not want to use.
###################################################################

#VPCLASS        jvp,num=1
JVPJAVAHOME     $INFORMIXDIR/extend/krakatoa/jre
JVPHOME         $INFORMIXDIR/extend/krakatoa
JVPPROPFILE     $INFORMIXDIR/extend/krakatoa/.jvpprops
JVPLOGFILE      $INFORMIXDIR/jvp.log
#JDKVERSION      1.5
JVPJAVALIB      /bin/j9vm 
JVPJAVAVM       jvm 
#JVPARGS        -verbose:jni
#JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar
JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar


###################################################################
# Buffer pool and LRU Configuration Parameters
###################################################################
# BUFFERPOOL      - Specifies the default values for buffers and LRU 
#                   queues in each buffer pool. Each page size used 
#                   by a dbspace has a buffer pool and needs a
#                   BUFFERPOOL entry. The onconfig.std file contains 
#                   two initial entries: a default entry from which 
#                   to base new page size entries on, and an entry 
#                   for the operating system default page size.                   
#                   When you add a dbspace with a different page size,
#                   IDS adds a BUFFERPOOL entry to the onconfig file 
#                   with values that are the same as the default 
#                   BUFFERPOOL entry, except that the default 
#                   keyword is replaced by size=Nk, where N is the
#                   new page size. With interval checkpoints, these 
#                   values can now be set higher than in previous 
#                   versions of IDS in an OLTP environment.
# AUTO_LRU_TUNING - Enables (1) or disables (0) automatic tuning of
#                   LRU queues. When this parameter is enabled, IDS 
#                   increases the LRU flushing if it cannot find low 
#                   priority buffers for number page faults.
###################################################################


# === 2k and 8k pages config ===
# 20G total = 8GB for 2k buffers + 12GB for 8k buffers

BUFFERPOOL	default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
BUFFERPOOL	size=2K,buffers=4000000,lrus=256,lru_min_dirty=0.100000,lru_max_dirty=0.300000
BUFFERPOOL	size=8K,buffers=1500000,lrus=256,lru_min_dirty=0.500000,lru_max_dirty=1.000000

AUTO_LRU_TUNING 0