Download Performance Guide for Informix Extended Parallel Server

A
B
C
D
E
F
G
H
reducing sorting scope 13-34
rules for configuring space
for 5-10
TEXT data type
estimating size 6-16
used in columns 6-43
Thrashing, definition of 1-29
Threads
consumers, definition of 11-6
DEFUNCT status of 12-45
monitoring for session 12-35
monitoring with onstat 12-43
number for each CPU VP 3-8
producers, definition of 11-6
Throughput
benchmarks 1-18
contrasted with response
time 1-22
definition of 1-18
measured by logged COMMIT
WORK statements 1-19
measuring with onstat
-p 1-19
Time
getting current 1-24
getting user, system, and
elapsed 1-24
Timing
commands 1-23
functions 1-24
performance monitor 1-24
Tip icons Intro-9
TO CLUSTER clause 6-27
TPC-A, TPC-B, TPC-C, and TPC-D
benchmarks 1-18
Transaction Processing
Performance Council
(TPC) 1-18
Transactions
configuration parameters that
affect rollback 5-27
financial cost 1-25
per second, per minute 1-18
See also OLTP.
14
I
J
K
L
M
N
O
P
Q
R
Trigger
restriction for table with globally
detached index 7-15
restrictions for OPERATIONAL
table 6-4
TRUNCATE TABLE statement, to
remove all rows from a
table 13-30
U
Uncorrelated subquery, definition
of 11-26
UNIX
file descriptor requirement 3-6
NOFILE, NOFILES, NFILE, or
NFILES configuration
parameter 3-6
SEMMNI configuration
parameter 3-4
SEMMNS configuration
parameter 3-5
SEMMSL configuration
parameter 3-4
SHMSEG configuration
parameter 4-9
UNIX commands
iostat 2-6
ps 2-6
sar 2-6
time 1-23
vmstat 2-6
UNIX monitor, 3dmon 2-6
UNLOAD statement 6-26
Update cursors, locks in 8-12
UPDATE statement, dummy to
force table conversion 6-36
UPDATE STATISTICS statement
effect on memory
requirements 4-6
HIGH mode
for indexed columns 13-11
for join columns 13-12
importance for balancing
workload 11-14
improving query
performance 13-8
Performance Guide for Informix Extended Parallel Server
S
T
U
V
W
X
Y
Z
@
LOW mode 13-11
LOW mode, when to run 13-9
MEDIUM mode, when to
run 13-11
on join columns 13-12
parallel execution 11-24
purpose of 10-21
RESOLUTION clause in 13-10
setting BUFFERS to improve
performance 4-13
sort memory 11-24
USEOSTIME configuration
parameter, performance
issues 5-25
Users, types of Intro-3
Utilities
dbschema 9-14, 9-32, 13-10
onlog 1-19, 2-9
onmode
and forced residency 4-24
-F option to free memory 4-9
-M, -Q, -D, and -S options 12-17
-p option to add AIO VPs 3-13
-p option to add FIF VPs 3-13
-p option to start VPs 3-17
onstat
description of 2-7
-g ioq option to monitor I/O
queues 3-13
-g mem option to display
memory statistics 4-7
-g rgm option 12-16
-g seg option for memory
segments 4-25
-g xqp option 12-39
-m option 5-23
onutil
and index size 7-8
CHECK INDEX option 7-21
CHECK SPACE option 6-25
DISPLAY TABLE option 6-15
monitoring chunks and
extents 2-13
xctl. See xctl utility.
See also individual utilities.