|
This course is for IDS database administrators and application
developers who will be responsible for installing, managing, optimizing,
and tuning an IDS database server. The focus is on practical skills,
procedures, and scripts to improve the performance of your database
server. In addition to your new skills, the course will provide
a toolkit of scripts and utilities to start monitoring and optimizing
your IDS database server. This course covers IDS 10.X and 9.X.
Course Outline:
- Introduction to Performance Tuning and Optimizing
- Optimizing the IDS Server Configuration
- IDS Server Monitoring Utilities
- IDS Server Monitoring Using the Sysmaster Database
- Tuning Dbspaces, Chunks and Disk Layouts
- Tuning Data Loads
- Tuning Index Builds
- Tuning Table Fragmentation
- Tuning OLTP Systems
- Tuning Data Warehouse Systems
- Managing and Tuning Update Statistics
- Managing and Tuning Parallel Data Query
- Managing and Tuning Client-Server Database Access
- Managing and Tuning Database Server Backups and Restores
- A Checklist for Troubling-shooting IDS Performance
- Improve Performance Using Optimized IDS Data Types
- Improve Performance Using Indexing Strategy
- Improve Application Performance Through the use of SET EXPLAIN
ON
- Improve Performance Through Sizing Tables and Extent Planning
- Optimization and Tuning SQL Statements
- Performance Optimization of Unix for Databases
Prerequisites:
This is an advanced course and requires an understanding of and
experience with administering Informix IDS. Proficiency in SQL,
UNIX commands, and the vi editor is required. The following two
courses or equivalent are strongly recommended: 1) IBM Informix
Dynamic Server Administration Course (L1-846); 2) Managing and Optimizing
IBM Informix Dynamic Server Databases (FN-848).
|
