|
If you are knowledgeable with Informix Dynamic Server Version 7 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of Informix databases, you may benefit from this certification role. Section 1 - Components of Performance (6%)
Solve performance problems through investigation of performance components: CPU, disk and memory
Demonstrate an understanding of the affects each component has on performanceSection 2 - Measuring the Environment (16%)
Demonstrate an understanding of the UNIX and Informix Dynamic Server tools such as iostat, sar, time/timex, vmstat, ps, sa, onstat, oncheck, onperf, and SMI to measure performanceSection 3 - Disk Layout and Configuration (13%)
Determine optimal disk layout and configuration
Demonstrate an understanding of I/O priorities for both DSS and OLTP systemsSection 4 - Fragmentation Strategies (6%)
Demonstrate an understanding of implementing, optimizing, and monitoring fragmentationSection 5 - Tuning Informix Dynamic Server I/O (21%)
Demonstrate an understanding of I/O tuning factors and how these areas can be monitored and tuned for optimal performance (AIO vps, Checkpoints, LRU queues/parameters and Read-ahead parameters)Section 6 - Database Performance Strategies (16%)
Demonstrate an understanding of logging and the impact of logging on performance
Demonstrate an understanding of indexes and the impact indexes have on performance
Use UPDATE STATISTICS effectivelySection 7 - Processor and Operating Systems (6%)
Monitor and tun vp and CPU vp usage
Determine optimal vp configurationSection 8 - Memory Usage (6%)
Demonstrate an understanding of how memory is used
Determine optimal memory configurationSection 9 - Tuning Client/Server and Distributed Communication (3%)
Demonstrate an understanding of factors to improve communication performanceSection 10 - PDQ Administration (7%)
Monitor and tune configuration parameters and environment variables used by PDQ
Demonstrate an understanding of the Memory Grant Manager
|
