IBM Informix

IBM Informix

4-Day Exam Prep Course

Welcome to a comprehensive 4-day course on IBM Informix. This course is designed to guide both new and experienced database administrators through the basics and best practices of Informix.

Learning Outcomes:

• Gain a fundamental understanding of the Informix database server.
• Learn how to configure, monitor, and manage Informix servers.
• Understand advanced best practices for Informix DBAs.
• Develop an ability to optimize performance, manage security, and ensure high availability for Informix servers.
• Get insights into the new Informix Version 14 and Informix HQ.

Prerequisites:

• Basic knowledge of relational database management systems.
• Familiarity with Unix/Linux operating systems is beneficial.

Exam Details:

Purchase link: https://www.iiug.org/event/informix-14-10-badge-exam-purchase/

Contact: Cindy Lichtenauer <cindy@iiug.org>
Link Valid till: 31st December, 2023
Badge Exam Price: USD 150.00

Detailed Course Outline:

Day 1: Introduction to Informix Database Servers

1. Informix Tutorials – Getting Started with Informix

• Introduction to Informix
• Installing Informix Server
• Introduction to InformixHQ and IBM Informix Knowledge Center
• Resources for getting started

2. Configuring a New Informix Server

• Overview of Informix ONCONFIG file
• Configuring memory, CPUs, network, and disk for Informix servers

3. Managing Informix Disk Space

• Setting up and configuring disk space
• Best practices for disk and RAID configurations

4. Managing Informix Logs

• Overview of Informix physical and logical logs
• Best practices for managing logs
• Backup and recovery of logical logs

Day 2: Advanced Configurations and User Connectivity

5. Informix Backup, Recovery, and High Availability (HDR)

• Overview of Informix backup and recovery
• Setting up and managing HDR
• Switching between Primary and Secondary servers

6. Connecting Users and Tools to Informix Servers

• Connection methodologies for different platforms
• Using Microsoft ODBC, Informix SDK, Java, PHP, DRDA, and more

7. Creating Databases, Tables, and Managing Security

• Best practices for creating databases and tables
• Object-oriented data types and using SQL scripts
• Managing Informix database security

8. Informix Database Server Monitoring

• Command-line utilities: onstat, oncheck, and InformixHQ

Day 3: Advanced Best Practices for Informix DBAs (Part 1)

9. Informix Database Indexes

• Best practices for Informix indexing
• Optimizing database performance using indexes

10. Informix SQL Explain – Using the SQL Optimizer Query Explain Plan

• Viewing and understanding the SQL Explain plan

11. Informix Update Statistics

• Overview of Automated Update Statistics
• Monitoring and managing statistics for tables and indexes

12. Informix OLAP and Advanced SQL Functions

• Introduction to SQL OLAP functions
• Window Partitioning, Ranking, and ANSI SQL-99 standards

Day 4: Advanced Best Practices for Informix DBAs (Part 2)

13. Capturing Informix SQL Metrics with SQLTrace

• Overview of SQL Trace and Sysmaster tables

13. Automatic Informix Range Interval Partitioning and Rolling Windows

• Fragmenting large Informix tables
• Managing partitions and old data

14. Optimizing the Operating System for Informix Performance

• Kernel Settings, HugePages, and CPU management
• Tools for monitoring Unix and Linux

15. Using the Sysmaster Database for Informix Server Health Check

• Identifying performance bottlenecks

16. Installing and Upgrading to Informix Version 14 and Informix HQ

• Introduction to the new Informix 14
• Upgrading databases and using Informix HQ

By the end of this course, participants will have a deep understanding of the core features, capabilities, and best practices for managing IBM Informix databases. Whether you're just getting started or seeking to optimize your existing setup, this course offers a comprehensive view of Informix from basic to advanced levels.