Advanced DataTools Newsletter – July 2021

Published on July 12, 2021 by Lester Knutsen

1. Informix Training Schedule for 2021

We have moved our training servers to the cloud and are testing configurations. Currently, we plan on holding the Informix for Database Administrators Course on September 20-24. The course is an online instructor-led course taught by Lester Knutsen.

We are also developing and updating our course formats for a more flexible combination of instructor-led and self-paced course material with the same performance tuning benchmarks labs.

Informix for Database Administrators Training Course – September 20-24, 2021

Are you planning to upgrade to Informix 14.10? We have the training for you. Lester Knutsen will teach our next Informix for Database Administrators class updated for Informix version 14.10.

More info and registration at

Advanced Informix Performance Tuning Course – October 25-29, 2021

This 4-day course is for experienced Informix database administrators and application developers responsible for installing/upgrading, managing, optimizing, and tuning an Informix database server. Informix versions 14, 12, and 11 are covered.

More info and registration at

2. Informix Performance Tune-Up and Health Check

Lester Knutsen continues to perform a limited number of Informix Performance Tune-Up and Health Checks. Our performance tuning is a scientific examination of your database server to identify bottlenecks and provide recommendations on how to get the best results from your system. We begin by setting up scripts on your system to monitor and collect statistics from your server, the operating system, CPU, memory, and disk utilization. A complete review of your Informix Database server will start you off to a better year.

More information:

3. Informix TechTalks from the IIUG

Lester is producing the Informix TechTalks by The IIUG, with webcasts and replays on a new IIUG YouTube Channel. The IIUG has launched this new channel on YouTube for Informix Users! The YouTube channel will be a place for Informix how-to videos.

Here are the links for upcoming events:
Next Tech Talks:

Here are the links for past events:
Past Tech Talks:

The following is a list of the Informix TechTalks that are available at this time:

  • Informix Tech Talks: History of the Informix User Groups – Part 1 & 2 by Carlton Doe, Walt Hultgren, Cathy Kipp, Lester Knutsen, and Mike Reetz
  • Informix Tech Talks: Informix Large Table Operations by Ben Thompson
  • Informix Tech Talks: Getting Serious About Redundancy! by Tom Girsch
  • Informix Tech Talks: Informix SQL Performance Tuning Tips by Jeff Filippi
  • Informix Tech Talks: Three ways to capture data changes when they happen! by Art Kagel
  • Informix Tech Talks: Creating Informix Non OS Users by Lester Knutsen
  • Informix Tech Talks: Migrating and Upgrading to Informix 14 in-house or in the cloud. The easy and the hard way. by Lester Knutsen

Lester Knutsen is honored to be selected to serve on the IIUG Board of Directors for 2021. He was one of the founders of the IIUG, and it is great to have the time to contribute again.

View the announcement at

4. Free Informix Tutorials Videos – a step by step approach to using Informix Database Servers by Lester Knutsen

Over 16 hours of technical videos sharing our knowledge about Informix!

5. Informix Consulting and Support transferred to XDB Systems

The spin-off of our Informix Consulting and Support to XDB Systems, Inc., founded by Thomas Beebe and Mike Walker, is completed and has gone very well. Lester Knutsen will continue to provide Informix Training and Performance Tuneup services on a part-time basis. Please join us in congratulating and supporting Tom and Mike in their new venture!

About us:

At Advanced DataTools, our mission is to help our customers achieve their goals. We have over 25 years of experience in business, and more than 35 years of experience with the Informix product line since Informix was launched in the early 1980s. Our professionals have completed hundreds of successful projects, and include 4 IBM Champions, 2 IIUG Directors Award winners, and an IBM Gold Consultant. The company was founded in 1993 by Lester Knutsen, who continues to serve as President and Principal Consultant.
More information –