In this course, you will use your experience with other relational database management systems as a basis for learning how to administer the Informix database server. You will learn the terminologies used to describe Informix database server objects and processes. You will learn how to configure and start an Informix database server instance, and perform tasks related to the monitoring and maintenance of the instance. You will also learn the terminology and tasks required to design and maintain Informix databases and queries.

• Configure and initialize an Informix database instance
• Add and remove spaces and chunks
• Manage the operating mode of the database server
• Monitor server activity
• Create and alter database objects
• Explain locking granularity
• Explain Informix isolation levels
• Use SET EXPLAIN to obtain a query plan
• Use UPDATE STATISTICS to better define data distribution
• Create simple stored procedures and triggers

This intermediate course is for database and system administrators.

You should have:

• Experience with administration of other relational database management systems.
• Experience with UNIX/Linux operating systems

Please refer to Course Overview for description information.

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.
GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process: http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf
Once you enroll in a GTP class, you will receive a confirmation letter that should show:
    The current GTP list price
    The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.