Length– 32 hours
Overview
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.
Prerequisites
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
Audience
This course is designed for Informix System Administrators, Informix Database Administrators, and Informix Applications Developers.
Course Outline.
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.
Disk architecture.
Managing and monitoring disk space.
Physical and logical logging.
The shared memory buffer pool.
Fault tolerance.
Introduction to backup and restore.
Backup and restore using ontape.
Temporary files and tables.
Performance features.
Monitoring user activity.
Event alarms.
SQL administrative functions and task scheduler.
Troubleshooting.
A configuration case study (optional).