Informix Dynamic Server V10 Performance and Optimisation

A one day course for database administrators. This course looks at the features introduced in IDS V10.

 

Course Objectives

On completion of this course the delegate will be able to:

This course is intended for IDS System Administrators who will be moving from version 7.x or 9.x of IDS to version 10.0 of IDS. The course covers the technical and administration details of the main new features that have been added in version 10.0 of Informix Dynamic Server.

Prerequisites

Informix Dynamic Server System Administration

Course Content

Configurable Page Size for Dbspaces and Bufferpools
Tuning Bufferpools
Tblspace Tblspace extent size configuration
Renaming Dbspaces
Creating Multiple Partitions of a Table or Index within a Dbspace
Creating and Dropping Indexes without Locking Tables
Onconfig Parameter changes
Single user mode
Allocating Memory for non-PDQ queries
External Optimizer Directives
Dynamic OPTCOMPIND SQL statement
Recovering Quickly with Fuzzy Checkpoints
Backup and Restore enhancements
Security enhancements