Fastest Informix DBA Contest at the IIUG Conference
Folks, There are only a few days left before the international Informix User Conference in Kansas City, April 26-29. http://www.iiug.org/conf/2009/iiug/ Advanced DataTools is sponsoring a contest at the Informix User Conference, to find and honor the fastest Informix DBAs. The challenge is to take a basic Informix database server and a SQL script that takes about 30 minutes to run, and see who can get it to run the fastest. Can you take a new Informix install and, without any prior knowledge, optimize it in 30 minutes? There will be 10 winners in the following categories (Grand Prize will be an iPod Touch): CATEGORIES: Grand Prize - Fastest User DBA. To qualify for this prize, the user must be 1) a paid attendee at the conference (or conference speaker or volunteer, at discretion of the judges), 2) not a consultant, 3) not an IBM employee, and 4) employed by a company using Informix internally. Honorary Prize - Fastest Professional Consultant DBA Honorary Prize - Fastest IBM Developer (IBM employee) Honorary Prize - Fastest Senior DBA (over 50) Honorary Prize - Fastest Mid-Aged DBA (30-50) Honorary Prize - Fastest Youngest DBA (under 30) Honorary Prize - Fastest Newest DBA (shortest experience with Informix) Honorary Prize - Fastest Old-timer (longest experience with Informix) Honorary Prize - Fastest International DBA (Non USA resident) Honorary Prize - Fastest Domestic DBA (USA resident) The challenge will be to complete the following tasks in under 30 minutes: - Tune and optimize the Onconfig file - Tune the optimize dbspace/table layout - Tune the optimize SQL script - Run the script The rules: - Must be in attendance at the IIUG Informix Conference - The row and data counts at the end of the SQL process must be correct. - Must make an appointment at the Advanced DataTools booth to enter in the contest. - All work must be done at the booth; no copies (usb, email) of the scripts will be allowed. - Each participant will have 30 minutes to review and optimize the server and SQL code on a machine provided. - Each participant will be monitored by an Advanced DataTools Consultant. - Each participant's configuration will be saved and the results must be reproducible by the judges. Judges: - Lester Knutsen - Art Kagel - Carlton Doe (The judges' role will be to review the results, arbitrate any disagreement(s), and have final say.) More information will be available on our web site - http://www.advancedatatools.com/Informix/index.html -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________