Category Archives: Presentation

Presentations given by the Advanced DataTools team at IBM, IIUG, and WAIUG conferences

Informix TechTalk: Informix Sysmaster Database Queries for monitoring and performance tuning

Posted on by

Replay Informix TechTalk: Informix Sysmaster Database Queries for monitoring and performance tuning by Lester Knutsen From: Thursday, February 2, 2023, 2:00 pm EST Download my latest Sysmaster Scripts for this presentation – Sysmaster2023.zip YouTube Replays: https://youtu.be/C9zk8FmuUFQ Download Slides: Informix-SYSMASTER-2023-LesterKnutsen.pdf Description: Lester Knutsen will present his favorite Informix Sysmaster Scripts for monitoring and performance tuning tips. This […]

Informix TechTalk: Enhancing Informix 4GL with TERMCAP Settings by Lester Knutsen

Posted on by

Informix Tech Talk Replay Title: Informix TechTalk: Enhancing Informix 4GL with TERMCAP Settings by Lester Knutsen Replay from Thursday, September 29, 2022, 2:00 pm EDT Description: How to work with Informix 4GL Terminal and TERMCAP capabilities to improve the appearance of 4GL programs. Informix 4GL uses the Unix TERMCAP file to display colors, window line […]

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

Posted on by

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

Posted on by

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

Posted on by

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.