Informix 12.10 System Administration IX813G

4 days


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.


This course is designed for Informix System Administrators, Informix Database Administrators, and Informix Applications Developers.


  • Students in this course should satisfy the following prerequisites:

Course Outline

  • Preface
  • 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 19 SQL administrative functions and task scheduler
  • Unit 20 Troubleshooting
  • Unit 21 A configuration case study (optional)
  • Appendix A Installing Informix on Linux / UNIX

Related Courses


Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London4 3000 £3000 2019-12-09