Category Archives: WAIUG

Free Informix Technical Workshop New Features and Multi-tenancy – June 25 2015

Share Button

Save the date!
Thursday, June 25, 2015
9:00 to 3:00
Light breakfast refreshments starting at 8:30
Lunch will also be provided

Location: IBM Office – 8401 Greensboro Drive, Suite 120, McLean, VA 22102

Presenter: Carlton Doe, IBM Informix Database Specialist and author of “Administering Informix Dynamic Server: Building the Foundation”

Carlton will update the latest features from Informix version 12.10.FC4 and FC5, along with a hands on lab/tutorial on multi-tenancy.

This will be a free 1 day technical workshop and hands on lab.

Register Here:!/wiki/North%20America%20Informix%20Events

*** There is good news and bad news about the IBM TEC Center in McLean, VA.

The bad news – parking now costs $10.
The good news – there is now a metro stop 2 blocks away. The Spring Hill Metro Station on the new Silver Line is a 5-10 minute walk from the IBM TEC center.

WAIUG Meeting Dec 11 2014 Registration

Share Button

Please join us for the next Washington Area Informix User Group meeting, Thursday, Dec 11, 8:30 AM – 12 Noon at the IBM office in Washington DC.

This event will feature content rich presentations by leading Informix Users and experts that will most certainly touch on aspects of the Informix software features that you are using and may be interested in.

– Art Kagel, Independent consultant and IIUG Board Member, will present on programming, concurrency, and tuning applications against Informix
– Carlton Doe, IBM Informix Database Specialist, presenting on Informix Flexible Grid
– Tom Beebe, Advanced DataTools consultant and IIUG Board Member, will speak about running Informix on the ARM architecture

Date: Thursday, December 11, 8:30 – Noon
Location: IBM, 600 14th St NW, Washington DC

There are 2 metro train stations very close by. Metro Center is 2 blocks to the East and McPherson Square is 3 blocks to the North. There are also pay garage parking alternatives in the close vicinity.

The start time will be 8:30 (doors open at 8:00).

Please RSVP Below:

Your Legal Name (required)

Your Email (required)


Job Title






Interests or Comments

Please Enter The Following Text To use CAPTCHA, you need Really Simple CAPTCHA plugin installed.

Submit your registration

The IBM Internet of Things and Informix 2014 Spring / Summer Roadshows are coming to a city near you!!

Share Button

Registration is now open for two new FREE technical Roadshow events being held through North America.
The first is for anyone interested in the next wave in data processing. Generally referred to as “The Internet of Things”, it represents a massive change currently occurring throughout the IT landscape. Unstructured data is flooding into the enterprise and everyone is struggling with how to manage it. While NoSQL offers the ability to have dynamic elasticity with data and its organization, these databases lack essential elements common to enterprise class databases such as scalability, security, flexible deployment, transaction support and full data integration. Today, IBM offers a solution that can natively handle NoSQL and structured data simultaneously providing a single system with the seamless integration of all data within the enterprise. During this event, you’ll gain insight and hands on experience with IBM’s solution that permits NoSQL and structured data to coexist and be used simultaneously in an enterprise class system.

The second event is oriented specifically for Informix customers, this day is for those interested in learning about the full spectrum of Informixbs storage management and efficiency technologies. You’ll gain hands-on experience with dynamic and manual expansion of storage spaces. You’ll compress, repack and shrink data and indexes to see how these functions contribute to faster SQL performance. You’ll learn about proper space planning and sizing for maximum efficiency, database backup deduplication, and much, much more.

For more information, refer to the attached invitation or go to the registration page at

Washington DC will be July 24th and 25th 2014

Our next Washington Area Informix User Group Event

Share Button

Free Informix Technical Workshop

  • Date: Friday, March 21, 2014, 9:00am to 5:00pm
  • Location: IBM Office – 8401 Greensboro Drive, Suite 120, McLean, VA 22102
  • Continental breakfast and box lunch will be served

Presenter: Carlton Doe, IBM Informix Database Specialist and author of “Administering Informix Dynamic Server: Building the Foundation”

One of the hottest marketing buzzwords in the IT industry today is NoSQL where data is manipulated without the constraints or rules typically associated traditional database systems. Informix now has NoSQL / JSON capabilities built into it. But it’s more than just the ability to store and retrieve these new objects, with Informix, the objects can be used in conjunction with other objects in traditional or objected oriented format. For example, Informix can use TimeSeries, regular data and NoSQL in a single operation!

Carlton is working on a new class focused on NoSQL integration into Informix. He’s agreed to present it in our next meeting though the class isn’t in its finished form.

This will be a free 1 day technical workshop covering features and enhancements and hands on labs.

Please register here -> Registration

Next Webcast for Informix Users

Share Button

The Washington Area Informix User Group along with Advanced DataTools Corporation has been hosting a series of Webcast for Informix Users.

Next Webcast! Informix Performance

Click here to Register

Click here for Past Webcast Replays

Informix 12.10 Roadshow

Share Button

A free day-and-a-half, technical event by IBM for Informix Users, designed to give you insight into the proven IBM® Informix® technology that solves some of the toughest business problems in the world today. This roadshow is designed to help you understand the many new features and enhancements in the Informix 12.1 product — the beginning of the next decade of Informix technology!

A partial agenda includes:

  • Enhancements to Informix Warehouse Accelerator
  • New functionality for ER and H/A clusters
  • Increased autonomic administration capabilities
  • New SQL functionality including OLAP queries
  • New features and performance with Informix TimeSeries
  • New backup/recovery technology
  • Expanded compression and associated features
  • The Informix Hypervisor Edition
  • and More!!!

Each day will begin at 9:00 A.M. Breakfast and lunch will be provided on the first day. On the second day, only breakfast since class will be over before noon.

Informix Performance Tuning Technical Training Day – Thursday, November 8th 2012

Share Button

The Washington Area Informix User Group hosted a one day Informix Performance Tuning Technical Training Day.

Morning Session – Special Guest – Scott Lashley, Kernel/Performance Architect, IBM Informix IDS Portland, OR

Scott is the IBM Informix Dynamic Server (IDS) Kernel/Performance architect. Starting with Informix Turbo and the implementation of blobs, Scott has been actively developing Informix database engine technology since 1987. Scott was the kernel architect for Informix XPS, Informix’s shared nothing architecture database product. Scott spent a few years helping IBM DB2 LUW by leading the HADR project before returning to Informix IDS for the IDS Cheetah release. Scott’s passion is on developing technology to help reduce the human cost of maintaining the IDS database engine with emphasis on self tuning and self maintaining algorithms along with continuing to improve transaction and query performance. Scott’s current focus is on accelerating query performance using main memory techniques. Scott has a BA in Computer Science and Religion from Mt. Vernon Nazarene University, Mt. Vernon Ohio. Plus, Scott referee’s 350+ adult recreational basketball games a year.

Some of the topics Scott will cover include:

  • Query Processing
  • Indexing
  • Diagnostics
  • Storage Enhancements
  • Networking
  • And More ….

Afternoon Session – Informix Performance Tuning by Art Kagel and Lester Knutsen, Advanced DataTools Corporation

We will cover some of the tips and tricks from our Fastest Informix DBA Contest held at the last IIUG conference. The goal of the contest was to see who could optimize an Informix database server running 1,000 OLTP users in under one hour and generate the most transactions per minute.The Grand Prize Winner of the new Apple iPad and the Fastest Overall Informix DBA was Andrew Ford. Andrew’s results were almost three times faster than the next closest contestant’s results. Andrew generated over 57,000 transactions per minute.

Washington Area Informix User Group TimeSeries Hands on Lab

Share Button

The last Washington Area Informix User Group event was a one-day Hands on Lab on the Informix TimeSeries technology that is being used in the IBM Smarter Planet initiative with Metering Data and Smart Grid.

Informix is a market leader in the integration of what are called “extensibility” features that enable the database architect to natively create, store, and manipulate complex User-Defined Data Types (UDTs) with User-Defined Routines (UDRs) as though they were built-in data types in the database engine. With this capability, Informix can solve very complex problems with simple SQL statements. As a result, Informix is the perfect database engine to help create a Smarter Planet.

This lab will expose participants to one of these extensibility features — the Informix TimeSeries technology. A “time series” is any set of data that is accessed in sequence by time and can be processed and analyzed in a chronological order. Informix TimeSeries can be used in financial, scientific, utility, manufacturing, and other industries where data is captured over time and needs to be analyzed quickly and easily. Informix introduced some enhancements in the Informix 11.70.xC3 release and this lab will be based on that release.

In this Proof of Technology, participants will get hands-on with Informix TimeSeries technology to create and use regular and irregular times series, containers, calendars and more. Data will be loaded using Informix TimeSeries Virtual Tables and a bulk load routine. The student will use several Informix TimeSeries functions to hide/reveal data, perform complex calculations and more. Finally, participants will use an application that combines Informix TimeSeries and Informix Spatial technology to track vehicle movement as well as location and condition exceptions within a vehicle fleet.

User Group 2011 Technical Roadshow

Share Button
Date – December 1 and 2, 2011 9:00am – 5:00pm
Location – IBM, 600 14th St NW, Washington DC

Folks, we had a great User Group meeting and lab by Scott Pickett, IBM Informix Worldwide Technical Sales lead. He lead us through the presentations and hands on labs on the new features in Informix 11.70. This was a great opportunity to try out the new version and learn the latest features.

Link to Download the Presentations

FREE Technical Training and Information for Informix Users

What is the Informix Technical Roadshow? The 2011 Informix Technical Roadshow is a two-day, deep-dive technical event that gives you hands-on experience with the latest IBM® Informix® releases and Informix Warehousing technology. This roadshow is designed to help you gain fresh, innovative ideas for optimizing your business performance and creative competitive advantage – and it is absolutely free to attend these events.

The Roadshow topics include:

  • Latest features of IDS 11.70 Flexible Grid
  • Technology Storage Provisioning
  • Time Series
  • Smart Metering
  • Informix Warehouse Accelerator Autonomics