Migrating and Upgrading to Informix 14 in-house or in the cloud. The easy and the hard way. by Lester Knutsen. There are several easy procedures to upgrade and migrate Informix. We will look at the easy way (in-place upgrades, dbexport, cdr migrate, backup/restore), but sometimes they may not work for you, and you need to create a custom process. We will go over a set of procedures and scripts using HPL, external tables, and parallel unloads/loads that I have used over the last few years to migrate from small systems up through terabyte-sized databases to VMs, new hardware, and the cloud.


Informix by default uses the Operating System (OS) to manage users. In this video, Lester Knutsen will demonstrate how to create a Non-OS Informix User that can access Informix databases without having an OS login. This is the first in a series of videos on Informix TechTalks by the IIUG. For more information on the International Informix Users Group (IIUG) please visit https://www.iiug.org


Advanced DataTools Newsletter – October 2020

1. Are you planning to upgrade to Informix 14.10?  Attend our Informix for Database Administrators Training Course. We have the Informix 14.10 training for you. Lester Knutsen will be teaching our next Informix DBA Class, Informix for Database Administrators updated for Informix version 14.10, on October 5-8, 2020. There is only one space left! More […]

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.


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.


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 14.10 Command Line Utilities Quick Reference Guide

I have updated our series of Informix Command Line Utilities Quick Reference Guides. Folks, you can download the Informix 14 Quick Reference Guide here. The Quick Reference Guide includes the following Informix commands: Oncheck Oninit Onmode Onparams Onspaces Onstat Ontape In 1995, after years of trying to find a manual to check the command line […]

Informix has Automated Update Statistics built into the server. Update Statistics collects metrics to enable the server to run your SQL faster. How do you monitor what tables and indexes need to have the statistics updated and manage Automated Update Statistics (AUS)?


How does the Informix SQL Optimizer choose which index or table or access method to use when running your SQL? This presentation will focus on how to view and understand the SQL Explain plan to see how your SQL is executed. The SQL Explain plan will provide times for each step in your process.


This presentation will focus on Best Practices for Informix database indexes. Every table should have at least one index, and managing indexes is an integral part of a DBA's task and time. Indexing is one method to optimize the performance of a database by reducing the number of disk reads when a query is executed. An index is a structure which is used to locate and access a row in a database table quickly. Indexes are used to enforce uniqueness, primary, and foreign keys and constraints. Indexes can also be a source of problems in a database and may slow performance down when misused.


IBM just announced the exciting new Informix 14 version in March. Advanced DataTools taught our first course for Informix DBAs on release 14 in April. We have been part of the beta programs and would like to share our findings including how to use the new installer, how to upgrade a database, and an introduction to the new Informix HQ server management.


This is a replay of our Webcast on October 15, 2013 to announce the results and winners of the Fastest Informix DBA Contest. Informix DBA's from around the world participated in the challenge to be the Fastest in a combination of OLTP and batch benchmark. The winner is the DBA who had the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run.


This is a replay of our Fastest Informix DBA Contest 2013 status update Webcast on August 20, 2013. This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run. For more information on the Fastest Informix DBA Contest click here!


This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run.


On Jun 19, 2012, we held a webcast with the Fastest Informix DBA Winner Andrew Ford, hosted by Lester Knutsen and Art Kagel, to share with other Informix users how the winners achieved their results. Learn about the tips and tricks the real Fastest Informix DBAs used to achieve their remarkable performance.


Fastest Informix DBA Contest III – How did they do it?

Last year at the 2010 IIUG Informix User Conference in Kansas City we hosted a new “Fastest Informix DBA Contest”. This contest was different from the earlier ones, and focused on “How many transactions per minute” could the contestants tune an Informix database to achieve. The previous contests had focused on improving batch processing performance […]

Exploring the Sysmaster Database

This post is the original article I wrote on Exploring the Sysmaster Database and has been reprinted in the Informix TechNotes, the Informix DBA Survival Guide, Second Edition by Joe Lumbley, the Informix Handbook by Ron Flannery, and many other places.   Open the orginal PDF of this article: https://www.advancedatatools.com/Downloads/Symaster_articule.pdf When you list all the […]

Exploring the Informix OnLine Utilities

This post is the original article I wrote on Exploring the Infomrix Utilities that has been reprinted in many other places.   INFORMIX-OnLine DSA comes with a set of powerful command line utilities that enable you to monitor, tune, and configure your database server. This chapter will focus on eight of these utilities, and present […]

Roles: A New Security Feature in INFORMIX-OnLine Dynamic Server

First published in the Informix Tech Notes Magazine in 1999   INFORMIX-OnLine Dynamic Server, version 7.10.UD1, introduced a new feature called “Roles.” Roles provide a way to grant and revoke privileges to a function, rather than to individual users. In addition, a user is granted the privilege to use one or more Roles. When a user […]

Informix Tech Notes article on Exploring the ONSTAT Utility

First published in the Informix Tech Notes Magazine in 1999 Provided with Informix Dynamic Server is a set of powerful command- line utilities that enable the monitoring, tuning, and configuring of the database server. This article focuses on one of these utilities, ONSTAT, and presents ways to use this utility for server performance optimization. ONSTAT […]

A Web/CGI Interface to the ONSTAT Utility

First published in the Washington Area Informix User Group Newsletter Volume 7, No. 2 – April 1997   This is one of the scripts I presented at the WAIUG Training Day. The purpose is to provide a web interface to the INFORMIX-OnLine ONSTAT Utility. There are two parts to this interface: the first is a […]

Informix Online 5.X TB Utilities Quick Reference Guide

First published in the Washington Area Informix User Group Newsletter Volume 5, No. 2 – May 1995   TBCHECK Usage:  tbcheck [-clist] [-plist] [-qny]                 [ { database[:[owner.]table] | TBLSpace number | Chunk number}                   { rowid | page number […]