Fastest Informix DBA Contest II - web cast September 4, 2009 at 2:00 pm EDT
Folks, We have over 60 Informix DBA's participating in our new Fastest Informix DBA Contest. See http://www.advancedatatools.com/Informix/index.html for details. We will be conducting a Q&A session web cast on Friday, September 4, 2009 at 2:00 pm, Eastern Daylight Time (New York, GMT-04:00) and would like to invite anyone interested in participating in the contest to attend this web cast. We will answer questions about the contest from participants and show an example of how the benchmark will be conducted. To register for the web cast visit http://advancedatatools.webex.com and look under upcoming events or click the link on the page at http://www.advancedatatools.com/Informix/index.html Fastest Informix DBA Contest II - Background Advanced DataTools is sponsoring a NEW contest for Informix Users to find and honor the fastest Informix DBAs. This is a new version of our very successful contest at the 2009 IIUG Informix User Conference. The challenge is to take a basic Informix IDS database server configuration and a SQL script that runs a series of inserts and updates and see who can get it to run the fastest! There will be 12 winners in the following CATEGORIES: Grand Prize – the Fastest User DBA. To qualify for this prize, the user must be 1) a DBA employed at a company using Informix internally, 2) not a consultant, 3) not an IBM employee. (Grand Prize is either a Free pass to the 2010 IIUG Informix User Conference or an iPod Touch) Honorary Prizes (Fastest DBA Shirt): Fastest Professional Consultant DBA Fastest IBM Developer (IBM employee) Fastest Senior DBA (over 50) Fastest Mid-Aged DBA (30-50) Fastest Youngest DBA (under 30) Fastest Newest DBA (shortest experience with Informix) Fastest Old-timer (longest experience with Informix) Fastest International DBA (Non USA resident) Fastest Domestic DBA (USA resident) Fastest with the fewest changes The challenge will be to complete the following: - Download the data and the SQL Code - Setup an Informix IDS environment - Identify and add missing indexes - Tune and optimize the Onconfig file - Tune the optimize dbspace/table layout - Tune the optimize SQL script - Run the benchmark script - Repeat this process until you are satisfied with your times - Send the ONCONFIG file, a setup.sh script and the tuned benchmark_run.sql file to us by September 30, 2009 and we will see how it runs on our hardware. The rules: - See the contest details for what changes are allowed and not allowed. - The row and data counts at the end of the SQL process must be correct. - The final timed run will be at our facility on our hardware, run by one of our staff - Each participant's configuration will be saved and the results must be reproducible. - The judges role will be to review the results, arbitrate disagreements and will have final say. - The rules may be updated to clarify any questions submitted before the contest ends on September 30, 2009. Updates will be posted on the website http://www.advancedatatools.com/Informix and on Twitter – http://www.twitter.com/FastInformixDBA Judges: Lester Knutsen, Art Kagel, Carlton Doe, Spokey Wheeler If you need an Informix system, I would suggest getting the Developers edition of the Informix Virtual Appliance Regards - Lester -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________