HP Integrity Virtual Machines Online Migration with IBM Informix Dynamic Server 11.50

23
# 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 96
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