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

ManualsBrandsHP ManualsSoftwareHP Integrity Virtual Machines and Online VM Migration Software

# 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.