Lester again presented new scripts to monitor and tune your Informix Database server using the Sysmaster and Sysadmin Databases. This is major update to his most popular talk at the International Informix User Group (IIUG) conferences over many years - "Exploring the Sysmaster Database".
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)
Do you have an Informix database and need to encrypt columns with privacy information? Do you have time to change all of your production applications to implement encryption? Have you had a security or FISMA/DISA audit? Lester Knutsen will present how we have converted existing Informix databases to add column level encryption with minimal impact to your existing applications. He will demonstrate how to take an Informix database and change it to use encrypted columns with little impact to your front end applications using triggers, functions and Informix encryption. Lester will also discuss simplifying access using roles to grant and revoke privileges.
The Open Admin Tool (OAT) is one of the most exciting and least talked about new features for Informix in the past few years. It is an open platform to manage your Informix instances through a convenient web interface. In this talk we will be breaking down how to get up and running with OAT and covering many of the basic tasks you can perform in it. Since version 11 was released many people have migrated up to it, however most of them have either not gotten OAT up at all or looked at it briefly and put it back down. Listen to the webcast and we will tell you why you want to go to the latest release of OAT and why you should be using it every day. Some of the highlights:
*Get step by step instructions to getting it running on a variety of operating systems
*Learn about monitoring replicated environments using your web browser
*See different ways to get very easy to read visual guides to the health of your database
*Learn how to safely give your Jr DBA the ability to add new space without having to worry every time he does
*See how to browse your database without needing to use dbaccess or SQL
*Find out how to easily get reports that you can give to management showing how much Informix is racing along
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
This is a replay of our Webcast on October 15, 2013 to announce the results and winners of the Fastest Informix DBA Contest. Informix DBA's from around the world participated in the challenge to be the Fastest in a combination of OLTP and batch benchmark. The winner is the DBA who had the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run.
This Webcast will demo and benchmark the Informix Warehouse Accelerator 12.10. Last year we showed it running 9 hours of queries in 14 minutes. Mike Walker will demonstrate our current benchmarks with this exciting new database technology. He will demonstrate ad-hoc queries on a bookstore database with 250 million customers and over a billion records in the fact table.
This is a replay of our Fastest Informix DBA Contest 2013 status update Webcast on August 20, 2013. This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run. For more information on the Fastest Informix DBA Contest click here!
This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run.
Lester Knutsen and Mike Walker will present a series of tools to monitor and tune your Informix Database Server.
*Using SQL Trace to monitor user sessions
*Tips for Remote DBA monitoring
* Building a Monitoring Dashboard with Yellowfin BI
Lester presented new scripts for monitoring and tuning your Informix Database server using the Sysmaster and Sysadmin Database. This is an update of Lester's most popular talk at Informix user conferences over the past several years, "Exploring the Sysmaster Database", and will show what is new in Informix 12.10.
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
What do Wikipedia, Facebook, Wordpress, and Yahoo all have in common? They all run on PHP. PHP is an open source server-side scripting language designed for Web development to produce dynamic Web pages. And it works great with the fastest database, Informix. In this talk we will be discussing how quick and easy it is get going in PHP and how to set up PHP to talk to Informix using the PDO driver library. You can easily use PHP to select, insert, update and delete data from an Informix database to create a database driven web site.
On Jun 19, 2012, we held a webcast with the Fastest Informix DBA Winner Andrew Ford, hosted by Lester Knutsen and Art Kagel, to share with other Informix users how the winners achieved their results. Learn about the tips and tricks the real Fastest Informix DBAs used to achieve their remarkable performance.
Our Webcast to demo the Informix Warehouse Accelerator on February 28, 2012. We have been using the Informix Warehouse Accelerator for over a year and I am continually shocked at how fast it is. In one set of benchmarks it ran 9 hours of queries in 14 minutes. Mike Walker, Art Kagel, and I will demonstrate our current benchmarks with this exciting new database technology. We will demonstrate ad-hoc queries on a bookstore database with 250 million customers and over a billion records in the fact table.
This is a replay from our webcast reviewing the results of our Fastest Informix DBA Contest II, done online in the fall of 2009, discussing how the winners did it. Congratulations to Tatiana Saltykova, new 1st place finisher in the Fastest Informix DBA contest! The challenge was to take a batch billing SQL job that took over 40 hours to run and optimize it and the Informix database configuration.
