Download Performance Guide for Informix Extended Parallel Server

SHMTOTAL .
SHMVIRTSIZE
STACKSIZE .
Chapter 5
Chapter 6
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
4-26
4-27
4-27
In This Chapter . . . . . . . . . . . . . . .
Chunk and Dbspace Configuration . . . . . . . .
Associate Disk Partitions with Chunks . . . . .
Associate Dbspaces with Chunks . . . . . . .
Management of Critical Data . . . . . . . . . .
Separate Disks for Critical Data . . . . . . . .
Mirroring for Critical Data . . . . . . . . .
Configuration Parameters That Affect Critical Data .
Dbspaces for Temporary Tables and Sort Files . . . .
DBSPACETEMP Configuration Parameter . . . .
DBSPACETEMP Environment Variable . . . . .
Temporary Space Estimates . . . . . . . . .
I/O for Tables and Indexes . . . . . . . . . . .
Sequential Scans . . . . . . . . . . . . .
Light Scans . . . . . . . . . . . . . . .
Light Appends . . . . . . . . . . . . .
Unavailable Data . . . . . . . . . . . . .
Configuration Parameters That Affect I/O for Tables
and Indexes . . . . . . . . . . .
Background I/O Activities . . . . . . . . . . .
Configuration Parameters That Affect Checkpoints .
Configuration Parameters That Affect Logging . .
Configuration Parameters That Affect Page Cleaning
Configuration Parameters That Affect Fast Recovery
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
5-3
5-3
5-4
5-5
5-5
5-6
5-7
5-9
5-10
5-12
5-13
5-14
5-14
5-15
5-15
5-17
5-17
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
5-18
5-21
5-22
5-26
5-27
5-28
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
6-3
6-4
6-5
6-5
6-6
6-7
6-7
6-9
6-10
Effect of Configuration on I/O
Table Performance
In This Chapter . . . . . . .
Choosing Table Types . . . .
Using STANDARD Tables. .
Using RAW Tables . . . .
Using STATIC Tables . . .
Using OPERATIONAL Tables
Using Temporary Tables . .
Specifying a Table Lock Mode
Monitoring Table Use . . .
vi
.
.
.
Performance Guide for Informix Extended Parallel Server
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.