PERFORMANCE TUNING SEMINAR - OKIIUG

The second annual Informix Engine Tuning and Performance Seminar will be held on Saturday, January 31, 1997 from 8:30 a.m. ~ 4:30 p.m. The seminar will be conducted by an outside consultant that specializes in Informix engine work. He is also a certified, current Informix instructor for all engine administration, performance, and tuning classes. This is the same instructor that conducted the seminar last year. The seminar has been updated to include up to version 7.24 ODS. Extensive personal question and answer time is provided to explore other issues and/or versions/products. THIS IS NOT A TEXT BOOK BASED SEMINAR!!! This is a real world issues seminar, with experience being the guide rather than a text book. As with last year, seminar materials will be provided, and lunch is included in the cost. Last year's seminar was well attended, from as far away as Texas! This year will be updated to include all current releases of Informix. As a bonus item, an additional free seminar is included that will cover Stored Procedures, Triggers, and advanced SQL. This additional seminar will be scheduled by the attendees to match everyone's schedule. Many thought that last year's seminar was more helpful in day to day operation than any class they had taken previously. This year promises to be even better! PROPOSED SEMINAR OUTLINE Section 1: Introduction to Performance Tuning Section 2: Performance Measuring Tools Unix Tools Informix Tools Section 3: Disk Performance Tuning Read and Write Cache Tuning Checkpoint Intervals and Duration How Many LRU?s ? How Many Page Cleaners ? Kernal AIO vs Normal AIO How Many AIO VP?s ? Placement of Objects on Disk Tuning Read-Ahead Parameters Section 4: Fragmentation and PDQ Strategies for Fragmentation What is PDQ ? Monitoring and Tuning PDQ Section 5: Memory Performance Types of Shared Memory Tuning Shared Memory Section 6: CPU Performance Strategies How Many Processors Do You Need ? Different Types of Virtual Processors How Many CPU Virtual Processors Do You Need ? Section 7: Some Database and Table Issues Transaction Logging Monitoring Table Extents Monitoring Table Access Stored Procedures and Triggers Section 8: Query Performance Optimizer Join Methods Setting OPTCOMPIND Creating Data Distributions Section 9: Locking Performance Using Locks Efficiently Monitoring Lock Usage Section 10: Other Performance Tuning Issues Data Load Considerations Index Issues Large Delete Operations Improving Archiving Large Number of Users Considerations The Seminar will be held at Knowledge Development Center in Blue Ash, a north suburb of Cincinnati, Ohio. An additional date will be decided for the additional Advanced SQL and Stored Procedures and Triggers Seminar. Attendees of the first seminar not able to attend the second will be provided with class materials. For those too far to attend in person, materials and videos will be made available at the same cost, plus shipping. For these individuals, membership in the International Informix Users Group will provide member benefits. Too far is considered over 200 mile radius from Cincinnati. The cost will be $100.00 per member and includes all materials. Remember corporate members can send up to five (5) individuals. Corporate members sending more than 1 will receive a $25 discount for the second, and a $40 discount for each additional after 2. The cost for non-members will be $350.00 per attendee. Checks or cash accepted, due on or before the seminar date (Jan 31, 1998). Fill out the enrollment form (1 per attendee) and: fax to (606) 586-0358, or email to okiiug@hotmail.com or frankc@glasscity.net, or mail to Frank Catrine, OKI-IUG 561 Valleyview Pt. Springboro, Ohio 45066 Acceptance will be on a first come, first serve basis, with priority given to members. You may call me at (606) 386-8011, or email okiiug@hotmail.com or frankc@glasscity.net for further information. OKI-IUG SEMINAR REGISTRATION FORM PERFORMANCE TUNING THE INFORMIX ENGINE SATURDAY JANUARY 31, 1998 Name: _____________________________________________________ Company: __________________________________________________ Member: Y N (circle one) Phone Number: (_____) ______-_____________ Check Enclosed? Y N (circle one) Members need only fill out information above. Want to become a member? Our membership rates are $30.00 per year for an individual, $125.00 a year for corporate membership (5 individuals). Please fill out above information, and continue below. Address:______________________________________________________ Address: ______________________________________________________ City: ______________________________ State _________ Zip ____________ Phone: _________________________________ Membership Type: Corporate Individual (circle one) Contact Person: ________________________________________________ fax to (606) 586-0358, or email to okiiug@hotmail.com or frankc@glasscity.net, or mail to Frank Catrine, OKI-IUG 561 Valleyview Pt. Springboro, Ohio 45066