IBM Informix System Administration

IBM INFORMIX SYSTEM ADMINISTRATION 

Course Description
Students will learn how to configure and initialize 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.

Agenda
Describe the components of a database server.
Configure and initialize a database server
Configure the server to allow both local and remote connections
Use Informix utilities to monitor server activity
Describe the components of shared memory and configure the component sizes
List, describe, and configure the different classes of virtual processors
Identify the components of the database server disk architecture
Create dbspaces, blobspaces, and sbspaces and add chunks to these spaces
Explain the purpose of physical and logical logs and monitor log activity
View the individual transactions that are written to the logical log files
Describe the importance of checkpoints on the server
Describe the importance of fast recovery
Perform backups of the database server and logical logs
Use different methods to restore a database server from backup
Explain the purpose of temporary spaces used by the server
Configure the database server to operate more efficiently using parallel operations
Monitor the resources used by individual user sessions
Configure the server to respond to specific events by executing an alarm program
Use various troubleshooting techniques to identify and resolve common problems

Day 1

• Overview of the Informix Database Server
• Preparing for Configuration
• Configuring Client-Server Connectivity
• Configuring a Database Server
• Monitoring Dynamic Server

Day 2

• Managing Shared Memory
• Virtual Processors and Threads
• Disk Architecture
• Managing and Monitoring Disk Space
• Physical and Logical Logging

Day 3

• The Shared Memory Buffer Pool
• Fault Tolerance
• Introduction to Backup and Restore
• Backup and Restore Using Ontape
• Temporary Files and Tables
• Performance Features

Day 4

• Monitoring User Activity
• Event Alarms
• SQL Admin Functions and Task Scheduler Troubleshooting
• A Configuration Case

Audience
This intermediate course is for Informix Administrators, Database Administrators, and Applications Developers.