Informix Dynamic Server V14 Performance and Optimisation

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

Course Objectives

This course is intended for IDS System Administrators who will be moving from version 7.x or, 9.x, 10.x, 11.x0 or 12.10 of IDS to version 14.10 of IDS. The course covers the technical and administration details of the main new features that have been added in version 14.10 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
• Renaming and/or moving Chunks
• 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
• Taking advantage of Configurable Recovery Time
• New autonomic tuning parameters
• Backup and Restore enhancements
• Security enhancements
• Dynamic SQL Basics
• Configuring and Maintaining MACH11 Servers
• Taking advantage of Writable Secondary Servers
• Configuring IDS Connection Manager
• Advanced BTree Scanner Tuning
• Flexible Grid
• Automatic Storage
• Encryption at Rest
• Wire Listeners

Quotes from previous delegates

One of the best courses I have attended. It was relaxed and informative with help being at hand all the time - very useful.....

excellent course, excellent food! looking forward to coming again.....

Very relaxed, steady pace - easy to pick up and follow. Very helpful with any problem areas......

If you would prefer a personalised course then please contact us to discuss your requirements. Oninit ® will then provide a proposal to ensure that your staff receive the training they need to optimise their performance and your system