Tech Topic: Informix Tutorials for Beginners

Informix Tutorial – Informix Database Server Monitoring

How do you use the command-line utilities to manage and monitor an Informix Server? We will discuss onstat, oncheck, and the new InformixHQ to manage your server.
The Agenda includes:
  • Onstat – Discovery Options
  • Onstat – Performance Ratios
  • Onstat – User Sessions and Threads
  • Onstat – Measuring Disk IO
  • Onstat – Monitoring Locks
  • Other Onstat Options
  • Oncheck – Basic Dbspace Checks
  • Omode – How to terminate a Session
  • Using InformixHQ
Downloads:
Informix Tutorial – Creating Databases, Tables, Database Catalogs and Managing Security

How do you build databases and tables in Informix? We will discuss best practices for creating and managing databases and tables, partitioning, and database security. We will demonstrate object-oriented data types, using SQL to generate SQL Scripts and creating a Non-OS user for Informix database security.

Informix Tutorial – Connecting Users and Tools to Informix Servers

How do you connect users and tools to an Informix Server from Windows, Unix, and the Web? We will discuss connections using Microsoft ODBC, Informix SDK, Java, PHP, DRDA, and other options. This is a Webcast reply from June 25, 2020.

Informix Tutorial – Informix Backup, Recovery and High Availability

How do you backup and restore an Informix Server? High Availability is crucial to a successful database. We will cover and demonstrate database backups, restores, and setting up High Availability Data Replication (HDR). This replay includes additional material on HDR setup and switching between Primary and Secondary Servers that is not covered in the original webcast.

Informix Tutorial – Managing Informix Logs

How do you configure and maintain Informix Logs? The logs are critical to database reliability, and we will discuss best practices for managing and configuring Informix logical logs. We will also cover the backup and recovery of logical logs.

configure and maintain Informix Logs
Informix Tutorial – Managing Informix Disk Space

Disk IO is often the performance bottleneck for databases, every transaction needs to get written safely to disk fast. How do you set up and configure the disk space for an Informix Server? What disk and RAID configurations provide the best performance and reliability?

Disk IO is often the performance bottleneck for databases, every transaction needs to get written safely to disk fast. How do you set up and configure the disk space for an Informix Server? What disk and RAID configurations provide the best performance and reliability?
Informix Tutorials – Configuring a New Informix Server

Informix Tutorials Webcast Replay – Informix Tutorial – Configuring a New Informix Server by Lester Knutsen, February 27, 2020.

How to script configuring an Informix Server? This Webcast will cover everything you need to know to build with scripts, a new medium, or large server. The Webcast will be a review of the Informix ONCONFIG file and configuring memory, CPUs, Network, and Disk for a more extensive Informix Server configuration.

Informix Tutorials Webcast Replay - Informix Tutorial - Configuring a New Informix Server by Lester Knutsen, February 27, 2020. How to script configuring an Informix Server? This Webcast will cover everything you need to know to build with scripts, a new medium, or large server. The Webcast will be a review of the Informix ONCONFIG file and configuring memory, CPUs, Network, and Disk for a more extensive Informix Server configuration.
Informix Tutorials – Getting Started with Informix

Informix Tutorials Webcast Replay – Getting Started with Informix by Lester Knutsen on Thursday, January 30, 2020, The Webcast is a step by step guide to installing and getting up and running a basic Informix Server. We will demonstrate using InformixHQ, the IBM Informix Knowledge Center, and how to find resources to get started with Informix.

Informix Tutorials Webcast Replay - Getting Started with Informix by Lester Knutsen on Thursday, January 30, 2020. The Webcast is a step by step guide to installing and getting up and running a basic Informix Server. We will demonstrate using InformixHQ, the IBM Informix Knowledge Center, and how to find resources to get started with Informix.