HP Integrity Virtual Machines Online Migration with IBM Informix Dynamic Server 11.50
25
# 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
###################################################################
# Read-ahead 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
###################################################################
RA_PAGES 64
RA_THRESHOLD 16
###################################################################
# SQL Tracing and EXPLAIN Plan Configuration Parameters
###################################################################
# EXPLAIN_STAT - Enables (1) or disables (0) including the Query
# Statistics section in the EXPLAIN output file
# SQLTRACE - Configures SQL tracing. The format is:
# SQLTRACE level=(low|med|high),ntraces=<#>,size=<#>,
# mode=(global|user)
###################################################################
EXPLAIN_STAT 1
#SQLTRACE level=low,ntraces=1000,size=2,mode=global
###################################################################
# Security Configuration Parameters
###################################################################
# DBCREATE_PERMISSION - Specifies the users who can create
# databases (by default, any user can).
# Add a DBCREATE_PERMISSION entry