#L2-403

IBM Informix Dynamic Server Performance Tuning

Course Description

For experienced IBMInformix Dynamic Server database and system administrators. Learn practical information on how to improve performance in your IBM Informix Dynamic Server and UNIX environment. Learn how to monitor and analyze system activity. Learn how to create data distributions to provide better statistics to the optimizer. Learn how to optimize fragmentation strategies and apply guidelines. Learn how to optimize and manage resources in the parallel data query (PDQ) environment. Data loading and indexing are also addressed.

Your New Skills

• Use IBMInformix Dynamic Server monitoring utilities
• Identify optimal fragmentation strategies
• Identify strategies for improving data loads and indexing
• Manage memory and CPU system resources
• Tune OLTP environment
• Tune checkpoints

Who Should Attend: Database and system administrators, technical support personnel

College Credit: This course has been recommended for college credit by the American Council on Education.

Prerequisites

• Experience using Informix Dynamic Server
• FN-848 Managing and Optimizing IBMInformix Dynamic Server Databases
• L1-846 IBM Informix Dynamic Server System Administration or equivalent knowledge

Length: 4 days

Format: Lecture and hands-on exercises

Course Number: L2-403