Get Up to Speed for the Fastest Informix DBA Contest
Build on DBA skills while taking advantage of a time extension for the 2013 contest
My previous column, “Putting Database Administrator Skills to the Test,” introduced the sixth-annual Advanced DataTools Fastest Informix DBA Contest and discussed its details. In this column, I would like to share a few updates and resources available to contestants and other database administrators (DBAs), which they can use to learn more about tuning IBM® Informix® database servers.
One update is that participation in the contest has been extended to September 30, 2013. In addition, each participant will be allowed three attempts. The extension gives participants additional time to prepare and consult a list of resources presented here that can enhance everyday Informix DBA skills, which are critical for increasing the chances of success in the contest. One of the best ways to learn is by studying the methods of others who have done well in past contests. These resources highlight those techniques that have worked favorably in the past for winning contestants.
Some of the best resources I can recommend are IBM Data magazine articles about previous contests. For example, this year’s contest combines the online transaction processing (OLTP) performance-tuning requirements from last year’s contest with the batch SQL-tuning requirements of the contest held in 2009. In the following articles, read about how past contest winners succeeded and the techniques they used to make their Informix implementation faster than the competition:
- “New Fastest Informix DBA Contest at the IIUG 2012 Informix User Conference,” May 2012
- “Every Last Drop,” October 2011
- “Fastest Informix DBA Contest III,” April 2011
- “Fastest Informix DBA: How Did They Do It?” September 2009
Plus, take a look at interviews and webcasts highlighting some of the past winners and the approaches they applied to get the database to run faster than competing databases. The following replays are available at YouTube.com:
- Fastest Informix DBA Contest July, 2013 Webcast to Kick Off the Contest
- Fastest Informix DBA Contest 2012 Webcast – How Did They Do It?
- Fastest Informix DBA Contest 2009 Results Webcast – How Did They Do It?
Look for an upcoming column about the results of this year’s contest in the next few months. This contest offers DBAs a great opportunity to learn as well as try out their Informix DBA skills. Visit the Advanced DataTools website for more information about the contest and how to participate.
|[followbutton username='IBMdatamag' count='false' lang='en' theme='light']|