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.
Whether you are reorganizing a table, loading a table or doing a full data migration, you will want to use the unload/load capabilities of Informix. This is an in depth look at the various options available to you in such an endeavor as well as issues which should be taken into consideration.
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.
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 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