- 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
- Webcast Replay on YouTube
- Download webcast slides: Informix_Tutorials-Monitoring
- Download example Onstat Ratios Worksheet: Onstat_Ratios
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.
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.
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.
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.
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 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 – 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.