About Trainer

  • 12 years of Informix experience
  • IBM Informix Certified
  • Working as Senior Informix DBA
  • Sound Technical skills

About IBM Informix DBA


Course Pre-requisites:

Lab setup: RHEL 32/64 bit

Training Material:

  • Class PPT’s (Soft Copy)
  • Class recordings (optional)


Introduction to Informix Dynamic Server (IDS) Terminology

  • Define basic Informix Dynamic Server terms
  • Query the sysmaster database for information about the server

IDS Installation & Setup

  • Identify the right product
  • Extract & Install the IDS product
  • Setup raw chunks for space
  • Setup Environment
  • ONCONFIG parameter changes
  • SQLHOSTS file changes
  • Instance creation
  • Bounce Informix Server Instance
  • Switching between server modes

Managing disk space

  • Physical Units
  • Logical Units

Shared memory

  • Resident portion
  • Virtual portion
  • Message portion

Monitoring Message log file
Managing configuration parameter file
SMI Tables

Monitor/Manage Database Server activity using tools

  • onstat
  • onmode
  • oncheck
  • onparams
  • onmonitor
  • oninit
  • ondblog
  • onspaces

Backing up data and logical log files (ontape, onbar)
Restore of data and logical log files using ontape & onbar

Data migration tools

  • load/unload
  • dbexport/dbimport
  • onunload/onload
  • dbschema

finder utility
Update statistics

Database Logging

  • Physical Logging
  • Logical Logging

Lock Management
Session Management
IDS Isolation Levels

IDS Data Types

  • Identify the Informix data types
  • Choose the appropriate data type for a data column

Creating Databases and Tables

  • Create databases and tables
  • Determine database logging and storage requirements
  • Locate where the database server stores a table on disk
  • Create temporary tables
  • Locate where the database server stores temporary tables
  • Use the system catalog tables to gather information
  • Use the dbschema utility

Altering and Deleting Databases and Tables

  • Drop a database
  • Drop a table
  • Alter a table
  • Convert a simple large object to a smart large object

Create, Alter, and Drop Indexes

  • Build an index
  • Alter, drop, and rename an index
  • Identify the four index characteristics

Managing and Maintaining Indexes

  • Explain the benefits of indexing
  • Evaluate the costs involved when indexing
  • Explain the maintenance necessary with indexes
  • Describe effective management of indexes
  • Enable or disable indexes

Table and Index Partitioning

  • List the ways to fragment a table
  • Create a fragmented table
  • Create a detached fragmented index
  • Describe temporary fragmented table and index usage

Maintaining Table and Index Partitioning

  • Alter a fragmented table
  • Alter a fragmented index
  • Explain how to skip inaccessible fragments

Data Security

  • Use the database, table, and column level privileges
  • Use the GRANT and REVOKE statements
  • Use role-based authorization


  • Create views
  • Use views to present derived and aggregate data
  • Use views to hide joins from users

Introduction to Stored Procedures

  • Explain the purpose of stored procedures
  • Explain advantages of using stored procedures


  • Create and execute a trigger
  • Drop a trigger
  • Use the system catalogs to access trigger information

Best practices (Scripts)

  • DBSPACE Size
  • Database, Table, Chunk sizes
  • Adding raw chunks
  • Script to find out Idle query sessions
  • Script to identify long transactions
  • Script to schedule update statistics
  • Temporary space usage
  • Script to find out current locks
  • Script to find out expensive queries
  • Script to find out chunk usage/IO
  • Script to list dbspace and chunks mapping
  • Script to display index usage
  • Day to day monitoring scripts such as Instance Availability, Space checks, etc



  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal