This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | IX401 | Skill level | Advanced |
|---|---|---|---|
| Duration | 4.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $2,600.00 plus tax | ||
In this course, students will learn the fundamentals of tuning an Informix Dynamic Server instance for optimal performance. The course covers topics related to hardware issues and tuning for optimizing data loads, index builds, UPDATE STATISTICS processes, and OLTP and DSS queries.
A multiprocessor UNIX machine with multiple disk drives will be provided so that students can perform benchmarking exercises to test the tuning skills they have learned.
View this course in other countries
Training Paths that reference this course are:
Audience
This is an advanced course for experienced Informix Dynamic Server system administrators and database administrators.
Prerequisites
Skills taught
- Describe the performance tuning process
- Use IDS and UNIX/Linux utilities to aid in performance tuning
- Optimize performance for data loads
- Apply techniques to optimize index design and index build performance
- Optimize collection of the data statistics used by the optimizer in generating the SQL query plan
- Tune a database for optimum performance of OnLine Transaction Processing (OLTP) workloads
- Plan and implement fragmentation strategies to best meet workload requirements
- Optimize parallel queries by tuning Parallel Data Query (PDQ) parameters
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
