Fastest Informix DBA Contest II
Fastest Informix DBA Contest II June 18 – September 30, 2009 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: * Information on the Informix IDS 11.50.xC4 virtual appliance. * Download the Informix IDS 11.50.xC4 virtual appliance here! To register for the contest and download the rules, data and code, 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 ______________________________________________________________________
I can't participate... I hit filters 1 and 2... Dammit! My company (a consulting firm) doesn't use Informix internally (that I know of), and I'm working at a project at client site, who uses Informix... should I quit my job and try? Tempting... LOL! Ramon On Jun 20, 1:19 pm, Lester Knutsen <les...@advancedatatools.com> wrote: > Fastest Informix DBA Contest II > > June 18 – September 30, 2009 > > 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 > websitehttp://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: > > * Information on the Informix IDS 11.50.xC4 virtual appliance. > * Download the Informix IDS 11.50.xC4 virtual appliance here! > > To register for the contest and download the rules, data and code,http://www.advancedatatools.com/Informix/index.html > > -- > ______________________________________________________________________ > Lester Knutsen les...@advancedatatools.com > Advanced DataTools Corporation Voice: 703-256-0267 x102 > Visit our Web page:http://www.advancedatatools.com > ______________________________________________________________________
Hi, You can participate, just cannot win the grand prize. You could participate and win the Fastest Professional Consultant DBA. Regards - Lester FanDeLaU wrote: > I can't participate... I hit filters 1 and 2... Dammit! My company (a > consulting firm) doesn't use Informix internally (that I know of), and > I'm working at a project at client site, who uses Informix... should I > quit my job and try? Tempting... LOL! > > Ramon > > > On Jun 20, 1:19 pm, Lester Knutsen <les...@advancedatatools.com> > wrote: >> Fastest Informix DBA Contest II >> >> June 18 ' September 30, 2009 >> >> 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 >> websitehttp://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: >> >> * Information on the Informix IDS 11.50.xC4 virtual appliance. >> * Download the Informix IDS 11.50.xC4 virtual appliance here! >> >> To register for the contest and download the rules, data and code,http://www.advancedatatools.com/Informix/index.html >> >> -- >> ______________________________________________________________________ >> Lester Knutsen les...@advancedatatools.com >> Advanced DataTools Corporation Voice: 703-256-0267 x102 >> Visit our Web page:http://www.advancedatatools.com >> ______________________________________________________________________ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________