@

10 IBM Informix OnLine Database Server Administrator’s Guide

OQCABDEFGHIJKLMNPRSTUVWXYZ
MSGPATH parameter
changes for multiple
residency 9-13
description of 1-16
initial configuration value 1-28
Multiple residency
benefits of 9-7
configuration and setup 9-11
description of 9-7, 9-10
Multiprocessor features
Psort sorting package 5-22
SPINCNT parameter 1-40
spin-countlatch acquisition 2-42,
5-24
tuning for performance 5-4
O
Offline mode
description of 3-7
Online archive
description of 3-44
works by synchronizing
activity 4-33
Online files
provided with the
product Intro-18
Online mode
description of 3-7
Operating OnLine
consistency-checking code 4-6
logging overview 4-18
things to avoid 3-116
ovbuff field, performance
tuning 5-11
ovlock field, performance
tuning 5-11
ovtbls field, performance
tuning 5-11
ovuser field, performance
tuning 5-11
P
Page
bit-map page 2-148
blobspace blobpage 2-148
blobspace blobpage
structure 2-149
blobspace free-map page 2-148
components of dbspace
page 2-120
compression 2-133
dbspace blob page 2-146
dbspace page types 2-115
definition of full page 2-126
description of 2-82
free page, definition of 2-115
fullness 4-bit bit values 2-144
fullness bit values 2-144
header components 2-121
index page structure 2-133
logical page number 2-124
physical page number 2-124
Page compression 2-122, 2-124,
2-133
Page-cleaner process
changing number of 3-115
codes for activity state 7-88
description of 2-34
efficiency trade-offs 5-18
flushing buffer pool 2-73
monitoring activity 7-87
shared-memory table 2-52
snooze time 2-75, 7-87
tuning parameters for
performance 5-17
write types 2-75
PAGE_ARCH reserved page 2-102
PAGE_CKPT reserved page 2-97
PAGE_CONFIG reserved
page 2-97
PAGE_DBSP reserved page 2-99
PAGE_MCHUNK reserved
page 2-101
PAGE_PCHUNK reserved
page 2-100
PAGE_PZERO reserved page 2-97
Participant database server
automatic recovery 9-26
description of 9-18
Partnum field in systables 2-105
PATH environment variable 1-57
Performance tuning
blobspace blobpage size 5-5
checkpoint frequency 5-20
description of 5-3
log buffer sizes 5-15
page-cleaner parameters 5-17
parallel-process sorting 5-22
shared-memory buffers 5-13
shared-memory resources 5-14
specifying sorting directory 5-4
spin-count latch acquisition 5-24
user guidelines 5-8
when needed 5-10
PHYSBUFF parameter
changing 3-93
description of 1-16
initial configuration value 1-35
PHYSDBS parameter
changing 3-107
description of 1-16
initial configuration value 1-25
PHYSFILE parameter
changing 3-107
description of 1-16
initial configuration value 1-25
Physical consistency
description of 4-39
Physical log
before-image contents 2-152
changing size or location 3-107
configuration guidelines 1-25
description of 1-25, 2-86
disk location 1-46
emptied by a checkpoint 2-153
monitoring 3-81
role in fast recovery 4-40, 4-41
scenario that could fill the
log 2-153
structure and function 2-152
Physical log buffer
changing size 3-93
description of 2-63
double buffering 2-64
flushing 2-64
flushing synchronized during
archive 4-34
if it becomes full 2-65
role in dbspace logging 4-21
synchronizing buffer
flushing 2-74
tuningsize for performance 5-11,
5-15