Enterprise Edition Home | Express Edition Home | Previous Page | Next Page  

Effect of Configuration on I/O Activity

In This Chapter
Chunk and Dbspace Configuration
Associate Disk Partitions with Chunks
Associate Dbspaces with Chunks
Place System Catalog Tables with Database Tables
Placement of Critical Data
Consider Separate Disks for Critical Data Components
Consider Mirroring for Critical Data Components
Mirroring the Root Dbspace
Mirroring Smart-Large-Object Chunks
Mirroring the Logical Log
Mirroring the Physical Log
Configuration Parameters That Affect Critical Data
Configuring Dbspaces for Temporary Tables and Sort Files
Creating Temporary Dbspaces
DBSPACETEMP Configuration Parameter
DBSPACETEMP Environment Variable
Estimating Temporary Space
PSORT_NPROCS Environment Variable
Configuring Sbspaces for Temporary Smart Large Objects
Creating Temporary Sbspaces
SBSPACETEMP Configuration Parameter
Placement of Simple Large Objects
Advantage of Blobspaces over Dbspaces
Blobpage Size Considerations
Optimizing Blobspace Blobpage Size
Obtaining Blobspace Storage Statistics
Determining Blobpage Fullness with oncheck -pB
Parameters That Affect I/O for Smart Large Objects (IDS)
Disk Layout for Sbspaces
Configuration Parameters That Affect Sbspace I/O
SBSPACENAME
BUFFERPOOL
LOGBUFF
onspaces Options That Affect Sbspace I/O
Sbspace Extent Sizes
Lightweight I/O for Smart Large Objects
Logging
How the Optical Subsystem Affects Performance
Environment Variables and Configuration Parameters for the Optical Subsystem
STAGEBLOB
OPCACHEMAX
INFORMIXOPCACHE
Table I/O
Sequential Scans
Light Scans
Unavailable Data
Configuration Parameters That Affect Table I/O
RA_PAGES and RA_THRESHOLD
DATASKIP
Background I/O Activities
Configuration Parameters That Affect Checkpoints
CKPTINTVL
LOGSIZE and LOGFILES
PHYSFILE
ONDBSPDOWN
Configuration Parameters That Affect Logging
LOGBUFF and PHYSBUFF
LOGFILES
LOGSIZE
DYNAMIC_LOGS
LTXHWM and LTXEHWM
Configuration Parameters That Affect Page Cleaning
CLEANERS
BUFFERPOOL
Configuration Parameters That Affect Backup and Restore
ON-Bar Configuration Parameters
ontape Configuration Parameters (UNIX)
Configuration Parameters That Affect Rollback and Recovery
OFF_RECVRY_THREADS and ON_RECVRY_THREADS
PLOG_OVERFLOW_PATH
FAST_RESTART_PHYSLOG and FAST_RESTART_CKPT_FUZZYLOG
Configuration Parameters That Affect Data Replication and Auditing
Data Replication
Auditing
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]