|
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
|
