Informix Dynamic Server Administration

A four day course for system administrators and technical support personnel who are responsible for managing, maintaining or troubleshooting the database server.

Course Objectives

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

• Install and configure a database server
• Perform day to day management tasks
• Troubleshoot and tune a database server
• Maintain the efficiency and integrity of the server

Prerequisites

Familiarity with Informix-SQL and UNIX.

Course Content

• What is Informix Dynamic Server?
• Major Functionality and Concepts
• Configuring IDS
• Environment variables
• Configuring connectivity
• Description of the configuration parameters
• Initialising a new server
• Changing operating modes
• Starting and stopping a server
• Stopping individual sessions
• Disk management and organisation
• Creating dbspaces
• Managing blobspaces
• Implementing mirroring
• Adding chunks
• Obtaining information about the chunks, dbspaces and database tables
• Checking the integrity of the data on disk
• Managing the transaction log
• Backing up the logs using ontape
• Archiving and restoring the server using ontape
• Verifying the integrity of an ontape archive tape
• Comparison with onbar
• Shared memory architecture
• Data caching
• Fast recovery
• LRU queues
• Monitoring the server for resource inadequacies and user problems
• Procedure for trouble shooting
• Performance Tuning
• Major factors that influence performance
• Using onlog, onload, onunload and the alarm program

Quotes from previous delegates

This is the best technical course I have been on ... answered a lot of questions I have had for a long time ... thanks for clarifying so much.....

Excellent course, very well structured, presented by a dynamic lecturer who obviously knows his subject. The information was presented in an interesting and comprehensive manner.....

Excellent course in both content and presentation. Practical exercises very useful and welcome as a consolidation of the theory.....

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