INFORMIX 12.10 SYSTEM ADMINISTRATION
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.
Duration: 40-45hrs
Course Content:
Unit 1 - Overview of the Informix Database Server
Unit 2 - Preparing for configuration
Unit 3 - Configuring client-server connectivity
Unit 4 - Configuring a database server
Unit 5 - Monitoring the database server
Unit 6 - Managing shared memory
Unit 7 - Virtual processors and threads
Unit 8 - Disk architecture
Unit 9 - Managing and monitoring disk space
Unit 10 - Physical and logical logging
Unit 11 The shared memory buffer pool
Unit 12 Fault tolerance
Unit 13 Introduction to backup and restore
Unit 14 Backup and restore using ontape
Unit 15 Temporary files and tables
Unit 16 Performance features
Unit 17 Monitoring user activity
Unit 18 Event alarms
Unit 20 Troubleshooting
Unit 21 A configuration case study (optional)