#L1-846

IBM Informix Dynamic Server 9.X System Administration

Course Description

This course is intended for IBM Informix Dynamic Server and Informix Dynamic Server system administrators. Learn the skills necessary to successfully administer one or more database servers. Learn how to configure and intialize 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 OLTP or decision support.

Your New Skills

Describe the IBM Informix Dynamic Server multi-threaded architecture
Configure an IBM Informix Dynamic Server database server
Set up a multiple residency environment
Plan and configure disk and memory usage
Enable and configure disk mirroring
Describe basic IBM Informix Dynamic Server recovery and fault tolerance mechanisms
Configure and manage logical logs
Manage and optimize index builds and query sort space
Manage temporary tables and files
Monitor IBM Informix Dynamic Server activity
Manage data access by concurrent users
Allocate memory for decision support queries
Use the ontape utility to back up and restore data
Use IBM Informix Server Administrator to manage database servers

Who Should Attend: Application developers, database and system administrators, technical support personnel

Prerequisites

Knowledge of UNIX administration
FN-613 Structured Query Language or equivalent knowledge

Length: 4 days (24 hours)

Format: Lecture and hands-on exercises

Course Number: L1-846

Recommended Next Course