Length– 32 hours
In this course, students will develop the skills necessary to administer one or more Informix database servers. They will learn how to configure and utilize a database server instance, configure and test client connectivity, configure and manage memory and disk usage, plan and implement system maintenance tasks, and configure the server for optimal Online Transaction Processing (OLTP) or decision support (DS) utilization.
Students in this course should satisfy the following prerequisites:
Knowledge of Structured Query Language (SQL)
Knowledge of dbaccess
Experience using basic Linux functionality
Experience using the vi editor
This course is designed for Informix System Administrators, Informix Database Administrators, and Informix Applications Developers.
Overview of the Informix Database Server.
Preparing for configuration.
Configuring client-server connectivity.
Configuring a database server.
Monitoring the database server.
Managing shared memory.
Virtual processors and threads.
Managing and monitoring disk space.
Physical and logical logging.
The shared memory buffer pool.
Introduction to backup and restore.
Backup and restore using ontape.
Temporary files and tables.
Monitoring user activity.
SQL administrative functions and task scheduler.
A configuration case study (optional).