Re: Fastest Informix DBA Contest at the IIUG Conference
On 10 Apr, 20:32, Lester Knutsen <les...@advancedatatools.com> wrote: > Fastest Informix DBA Contest > > Advanced DataTools is sponsoring a contest at the International Informix User Conference in Kansas City, April 26-29, 2009, 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 soon! > -- > ______________________________________________________________________ > Lester Knutsen les...@advancedatatools.com > Advanced DataTools Corporation Voice: 703-256-0267 x102 > Visit our Web page:http://www.advancedatatools.com > ______________________________________________________________________ Which of the following are allow? SQL Layer 1. rewriting the SQL Server Layer 1. changing server parameters 2 changing the amount of memory used by the server 3 changing the disk layout (dropping/recreating dbspaces + tables/ indexes) 4 changing Informix fragmentation strategies 'Disk Manager' kayer 1 For cooked devices ia changing the filesystem parameters allowed? fstune? 2 Is this Veritas (or another disk manger e.g. Disksuite) and can that be tuned as well? Storage Layer 1 Is this on a SAN and can the SAN config be tuned? 2 What about changing the disk layout of LUNs across spindles? Pity I am not going...