반응형
INFORMIX SelfStudy Guide ServerAdmin - 한글 매뉴얼 입니다.
1. Informix Architecture
The Informix Database Server
System Architecture Overview
Process Component
Shared Memory Component
Disk Component
2. Server Configuration
Environment Variables
Disk Parameters
Shared Memory Parameters
Performance Tuning Parameters
Additional Parameters
How the Client Connects
Options in the sqlhosts file
3. Server Operation
Operating Modes
Shared Memory Buffer Access
Checkpoints
Buffer Writes
Fast Recovery
Step to Fast Recovery Process
Media Failures
4. Disk Management
Disk Space for a Table
Chunk Layout
Space Management
Physical Log / Logical Log
Log Management
5. Performance Optimization
Temporary Objects
Parallel Sort / Parallel Index build
Query Optimum Performance
Parallel Database Query
PDQ Administration
Memory Grant Manager
onstat –g mgm
SQL Statement Cache
6. Server Monitoring
Monitoring Utilities
Tables in the sysmaster Database
onstat Options
onstat Multi-thread Options
oncheck Options
Monitor the Message Log
Monitor Shared Memory Segments
Monitoring Logical Log Space / Chunk Usage
Monitoring User Activity
Identifying Server Resources
Monitoring Lock Usage
7. Backup & Restore
Backup
Logical Log Backup
Restore
ontape Utility
ontape Example
onbar Utility
INFORMIX_SelfStudy_Guide_ServerAdmin.pdf