Pre-conference tutorials provide in-depth, immediately useful training in the latest techniques, effective tools, and best strategies. They offer a deep dive into the specifics of what to do and how to do it, giving you a new toolset and depth of understanding to take back to your organization.

Tutorial Summaries

SUNDAY MORNING TUTORIALS 8:30 AM - 12:00 PM Includes continental breakfast 7:30 am - 8:30 am


Certification Preparation for IDS version 11.70 — Sanjit Chakraborty

Are you considering taking the free Informix 11.70 certification exams offered at the conference? The Informix Certification Prep Tutorial is the fastest way to prepare for the Informix Certification programs. Attend this tutorial for everything you want to know about the Informix certification programs. This class will cover: Exam Preparation Strategies, Preparation Resource, Exam score structure, Taking Certification Exam, Recommended Skills, Exam Contents etc.


Hands-on with Informix Automatic Storage Provisioning — Carlton Doe

With Informix 11.7, a new feature was introduced to help you manage your instance storage more easily. Called Informix Automatic Storage Provisioning, the instance can dynamically extend or expand chunks or dbspaces should your instance run out of space. This tutorial will give you hands-on experience with using this feature. You'll extend chunks, expand spaces, create and use the instance storage pool and more.


Using Informix with Web Services — Veronica Gomes

This tutorial introduces the user to the capabilities in Informix and tools like 4GL and Optim Data Studio, in order to easily leverage Informix and applications around Informix for Web Services (Service Oriented Architecture).


Migration to Informix Version 11.70 — Best Practices — Rakesh Naik

Any database migration requires careful planning, use of different skill sets and tools, must satisfy business requirements, and account for any unexpected issues during the migration process. Informix provides two migration methods - the use of which depends on your plans. For each method, certain practices must be followed to avoid potential problems. This tutorial will walk you through the two Informix migration processes including what you need to know to plan your migration, the resources that you can use to assist, what actions to take when the migration fails, and the steps involved in ensuring a successful migration. Working with each of the Informix data movement utilities, including External Tables, will allow you to understand which utility is best suited for your environment. Also, the use of the new Conversion Guard feature will help you understand how simple it now is to revert to your previous Informix version following a migration failure.


Working with OpenSource and Informix — Jan Husar, Jacques Roy

In this tutorial you will learn about the tools used in the open source community and how to create patches. It also includes discussions on code organization in different projects and how to install products such as Liferay and Mediawiki. The tutorial ends with an overview of a new project: Open on Informix.

SUNDAY AFTERNOON TUTORIALS 13:00 PM - 4:30 PM Includes lunch 12:00 pm - 1:00 pm


Improve the Speed and Performance for Informix — John Miller III

This tutorial will focus on how to improve the performance of the Informix database server, being able to recognize performance bottlenecks and how to correct them and how to take advantage of the new performance features of version 11.7 to accelerate your system to all new levels.


Hands-on with Informix Flexible Grid — Carlton Doe

This lab gives you the opportunity to get practical, real-world experience using the new Informix Flexible Grid. You will build and administer a Grid cluster. You will create a database and explore how table and DML operations execute within the Grid. If you want to get up to speed quickly with this, the latest "big" Informix feature, this is the tutorial for you.


All about fragmentation (aka partitioning) — Keshava Murthy

This tutorial will take the user from newbie to expert on what is fragmentation, when to use it, how it works, how other systems in Informix [query processing, fragment elimination, memory management, parallelism(pdq), statistics collection and maintenance, attached/detached indices, compression] work with fragmented table and indices.


Develop your application using SPL — Pradeep Natarajan

The Informix Stored Procedure Language provides a powerful platform to access and manipulate your database. In this tutorial session Informix users can learn how to develop applications using the Informix Stored Procedure Language in two different environments using different tools. The tutorial session will be divided into two parts:

  1. Developing SPL routines using IBM Optim Development Studio
  2. Developing .NET application with embedded SPL routines using Microsoft Visual Studio

The session will also showcase one of the new features of Informix 11.70 — SPL debugging. Informix users can learn about how to setup the two different environments from scratch to develop, debug and tune their SPL applications. The session will also introduce the users to the various constructs that the Informix Stored Procedure Language has to offer.


Fastest Informix DBA Tutorial and Lab — Lester Knutsen

A hands-on database benchmarking tutorial performing the Fastest Informix DBA contest from 2010. This contest was an OLTP benchmark using the Benchmark SQL Java program to generate 100 sessions doing inserts, updates, and deletes against a database. BenchmarkSQL is an easy to use JDBC benchmark that closely resembles the TPC-C standard for OLTP. The Java code was converted to run with Informix by AGS, the folks that created ServerStudio. The challenge will be to get the most transactions per minute during a 10-minute benchmark run. This will be a step by step review of the performance tuning options and configurations that the winners used and how you can use these tricks in real life.

Each participant should bring a laptop with the Informix virtual appliance so we can go through the contest together.

The download is free on the IBM website.

Informix 11.70 Developer Edition SLES 11 virtual appliance demo (Developer Edition 32 bit) VMware Workstation, self extracting executable InformixVA-11.70.UC1-DE-SLES11-x86_32.exe (2.6 Gb)


SUNDAY ALL DAY TUTORIAL 8:30 AM - 4:30 PM Includes both continental breakfast 7:30 am - 8:30 am and lunch 12:00 pm - 1:00 pm


Troubleshooting 11.7 — Hyun-Ju Vega, Mark Jamison, Ron Privett, Darin Tracy

This pre-conference tutorial will focus on sharing troubleshooting techniques that will assist clients in debugging issues on Informix 11.7. Areas of focus will include Isolating Problems, Performance, RSS/SDS, Memory and Backup/Restore.

© 2011 International Informix Users Group.   All rights reserved.