Training Services

Informix Training

I have been involved in training Informix Database Adminstrators and Application Developers for over 30 years. 
All courses are taught by me as remote classes utilizing virtual conferencing.
Each attendee is provided with a private Informix server for labs and practice.

Basic Informix Database Administration

This course is for new or experienced database administrators, programmers, and technical support personnel who will be setting up and managing Informix version 15, 14, or 12 users. This is a four-day course covering the topics listed below.
​
Informix Server Configuration
  • Understanding the Informix Server architecture
  • Configuring and initializing Informix
  • Configuring disk space for databases
  • Configuring shared memory parameters
  • Configuring virtual CPUs
  • Configuring network and client/server connect
  • Changing Informix operating modes
  • Configuring multiple database servers
Informix Server Operations
  • Monitoring and operating Informix
  • Backing up Informix databases
  • Recovering Informix databases
  • Managing concurrence control
  • Managing transaction logs
  • Managing fault tolerance systems
  • Using the Informix utilities
  • Using the System Monitoring Interface (sysmaster)
  • Using data load utilities
Basic Informix Server Optimization
  • Analyzing Informix performance and system activity
  • Using the graphical monitoring tools
  • Understanding the query optimizer
  • Optimizing performance with indexes
  • Optimizing disk and database space layout
  • Managing memory and CPU resources
Database Development
  • Creating tables, indexes, and databases
  • Calculating table and database sizes
  • Implementing referential integrity
  • Controlling data security
  • Using the Informix system tables
​
The course includes several hand-on labs where attendees will practice the skills and become familiar with the operations covered.

Prerequisites
Requires a basic understanding of UNIX commands and SQL databases.

Advanced Informix Performance Tuning

This 4-day course is for experienced Informix database administrators and application developers who will be responsible for installing/upgrading, managing, optimizing, and tuning an Informix database server. The focus is on practical skills, procedures, and scripts to improve the performance of your database server. In addition to new skills, the course will provide a toolkit of scripts and utilities to start
monitoring and optimizing your Informix database server. This course has been updated for Informix version 15.0.

New Features in Informix Versions 14.10 and Version 15.0
  • New ONCONFIG Parameters
  • New Performance Tuning Guidelines
  • LARGE and SMALL tables
  • New ROWID in v15.0
  • ifx_row_id
  • Additional dbspace page sizes
Introduction to Performance Tuning and Optimizing
  • A Checklist for Troubling Shooting Informix Performance
Optimizing the Informix Server Configuration
  • Tuning OLTP Systems
  • Tuning Data Warehouse Systems
  • Tuning Data Loads
  • Managing and Tuning Client Server Database Access
Tuning Dbspaces, Chunks, and Disk Layouts
Informix Server Monitoring Utilities
  • Using the Onstat Utility for Performance Tuning
  • Using the Oncheck Utility for Performance Tuning
Managing Logs
  • Tuning the Physical Log
  • Tuning the Logical Log
Sizing Tables and Fragmentation
  • Tuning Table Fragmentation
  • Improve Performance Using Optimized Informix Data Types
  • Improve Performance Through Sizing Tables and Extent Planning
Using and Tuning Indexes
  • Tuning Index Builds
  • Reducing index root node contention
Managing and Tuning Update Statistics
Managing and Tuning Parallel Data Query
Optimization and Tuning SQL Statements
  • Using SET EXPLAIN to optimize and tune SQL
  • Tuning Sorts
Performance Optimization of Unix/Linux for Databases
Informix Server Monitoring Using the Sysmaster Database

The course includes several live labs where attendees are challenged to use their newly acquired skills.

Prerequisites
This is an advanced course and requires an  understanding of, and experience with, managing Informix. Proficiency in SQL and UNIX commands is required. Hands-on experience administering an Informix server is helpful. The following courses or equivalent are strongly recommended: Our Basic Informix Database Management or the equivalent course or hands-on experience.

Custom Training Courses

For private courses, any of the courses offered can be customized for the client's specific needs.

In addition, courses covering other topics can be custom developed given lead time and prepaid tuition. Suggested topics include but are not limited to:
  • Database design
  • Data modeling
    • Dimensional data modeling
    • Data modeling for transactional systems
  • Enterprise replication
  • Informix Replication Clusters
  • Data warehouse design and development
  • Informix 4GL
  • Informix SQL