IIUG Insider (Issue #234) January 2020


Highlights: IBM CEO Ginni Rometty is stepping down, Arvind Krishna to take over

Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.


1) Editorial

2) Highlights

  2.1 IBM CEO Ginni Rometty is stepping down, Arvind Krishna to take over

3) RFE Corner

4) Informix corner

  4.1 IIUG Announces First in Series of Worldwide Informix Tech Day Events to take place in India

  4.2 February 2020 Webcast – Easy Replication from On Prem to Cloud

  4.3 Coming in 2020 – Free Informix Tutorials Webcast Series!

5) Events

  5.1 IBM Think 2020 – San Francisco

6) Informix Resources

  6.1 Informix Blogs and Wikis

  6.2 Social Media

  6.3 Forums, Groups, Videos, and Magazines


My dear friends at the IIUG.

This editorial is personal.

After 27 years as CIO at the National Institute for Testing and Evaluation I am retired.

Informix will still be a major part of my professional life.

I will continue working as an independent consultant doing Informix database administration and database architecture.

I will continue contributing to Informix and the Informix user community as a board member the Insider editor and an active IIUG member. Having more free time I will do much more helping you guys and Informix. So feel free to contact me and I’ll do my best to help as I always did.

Looking forward to this new phase in my life.


Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors


IBM CEO Ginni Rometty is stepping down, Arvind Krishna to take over


When the IIUG board first met Arvind he was a VP in charge of databases under Ambuj Goyal who was the director of data management.

For many years, Arvind always supported Informix and the IIUG. In his new role, Arivind will not be dealing with specific products, but it is good to know that the CEO of IBM is someone who knows and appreciates Informix and has been a friend and supporter of the IIUG board for many years.

We all wish him luck and success in his new position.

Gary Ben-Israel

RFE Corner

IBM has created a new RFE – Request For Enhancements website.


Please visit this site to vote for your favorite enhancements and place new requests.

As you can see, it is a new RFE site. It is friendly and has a nice look and feel.


Informix HQ monitoring of raw disks

At the moment the Informix HQ product tries to monitor the storage using a “df -k” command

This will not work though when Informix is running on raw disks.

Votes: 1

Created January, 23 2020

Status: Needs review

Defragment for a dbspace

Add at the ‘DEFRAGMENT’ SQL Api , the option to defragment an entire dbspace.

We have set in our environment tables and partitions with historical data, so, they are tables or partitions who have any changes (include/excluded data).

Most of them are set in the same dbspace and from time in time, we remove the oldest, opening a few gaps of free space over the firsts chunks of the dbspace. These dbspace are made of few chunks and we want to move all data to the firsts and remove the last chunks to recover disk space.

Votes: 1

Created January 10, 2019

Status: Needs review

Popular (Over 50 votes)

Backup from RSS or HDR Secondaries using ontape, onunload, onbar, dbexport

In HDR environments, being able to backup or export databases from and HDR, HDR read-only, or an RSS secondary server is critical. Programs like ontape, onunload, dbexport, and onbar generate locks on tables during backups and data-exports. This creates problems while applications and users using Informix try to use the system during backups in 24 x 7 x 365 production environments. Being able to backup or export data on secondary systems is critical for compliance and backup integrity.

Votes: 93

Created: December 24, 2018

Status: Future consideration

Obtain the query plan of a running query

Many times a DBA is called to check upon a slow process. Most of the times those processes are running a slow query.

Sometimes it’s hard to know if the query is using the best query plan or not. A DBA can reproduce the query, but it it was prepared without values or if the statistics were changed after it started there is no guarantee that the query plan seen by the DBA is the same as the running query.

We have “onstat -g pqs” which sometimes can give us a clue, but it’s mostly cryptic and undocumented. If a user has X-Windows he can try xtree, but it’s a bit strange for todays standards.

We also have SQLTRACE, but if it was not set when the query was launched it will not capture the info (and besides, due to the circular nature of the buffer it may not be there at the time we need it).

A simple pseudo-table in sysmaster could probably implement this with ease.

It could also be extended to support the “last” query plan making it easy to get the query plan in any tool

Votes: 79

Created: December 24, 2018

Status: Future consideration

Backup Individual database, not entire instance

Need a mechanism, similar to ontape, to backup a live database (as opposed to entire instance), without locking it.

Votes: 65

Created: December 24, 2018

Status: Future consideration

Informix should be able to change owner on tables and any other objects

If user=informix creates all database and all tables, then programmer creates table but user=informix cannot change it. Only drop it.

Votes: 63

Created: December 24, 2018

Status: Future consideration

Gary Ben-Israel

Informix corner

IIUG Announces First in Series of Worldwide Informix Tech Day Events to take place in India

The IIUG is excited to announce the first in a series of Worldwide Informix Tech Day Events.

The IIUG will be coming to you in 2020!

The first two locations are:

March 24 – Bengaluru, India

March 26 – Chennai, India


Take control of your data, gain new insights from it, and drive digital transformation and innovation across your business! Come spend a day with the IBM and HCL Informix teams during this technical exchange covering the unmatched capabilities of Informix. Learn new ways to deliver significantly greater business value and operational efficiency from our experts.

Clients and partners interested in IBM Informix, or looking to address data management challenges, are invited to this event.


4.2 February 2020 Webcast – Easy Replication from On Prem to Cloud

With minimal or zero downtime to your applications, with simple command or using a phased approach, automate data migration across operating systems/platforms, setup replication between on-prem Informix instance to a cloud database instance.

Nagaraju Inturi

Software Engineer

HCL Software


4.3 Coming in 2020 – Free Informix Tutorials Webcast Series!

Advanced DataTools are pleased to announce a 2020 Webcast series for Informix DBAs: “Informix Tutorials”. They will discuss configuration, disk layout, backups, performance tuning, and high availability disaster recovery implementation. The Informix Webcasts are based on over 30 years of experience managing and tuning database systems. The webcasts will be presented by Lester Knutsen, Art Kagel, Tom Beebe, and Mike Walker – all IBM Informix Champions from Advanced DataTools.

You will need to register for each Webcast separately.

For more information – https://advancedatatools.com/tech-info/next-webcasts/


IBM Think 2020 – San Francisco

May 4, 2020 – May 7, 2020

Moscone Center – SF, 747 Howard St
San Francisco, CA 94103 United States + Google Map

Find out more »

Informix Resources

IIUG website

IBM Informix community

6.1 Informix Blogs and Wikis

Blogs and Wikis

Social Media

Linkedin: https://www.linkedin.com/groups/25049

Twitter : https://twitter.com/iiug

Facebook : https://www.facebook.com/IIUG.Informix

6.3 Forums, Groups, Videos, and Magazines

Closing and Credits

The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG’s membership database now exceeds 25,000 entries and enjoys the support and commitment of IBM’s Information Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.

Sources: IIUG Board of Directors

IBM Corp.

Editor: Gary Ben-Israel

For comments, please send an email to gary@iiug.org

Leave a Reply

Your email address will not be published. Required fields are marked *