jvp,num=1$INFORMIXIDR/extend/krakatoa/jre/

$INFORMIXIDR/extend/krakatoa

$INFORMIXDIR/jvp.log1.5$INFORMIXDIR/extend/krakatoa/.jvpprops (platform-specific value)

(platform-specific value)-verbose:jni $INFORMIXDIR/extend/krakatoa /krakatoa_g.jar:$INFORMIXDIR/extend /krakatoa/jdbc_g.jar $INFORMIXDIR/extend/krakatoa /krakatoa.jar:$INFORMIXDIR/extend /krakatoa/jdbc.jar

#VPCLASS11

#JVPJAVAHOME11

#JVPHOME11

JVPLOGFILE11

#JDKVERSION11

JVPPROPFILE11

#JVPJAVALIB11

#JVPJAVAVM11

#JVPARGS11

#JVPCLASSPATH11

JVPCLASSPATH11

# Initial number of JVPs.# JDK installation rootdirectory.# Krakatoa installation directory.# JVP log file.

# JVP property file.# JRE libraries path fromJVPJAVAHOME.

# Set Java VM options.# Classpath to use at Java VM start-up.# Classpath to use a Java VM start-up.

Quick Reference:Configuration Parametersin the onconfig.std FileIBM® Informix®Version 11.70.xC1SC27-3806-00Default settings

OPTCOMPINDDIRECTIVESEXT_DIRECTIVES11

OPT_GOALIFX_FOLDVIEW10

AUTO_REPREPARE11

EXPLAIN_STAT11

# SQLTRACE11

210-1011

level=low,ntraces=1000,size=2,mode=global

# Always use cost as the query plan criterion.# Enable optimizer directives.# Disable external directives. # Optimize for all rows that the query returns.# No view folding in join or UNION ALL queries.# Automatically reoptimize after DDL.# Write query statistics to a file.

Optimizer Plans, Directives, and SQL Tracing

# DBCREATE_PERMISSION# DB_LIBRARY_PATH11

IFX_EXTEND_ROLE10

SECURITY_LOCALCONNECTION11

UNSECURE_ONSTAT11

ADMIN_MODE_USERS11

ADMIN_USER_MODE_WITH_DBSA11

SSL_KEYSTORE_LABEL11.5

Security

informix # If unset, no restrictions.# Shared objects.# Enables EXTEND role restrictions.# No security checking for local connections.# Can be set to relax onstat -g restrictions.# Can specify administration mode users.# Can allow administration mode connections for users.# Label of IBM Informix certificate in SSL protocol.

PLCY_HASHSIZE11

PLCY_POOLSIZE11

USRC_HASHSIZE11

USRC_POOLSIZE11

3112731127

# 31 buckets in security cache.# Up to 127 entries in each bucket.# 31 buckets in credential cache.# Up to 127 entries in each bucket.

Label-Based Access Control

Optical Storage Subsystem

STAGEBLOBOPCACHEMAX

# Set this to the OSS staging area name.# Disables OSS memory cache.

High Availability and Enterprise Replication Security

ENCRYPT_HDR11

ENCRYPY_SMX11

ENCRYPT_CDR11

ENCRYPT_CIPHERS11

ENCRYPT_MAC11

ENCRYPT_MACFILE11

ENCRYPT_SWITCH11

0

0

# Can enable HDR encryption.# Can set SDS and RSS encryption.# Disables ER encryption. # Ciphers and encryption modes.# Message authentication code (MAC).# Can list paths of MAC key files.# Can set key renegotiation frequency.

CDR_EVALTHREADS

CDR_DSLOCKWAIT

CDR_QUEUEMEMCDR_NIFCOMPRESSCDR_SERIALCDR_DBSPACE9

CDR_QHDR_DBSPACECDR_QDATA_SBSPACE9

CDR_LOG_LAG_ACTION11.7

CDR_LOG_STAGING_MAXSIZE11.7

# One evaluator and two other threads per CPU VP.# 5 second Datasync wait for database locks.# Up to 4096 KB queue memory.# No link level compression.# Allow duplicate serial keys. # The dbspace for syscdr database.# TX record headers location.# Sbspace list for TX row data.# Action when log processing lags.# Maximum size of log staging directory.

1,2

5

409600

ddrblock 0

Other Enterprise Replication Features

High Availability Clusters

DRAUTODRINTERVALDRTIMEOUTHA_ALIAS11.5

DRLOSTFOUND11

DRIDXAUTO11

LOG_INDEX_BUILDS11

SDS_ENABLE11

# Disables automatic switchover.# Flush HDR buffer every 30 seconds.# HDR network timeout is 30 seconds.# Server name (for HDR, SDS, and RSS).

# No automatic HDR index repair.# No index page logging.# Can enable (1) or disable (0) SDS server.

03030

$INFORMIXDIR/etc/dr.lostfound0

SDS_TIMEOUT11

SDS_TEMPDBS11

SDS_PAGING11

UPDATABLE_SECONDARY11.5

FAILOVER_CALLBACK11.5

TEMPTAB_NOLOG11

DELAY_APPLY11.5

STOP_APPLY11.5

LOG_STAGING_DIR11.5

LOG_STAGING_DIR11.7

ENABLE_SNAPSHOT_CLONE11.7

SMX_COMPRESS11.7

20

0

000

00

# Seconds to mark a secondary down. # List of up to 16 temporary SDS dbspaces.# 2 comma-separated buffer-paging file paths.# 2 comma-separated buffer-paging file paths.# Can set failover callback program.# Set to 1 to disable logging on temp tables.# Delay factor for RSS servers.# Halts the apply on an RSS server.# Directory to stage log files.# Log staging directory.# Prevents ability to clone the server.# Controls the network compression level.

Logical Recovery Threads

OFF_RECVRY_THREADSON_RECVRY_THREADS

101

# Ten threads for cold restore or fast recovery.# Warm restore worker thread.

Diagnostic Dump Features

DUMPDIR11

DUMPSHMEMDUMPGCOREDUMPCOREDUMPCNT

# Directory for AF diagnostics.# Dump a copy of all shared memory.# No dumping of a core image using gcore.# Prevents dumping of a core image.# Only one memory or core dump per session.

$INFORMIXDIR/tmp1001

Alarm Program Feature

ALARMPROGRAM11

ALRM_ALL_EVENTS10

STORAGE_FULL_ALARM11.5

SYSALARMPROGRAM11.5

RAS_PLOG_SPEEDRAS_LLOG_SPEED

00

00

QSTATSWSTATS

# Do not change; Auto updated.# Do not change; Auto updated.

# Disables queue statistics collection.# Disables wait statistics collection.

# Noteworthy events trigger ALARMPROGRAM.# Storage full alarms of severity 3 and higher can only be raised every 600 seconds.

$INFORMIXDIR/etc/alarmprogram.sh 0600,3

$INFORMIXDIR/etc/evidence.sh.

BUFFERPOOL11

BUFFERPOOL11

BUFFERPOOL11

BUFFERPOOL11

AUTO_LRU_TUNING11

# These two BUFFERPOOL settings are for 2 KB default page size:

# These BUFFERPOOL setting are for a 4 KB default page size:

default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50size=2k,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=60

default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50size=4k,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60

1 # LRUs are automatically tuned.

Technical Support Parameters

Queue and Wait Statistics

Java Configuration

Buffer-Pool Configuration and LRU Tuning

Scan

RA_PAGES11

RA_THRESHOLD11

BATCHEDREAD_TABLE 111.5

BATCHEDREAD_index11.7

641611

# Sequential scans, read 64 disk pages ahead.# Read next group when 16 pages remain.# Control light scans.# Control scans for indexes.

© Copyright IBM Corporation 2009, 2010

OFFUSERMAPPING11.7 # Controls access for users without operating system accounts.

User Mapping

SP_AUTOEXPAND11.7

SP_THRESHOLD11.7

SP_WAITTIME11.7

1030

# Automatically expands chunks.# Disables storage provisioning.# Storage pool wait time in seconds.

Storage Provisioning

\DEFAULTESCCHAR11.7 # Default escape character for LIKE and MATCHES.

Default Escape Character

#VPCLASS11.7

MQSERVER11.7

MQCHLLIB11.7

MQCHLTAB11.7

MQ,noyield # Configures MQ virtual processor.# Location of WebSphere® MQ server.# Directory of client channel definition table.# Name of client channel definition table.

MQ ConfigurationCDR_MAX_DYNAMIC_LOGS9

CDR_SUPPRESS_ATSRISWARN11

# No dynamic logs. # Datasync codes to suppress.

0

IBM, the IBM logo, and Informix are trademarks of IBM Corp., registered in many jurisdictions worldwide. Windows is a trademark of Microsoft Corporation in the United States, other countries, or both.

Send comments about this card or suggestions for additional quick reference topics to docinf@us.ibm.com, with "QRC" in the subject of the email.

Assess the usability and consumability of IBM® Informix® database servers by taking this survey:www.ibm.com/software/data/info/consumability-survey/

IBM Informix Configuration Parameters in the 11.70 onconfig.std File

Root Dbspace Configuration

ROOTNAMEROOTPATH11

ROOTOFFSETROOTSIZE11

rootdbs$INFORMIXDIR/tmp/demo_on.rootdbs # UNIX only.

0200000

# Path for device containing root dbspace.

# No default on Windows.# Offset into device of root dbspace (KB).# Size of root dbspace (KB).

Disk Mirroring Configuration

If settings are commented out in the file, you must delete the leading comment (#) symbol for that value to take effect. The values shown are defaults. For details of valid settings for most of these parameters, see the IBM Informix Administrator's Guide.

MIRRORMIRRORPATH11

MIRROROFFSET

0$INFORMIXDIR/tmp/demo_on.root_mirror # UNIX

0

# Disable mirroring.

# No default on Windows.# Offset into mirrored device (KB).

Physical Log Configuration

PHYSFILE11

PLOG_OVERFLOW_PATH11

PHYSBUFF11

50000$INFORMIXDIR/tmp128

# Maximum physical log file size (KB).

# Size of the 2 physical log buffers (KB).

Logical Log Configuration

LOGFILESLOGSIZE11

DYNAMIC_LOGSLOGBUFF11

610000264

# Number of logical log files.# Logical log size (KB).# Add logical log files dynamically.# Size of the logical log buffer (KB).

Long Transaction Rollback

LTXHWM

LTXEHWM

70

80

# Percentage of available log space filled that triggers a check for a long transaction.# Percentage of filled log space that gives a transaction in rollback exclusive access to the logical log.

Server Message File Configuration

CONSOLE11

MSGPATH11

$INFORMIXDIR/tmp/online.cononline.con$INFORMIXDIR/tmp/online.logonline.log

# Console message file (UNIX).# Console message file (Windows).# Message log file (UNIX).# Message log file (Windows).

Tblspace tblspace in Root Dbspace

TBLTBLFIRST10

TBLTBLNEXT10

TBLSPACE_STATS

001

# Automatically manage first extent size.# Automatically manage next extent size.# Maintain tblspace statistics.

Temporary and Permanent Dbspaces and Sbspaces

DBSPACETEMPSBSPACETEMP11

SBSPACENAMESYSSBSPACENAMEONDBSPACEDOWN 2

# Default temporary dbspace.# Default temporary sbspace. # Default sbspace for operations on smart large objects.# Sbspace for collecting system statistics.# If a primary chunk in a noncritical dbspace is disabled, IBM Informix logs its status and waits for user input.

Server Instance Identifiers

SERVERNUMDBSERVERNAMEDBSERVERALIASES9

FULL_DISK_INIT11.7

0

0

# Unique ID of the IBM Informix instance.# Name of the default database server.# List of alternate database server names.# Prevents initialization over an existing instance.

Network Configuration

NETTYPE11

LISTEN_TIMEOUT11

MAX_INCOMPLETE_CONNECTIONS11

FASTPOLL11

NS_CACHE11.7

ipcshm,1,50,CPU60 10241host=900,service=900,user=900,group=900

# For UNIX; No Windows default.# Seconds to wait for a client connection.

# Fast polling is enabled.# Name service cache expiration seconds.

CPU and Virtual Processors

MULTIPROCESSORVP_MEMORY_CACHE_KB10

SINGLE_CPU_VPVPCLASS11

000

# Single-processor.# No virtual-processor memory cache.# Multiple CPU virtual processors.# 1 CPU VP created.

AIO and Buffer Cleaners

#VPCLASS11

CLEANERS11

AUTO_AIOVPS11

DIRECT_IO11

aio,num=1810

# Suggested value; Uncomment to use.# Eight buffer cleaner processes.# Automatically add AIO VPs as needed.# Do not use direct I/O of cooked files (UNIX).

Locking and Read-Ahead

LOCKS11

DEF_TABLE_LOCKMODE1120000page

# Lock table initially has 20000 rows.# Use page-level locking granularity.

Shared Memory

RESIDENTSHMBASESHMVIRTSIZE11

SHMADDEXTSHMADD

SHMTOTAL

SHMVIRT_ALLOCSEG11

SHMNOACCESS11.5

0(platform dependent)32656

8192 8192

0

0,3

0x70000000-0x7FFFFFFF

# No forced residency.# Shared memory base address.# Initial virtual shared memory segment size (KB).# New shared memory segment size (KB).# New extension shared memory segment size (KB).# Total size of shared memory is not limited. # No automatic addition; alarm level = 3.# No inaccessible range (UNIX).# Inaccessible range (Windows).

Checkpoints and System Block

CKPTINTVLAUTO_CKPTS11

RTO_SERVER_RESTART11

BLOCKTIMEOUT

300103600

# Seconds between checks for long transactions.# Enables automatic checkpoints. # No recovery time objective.# Seconds allowed for a system block.

Distributed Transactions

TXTIMEOUTDEADLOCK_TIMEOUTHETERO_COMMIT

300600

# Participant recovery begins after 5-minute wait.# Seconds for distributed query to wait on locks.# No heterogeneous commit with Gateway.

Tape Device for Backups and for Logical Logs

TAPEDEV

TAPEBLK11

TAPESIZE11

LTAPEDEV11

LTAPEBLK9

LTAPESIZE9

/dev/tapedev\\.\TAPEO32160

# Tape device path (UNIX).# Tape device path (Windows).# Tape block size in KB (2 KB page size).# Tape block size in KB (4 KB page size).# No limit is specified for data capacity.

Backup and Restore

BAR_ACT_LOG11

BAR_DEBUG_LOG11

BAR_DEBUG11

BAR_MAX_BACKUPBAR_RETRYBAR_NB_XPORT_COUNTBAR_XFER_BUF_SIZE

RESTARTABLE_RESTOREBAR_PROGRESS_FREQBAR_BSALIB_PATH11

BACKUP_FILTER11

RESTORE_FILTER11

BAR_PERFORMANCE11

BAR_CKPTSEC_TIMEOUT11.7

$INFORMIXDIR/tmp/bar_act.log$INFORMIXDIR/tmp/bar_dbug.log

# Activity log file.# Debug file.

001203115ON0

015

# Display no debugging information. # Unlimited parallel threads for onbar commands.# Retry failed onbar commands only once.# Each onbar_d process has 20 buffers.# Transfer buffer size (2 KB page size).# Transfer buffer size (4 KB page size).# Enables restartable restore.# No messsages to onbar activity log.# No onbar and storage manager shared library path. # No path to a file containing an onbar backup filter. # No path to a file containing an onbar restore filter.# No performance statistics printed. # Seconds to wait for an archive checkpoint on a secondary server.

Informix Storage Manager

ISM_DATA_POOLISM_LOG_POOL

ISMDataISMLogs

# Volume pool for backing up storage spaces.# Volume pool for backing up logical logs.

Data Dictionary, Data Distribution, and UDR Caches

DD_HASHSIZE11

DD_HASHMAX11

DS_HASHSIZE11

DS_POOLSIZE11

PC_HASHSIZE11

PC_POOLSIZE11

PRELOAD_DLL_FILE11.7

31103112731127

# 31 hash buckets or lists in dictionary cache. # Up to 10 tables in each hash bucket.# 31 data distribution pools. # Up to 127 entries in data distribution cache.# 31 UDR pools.# Up to 127 entries in the UDR cache.# C UDR shared library path name.

SQL Statement Cache

STMT_CACHE11

STMT_CACHE_HITS11

STMT_CACHE_SIZE11

STMT_CACHE_NOLIMIT11

STMT_CACHE_NUMPOOL11

0051201

# Disables statement cache.# All statements are cached on first use.# Statement cache size (KB).# Limit is STMT_CACHE_SIZE.# One pool in statement cache.

Operating System and Session Features

USEOSTIMESTACKSIZEALLOW_NEWLINEUSELASTCOMMITTED11

EILSEQ_COMPAT_MODE

000NONE0

# Use DATETIME precision of 1 second.# Use the value from the routine modifier.# No newline characters in quoted strings.# Wait on locks in any isolation level.# Enables Error Message -202.

Index Features

FILLFACTORMAX_FILL_DATA_PAGES11

BTSCANNER11

ONLIDX_MAXMEM10

900num=1,threshold=5000,rangesize=-1,alice=6, compression=default5120

# Use 90% fill factor in building new indexes.# Partially fill variable-length row pages.

# Up to 5120 KB of memory per index.

Parallel Database Queries (PDQ)

MAX_PDQPRIORITYDS_MAX_QUERIESDS_TOTAL_MEMORY DS_MAX_SCANS

DS_NONPDQ_QUERY_MEM10

DATASKIP

100

1048576

128

# All resources are available for PDQ.# No maximum concurrent PDQ.# No decision support memory size. # Max concurrent decision-support scans.# 128 KB of non PDQ query memory.# List of dbspaces to skip is empty.

Superscripts indicate the last Informix release (version 9, 10, 11 (11.10), 11.5 (11.50), or 11.7 (11.70)) that the parameter value was updated in onconfig.std or the parameter was added to onconfig.std, whichever was more recent.

/dev/tapedevNUL 32160

# Tape device path (UNIX).# Tape device path (Windows).# Log tape block size in KB (2 KB page size).# Log tape block size in KB (4 KB page size).# No limit is specified for data capacity.

cpu,num=1,noage

Conversion Guard

CONVERSION_GUARD11.5

RESTORE_POINT_DIR11.5 1$INFORMIXDIR/tmp

# Control conversion guard errors.# Directory for conversion guard files.