Advanced Data Tools Logo
Consulting Training Tech Info Successes User Groups Our Company spacer
IBM Business Partner

We build FAST Informix Databases!


Next Webcast!

Informix Best Practices by Thomas Beebe, Art Kagel, Lester Knutsen and Mike Walker,

We are pleased to share our Webcast series for Informix DBAs - "Informix Best Practices". We will discuss configuration, disk layout, backups, performance tuning, and high availability disaster recovery implementation. Our Informix Best Practices are based on over 30 years of experience managing and tuning database systems. The webcast will be presented by Lester Knutsen, Principal Database Consultant, Art Kage, Tom Beebe, and Mike Walker, IBM Informix Champions from Advanced DataTools.


Informix Best Practices - Using the Sysmaster database to perform an Informix Server Heath Check by Lester Knutsen - Thursday, October 5, 2017 at 2:00pm EST- Register here

This is the latest update to my talk on Exploring the Sysmaster database. We will present new scripts to monitor and tune your Informix Server and perform a system health check. Examples include how to tell what is the most expensive query running on your server now, what page size is best for your tables, what indexes are used and not used, how is memory used on your server, and much more.... These scripts will help you identify the performance bottlenecks on your Informix Server.

Lester Knutsen is President of Advanced DataTools Corporation, and has been building large database systems using Informix since 1983. Lester focuses on large database performance tuning, training and consulting. Lester is a member of the IBM Gold Consultant program and was presented with one of the Inaugural IBM Data Champion awards. Lester was one of the founders of the International Informix Users Group and the Washington Area Informix User Group.


Informix Best Practice - Informix Query Performance Tuning Basics by Mike Walker Thursday - Thursday, October 26, 2017 at 2:00pm EST - Register here

This session will cover some of the basics of Informix Tuning, with a focus on monitoring and tuning of queries. Some of the areas that will be covered include: Identifying long running queries, Explain plans, Optimizer directives, Monitoring the buffer pool usage, Checking statistics, and Finding busy tables


Informix Best Practices - Schema Design Tips by Art Kagel - Thursday, November 30, 2017 2:00pm EST - Register here

Comparing similar data types. A review of normalization. Implementing difficult relationships.

Click here for our past Webcast Replays focusing on Informix Performance Tuning and using Informix and the Internet of Things (IoT)