IIUG Insider (Issue #255) October 2021

Highlights: View the Informix IIUG World 2021 Virtual Conference opening keynote by Arvind Krishna, Chairman and Chief Executive Officer of IBM.

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.


Our world is becoming virtual. We had a virtual conference, we are having a virtual board meeting, more server farms and databases are in the cloud, more people are working from home.

Is this a phase? Will we be back to face to face meeting or is this our new reality.

I miss meeting people in person. I hope our 2022 to meetings and conferences will be physical.

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors



IIUG World 2021 Virtual Conference Opening Keynote by Arvind Krishna, Chairman and Chief Executive Officer of IBM

Arvind Krishna delivered a great keynote to the IIUG World 2021 attendees. You can view it on the IIUG YouTube channel. Don’t miss it.

I will just quote Arvind’s closing sentence. “Informix will outlive all of us”. Coming from IBM’s Chairman and CEO this is a powerful statement.


Conference Corner

IIUG WORLD 2021 – Recap

Our first ever virtual technical event is now history. We had many participants who were able to enjoy three days of great content from their homes or offices around the world. Including 2 keynotes, over 30 sessions, one session on Informix Strategy, Roadmap and Licensing and one session to “Ask the Experts”, as well as several Sponsor sessions.

The IIUG Board and Planning Committee would like to thank all of our attendees, sponsors and especially our speakers who helped make this a success. Special thanks to Carlton Doe and Scott Pickett for their Informix Badge Preparation Training tutorials to help the Informix Community prepare for the NEW Informix certification exam.

We are looking forward to IIUG World 2022. Will it be another virtual event or back to an in-person event? Maybe it could be a hybrid event, offering the best of both worlds. Time will tell.

For those of you who attended IIUG World 2021, you should have received an email to complete a short survey to provide your feedback. These are your events and we strive to provide a quality event each year.

Rhonda Hackenburg
Planning Committee
IIUG Board Member

Informix Corner

Registration for the New Informix Certification Exam is Ready!

The IIUG has finalized the requirements needed to complete the NEW Informix 14.10 Certification badge.  The test is now available!

There are two options to complete the exam:

  1. You were a paid registrant to IIUG World 2021. Paid registrants to IIUG World 2021 received a complementary one-time exam with a paid registration.  You have until January 31, 2022 to complete your complementary exam.
  2. Pay $150 fee to take the exam. Exams must be completed within 90 days after purchase The $150 dollars is non-refundable.   You will receive an email with a confirmation code with your payment. PAY HERE

To begin the exam registration process, email either your IIUG World registration code or your exam confirmation code to Stuart Litel (slitel@ibm.com). He will work with you to schedule your exam.

If you missed IIUG World 2021, you missed the Badge Preparation Tutorials offered by Carlton Doe and Scott Pickett.  It is not too late: we will be offering replays for a nominal fee of $100 for both replays:

  • November 22, 2021 8:00 AM EST Informix Badge Preparation Training – Part One – Carlton Doe
  • November 29, 2021 8:00 AM EST Informix Badge Preparation Training – Part Two – Scott Pickett

Tutorial Replay Registration

The exam will be administered online. You are required to complete the exam with a proctor from our approved list, or nominate your own.  You will be required to have a live webcam running as you complete the exam. (For those not familiar with the term Proctor: The word proctor is frequently used to describe someone who oversees an exam. In today’s testing environment, a proctor will typically verify a student’s identity by checking a photo ID and then ensures academic integrity guidelines are followed during the exam.)

You will have 90 minutes to answer 60 questions. You must achieve a 72% to receive you badge.

If you have any questions, please contact conference@iiug.org

Rhonda Hackenburg
Planning Committee
IIUG Board Member

The PDF documentation set for Informix v.14.10.FC6 is now available

Great news!! The PDF documentation set for Informix v.14.10.FC6 is now available for download from the Library section of this community. The direct link is here!

Thank you to HCL for producing this set and making it available to the Community.

Carlton Doe

Informix Tech Talks on YouTube

222 subscribers, 21 great videos. Subscribe to our channel and enjoy great content.

All Past Tech Talks:

RFE Corner

IBM has an RFE – Request For Enhancements website.


Please visit this site to vote for your favorite enhancements and place new requests. It is friendly and has a nice look and feel.


Uphold Helpline Number {1-815-940-2323} Uphold customer service support number

Online index rebuild

Uphod {1-815-940-2323} Uphold wallet Support Number Uphold wallet customer service Helpline number

+1(815) 680-0302 Uphold Toll Free Number Uphold Support Number

cdr migrate should allow code-set migration

Popular (Over 50 votes)

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: 98 (+0)

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: 91 (+1)

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: 84 (+0)

Created: December 24, 2018

Status: Future consideration

Gary Ben-Israel

IBM Informix Forum Corner

Join and visit the IBM Informix community forum at http://www.iiug.org/community

Recent posts

IIUG World 2021 Keynote by Arvind Krishna

For archecker gurus: how do I restore a sequence using archecker ?

how to from informix sbspace

Gary Ben-Israel

Informix Resources

IIUG website

IBM Informix community

Informix Blogs and Wikis

Please note: The list below contains only blogs that were active in the last six months.

Technical articles



Social Media

YouTube: https://www.youtube.com/c/InformixTechTalksbytheIIUG

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

Twitter : https://twitter.com/iiug

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

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.


Editors: Gary Ben-Israel, Rhonda Hackenburg

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

Categorized as Insider

By Vicente Salvador

Board member since 2014, a user since 1989 and Informix fan. I'am software architect which allow me to combine technical and business skills.