Informix Dynamic Server V15 Performance and Optimisation
A one day course for database administrators. This course looks at the features introduced in V15.
Course Objectives
This course is intended for IDS System Administrators who will be moving from version 7.x, 9.x, 10.x, 11.x0 or 12.10 of IDS to version 15.0 of IDS. The course covers the technical and administration details of the main new features that have been added in version 15.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
- 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.