Art Kagel, is an Independent consultant and IIUG Board Member, presented on programming, concurrency, and tuning applications against Informix. This is an update to the presentation Art did at our last Washington Area Informix User Group Meeting. (Note: there are a few problems with the sound, I tried to fix it as best as I could)


Art Kagel developed and maintains the popular open source utility dostats to enable you to automate and keep up to date catalog statistics and data distribution that the Informix Optimizer needs in order to select the best method of running your SQL statements. He will describe how it works, how to compile it on several platforms, and why you should upgrade to the latest version. He will also discuss the Informix Automated Update Statistics (AUS) and how that compares to dostats.


Have you ever had a large batch job that had to be rerun from scratch when the primary server crashed after the job had been running for many hours? Wouldn't you like to have that job just continue running when your secondary server takes over? You can! This will be a live demonstration of how to configure your servers to take advantage of the Informix Transaction Survival feature.


This session will cover comparing similar data types. A review of normalization. Implementing difficult relationships.


This webcast will focus on best practices for Informix DBAs including why Not to use RAID5.


This is a replay of Art Kagel's Webcast on October 20, 2015 on Informix Storage and the impact of RAID levels, why not to use RAID 5 and what RAID levels work best with modern databases.


Art presents UPDATE STATISTICS in depth, dostats, and his other free utilities for monitoring and tuning an Informix database in his utils2_ak package. Topics covered will include: *Table Level statistics and data distributions *Fragment Level statistics and data distributions *Update statistics for procedure/function *Providing data distributions for User Defined Types *Dostats and the art of balancing distribution quality with runtime performance *Other useful utilities in the utils2_ak package


Art went through the steps one takes to determine the health of the server and start Informix Database Performance Tuning: * Overall Performance * IO Performance * Tablespace Performance * Memory Performance * Virtual Processor Performance * OS Performance * Caches