Pre-Conference Tutorials

Optional tutorials are available for conference attendees on Sunday April 26th. A half-day tutorial costs just $150. Two half-day tutorials, or a full-day tutorial costs $250. In addition, Four Js and AGS, two of our Conference Gold Sponsors, are also hosting free tutorials.

Tutorials may be scheduled in advance at registration or any time after registration by logging in to the conference website with a registration number and last name. Title selections may be changed at no charge, but there is a $50 fee for cancellations prior to April 1, 2009. After April 1, 2009 there is no refund available for the tutorials.

Half-day Morning Tutorials: 8:30 am - 12:00 pm
- Includes continental breakfast 7:30 am - 8:30 am

Certification Preparation — Sanjit Chakraborty

This tutorial will present in-depth information on the IDS 11 Certification Exam, including:

  • What it means to be an IBM Certified System Administrator
  • The benefits of being Certified
  • Exam preparation strategies
  • Preparation resources
  • Recommended skills
  • The exam structure
  • Taking the exam

Participate in this tutorial and you'll be well on your way to that much sought after perfect exam score!


Troubleshooting Methods and Techniques &mdash Suma Vinod and Mark Jamison

This tutorial presented by members of the Informix Advanced Support Team will explain troubleshooting techniques through a mix of class material and case studies of real-life situations. Students will learn how to troubleshoot performance problems, connectivity and network problems. They will also learn Informix diagnostic methods and tools. This session has been updated for 11.50.


Introduction to IDS, with hands-on — Carlton Doe

Are you new to the world of IDS (Informix Dynamic Server)? Are you looking for a broad exposure to some of the basics? Do you want to try installing IDS and the OpenAdminTool as well as configure a basic instance? If your answer is "yes!" to any of these questions then this is the session for you. In it, you'll get an overview of the IDS Dynamic Scalable Architecture including processor, disk and memory. You'll learn about many of the rich data types you can use to create applications with. Basic logical and physical database design concepts will be introduced so you can most efficiently use your hardware resources. Finally the basic backup and recovery utilities will be introduced. This will be followed by a hands-on session where you'll install IDS and the OpenAdminTool for IDS. You'll create a basic instance with a demonstration database and execute a number of database and instance operations.

This class is limited to 20 students.


New SQL features in IDS 11.10 and 11.50 — Keshava Murthy

IDS 11.10 introduces new SQL features in the language, new data types, indices, built-in functions, triggers, distributed query support, XML support and more. IDS 11.50 introduces BIGINT/BIGSERIAL, XML features for transformation and searching XML, updated Java support, newer JDBC, .NET providers, visual explain, the much- requested automatic update statistics, end to end user tracking and more. This talk will give you an overview of these features with a demo.


Hands-On Lab - Explore IDS Enterprise Replication — Nilesh Ozarkar

In this ER lab, participants will get hands-on experience in setting up IBM Informix Dynamic Server (IDS) enterprise replication. Users will setup, monitor and administer replication nodes, as well as resolve out-of-sync data using the resynchronization mechanism. Users will also get hands-on experience with using web-based administration of ER via OAT.


From I-4GL to Genero®: Migration 1-2-3 — 4J's (

For 4GL programmers new to Genero® Learn how you can migrate existing Informix-4GL applications to Genero® to provide users with a modern and feature rich graphical user interface, either in a Windows environment or over the Web. Learn about the added features to the language that allow you to advance your existing code including dynamic arrays, built-in classes and methods, multiple dialogs, actions, and styles.

Half-day Afternoon Tutorials: 1:00 pm - 4:30 pm - Includes lunch 12:00 pm - 1:00 pm

Certification Preparation — Sanjit Chakraborty

This tutorial is a repeat of the morning session. See the description of session TM1 for details.


Advanced Troubleshooting Scenarios — Ron Privett, Elisabeth Bach, Suma Vinod

This tutorial presented by members of the Informix Advanced Support Team will feature the same approach as the morning troubleshooting session, mixing classroom material and case studies. Students will learn best-practice methods for diagnosing memory problems, HDR/MACH11/ER problems, and Windows-specific problems. This session has been updated for 11.50.


Using All of IDS MACH-11 Technology, with hands-on — Carlton Doe

In mid-2007, IBM unleashed the fastest cat in the data server world with Informix Dynamic Server (IDS) 11. The crown jewel was the increased capability added to IDS's High-Availability Data Replication (HDR) technology. With this new functionality, called Multi-instance Active Cluster for High Availability (MACH-11), you can use additional secondary instance types to create an "availability fabric" to safeguard your IDS data and provide uninterrupted data services. The simplicity of operations and ease of setup was outstanding and completely unheard of in the data server market.

Come learn about, then create and use the full spectrum of MACH-11 technologies available in IDS 11.5 including Updatable Secondaries, the Online Connection Manager and Server Monitor agent, Service Level Agreements and the Failover Arbitrator to create a cluster of instances that can provide virtually uninterrupted data services within a business environment.

This class is limited to 20 students.


Extending Your Business Logic with OpenAdmin Tool for IDS — Ian Ilsley

The tutorial will take you through a tour of the internals of the OpenAdmin Tool for IDS (aka OAT). It will show you how to build a development environment using open source components such as eclipse. You will learn how to extend the functionality of OpenAdmin Tool for IDS.


Hands-On Workshop on New IDS Features — Frank Arias

Have you ever learned something in a lecture only to find it didn't work as you thought when you attempted to implement it? This session is an opportunity to get out of the standard 60 minute lecture and gain hands-on experience with some of the new features of IDS. Topics will cover many areas including administration features, performance tuning, data availability, and security.


New GUI Features in Four J's Genero® 2.20 — 4J's (

For experienced Genero® developers and those curious about Genero® as a RAD and rich UI. Learn about the exciting new features in Genero® 2.20 including:

  • New Enhanced Desktop UI capabilities
  • New 4gl interface to Java
  • Genero® Web Services Integration in IDE
  • Desktop-to-Web: Overview and brief demonstration illustrating the ease with which Genero® applications can be developed and deployed for either the Desktop or the Web with Genero® Studio
  • How to quickly code an interface to Genero® Report Writer
  • How to quickly start designing reports using the new GUI Genero® Report Designer
Full-day Tutorials: 8:30 am - 4:30 pm - Includes both continental breakfast 7:30 am - 8:30 am and lunch 12:00 pm - 1:00 pm

Getting the Most out of IDS Indexes — John Miller

Indexes are an essential part of any database. This presentation will help DBAs understand the ins and outs of indexes. It will include a detailed look at indexes from A-Z, highlighting such features as dynamic runtime index compression — a new feature in 11.50. It will also provide a detailed look at some of the issues that affect index usage, such as pagesize, key value locking, the btree scanner, fragmentation and update statistics. We'll also look at how to monitor and utilize indexes to improve sort speed. Learn how to get the most out of your indexes.


Solving Complex IDS Management and Performance Optimization Challenges with Server Studio and Sentinel — Art Kagel by AGS (

Are you getting top notch performance from your mission-critical IDS applications? Optimizing and tuning your IDS environment means managing ALL the pieces — not just your SQL. Rapid identification and resolution of database performance problems without appropriate tools is like racing a Ferrari on flat tires. Don't let it happen to you!

Renowned Informix DBA and developer Art Kagel will conduct this intensive, hands-on, full-day course which will introduce IDS developers and DBAs to the various tools at their disposal and demonstrate how and when to apply each to efficiently manage and optimize IDS performance. Learn some of the best practices, and save yourself countless hours of wrestling with the complexity of your IDS infrastructure. Gain hands-on experience with how the wide-ranging functionality provided by AGS' Server Studio and Sentinel helps database professionals:

  • Improve efficiency of database development, SQL debugging and testing
  • Automate 24x7 monitoring of server operations in real time
  • Perform rapid identification and remediation of database performance problems
  • Pinpoint bottlenecks and resource contention issues
  • Resolve query problems with comprehensive SQL tuning
  • Automate daily maintenance tasks
  • And more...