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.


Migrating and Upgrading to Informix 14 and Migrating to the cloud. The easy and the hard way.

IBM User Group DayPresentation
Migrating and Upgrading to Informix 14 or the cloud. The easy and the hard way.

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.

Exploring the Sysmaster Database – My New Scripts from the IIUG World 2019 Conference

These are my latest Sysmaster Scripts from my presentation at the Informix IIUG World Conference in 2019. Download presentation PDF: advancedatatools.com/…/Sysmaster_IIUG_Conf_2019_A12_LesterKnutse.pdf Download New Sysmaster 2019 Scripts (zip file): advancedatatools.com/…s/sysmaster2019.zip Download Past Sysmaster 2017 Scripts (zip file): advancedatatools.com/…s/sysmaster2017.zip

Running Informix in a Monster Virtual Machine

Running Informix in a Monster Virtual Machine Lester Knutsen presented at the IIUG Informix Conference April 23-27, 2018 in Raleigh, NC.

A monster virtual machine is a VM with lots of memory, CPUs and disks. I have been dealing with many Informix database servers running in a virtual environment and will share some of the problems and solutions for Informix to work well in VM. We will talk about everything from a VM on my laptop to a VM with more than 256 GB of memory and more than 96 Virtual CPUs.