IIUG Insider (Issue #268) November 2022

Highlights: IIUG Sale – Purchase the Informix 14.10 Exam for $49.99 US

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.


The IIUG board consists of ten members: one IBM rep (who does not stand for election and nine elected members.

There were nine seats available for the election that was to start on November 28.

However, there were only eight candidates, so we do not have to hold an election.

We would like to thank Lester Knutsen and Ognjen Orel, who are not continuing, for the great work and their huge contribution.

We are welcoming our new members Tom Beebe and Henri Cujass.

The 2023-2024 board members are:

Cindy Lichtenauer

Stuart Litel

Members (by alphabetical order)
Tom Beebe
Gary Ben-Israel
Henri Cujass
Rhonda Hackenburg
Art Kagel
Vicente Salvador
Bruce Simms

To learn more, visit the IIUG Board of Directors page.

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors


IIUG Sale – Purchase the Informix 14.10 Exam for $49.99 US

We are running an end-of-the-year sale price for the Informix 14.10 Exam.

Purchase the exam by the Midnight December 31, 2022, EST, for $49.99 and take up to 90-days to schedule and complete your exam.

Once you have successfully completed your exam you will receive your Badge from IBM to use on you resume, email signature or wherever you what to promote your Informix skills.

Click here to purchase your Informix 14.10 exam or learn more.

Rhonda Hackenburg
IIUG Board of Directors

Informix Corner

Informix Tech Talks on YouTube

Upcoming Informix Tech Talks

Title: Washington Area Informix Users Group Meeting
Date: Thursday, December 8, 2022
Time: 9:00 am EST

The next WAIUG meeting will occur virtually on Dec 8th, 2022. It will be an exciting set of technical talks from presenters with the developers of Informix from HCL as well as user speakers. Topic descriptions will be posted shortly.

Presentations by:

  • Art Kagel – Doing Storage Better – Exploring the best and worst options
  • Shubham Kapoor – Informix HQ
  • Mike Walker – Explaining Explain Plans
  • With additional information on the Informix 14 Badge Exam

If you are new to the WAIUG, we are a free community drive user group focused on educating and sharing experiences for Informix users of all skill levels and backgrounds.

Register Here

For additional information visit www.waiug.org

Rhonda Hackenburg


Past Informix Tech Talks Replays

All Informix Tech Talks replays are available at: https://www.iiug.org/en/category/techtalks/

And on YouTube at: https://www.youtube.com/c/InformixTechTalksbytheIIUG

Replay of the last Informix TechTalks: Informix 14 – A Features Review of the Entire Release by Carlton Doe and Scott Pickett


Informix Tech Talks YouTube Channel

We now have 314 subscribers to our YouTube channel.
We have 85 videos on YouTube on our Channel.
Our Channel has received over 7,451 views so far!

Informix Tech Talk YouTube Channel Videos

Past Informix Tech Talks Replays

Lester Knutsen


In Search of Tech Talks Speakers

We are looking for additional speakers and especially any new speakers to share your Informix knowledge with our user Community via the IIUG Tech Talks. We will assist you in preparing for your Tech Talks presentation by prerecording your session. This will allow you to be available to answer any questions that come up in the chat during you presentation.

If you are interested in producing a 15 – 45-minute presentation, please contact either Bruce Simms or Rhonda Hackenburg for additional information.

Rhonda Hackenburg
IIUG Board


Informix Training

Free Informix Tutorials Videos – a step by step approach to using Informix Database Servers are available at https://advancedatatools.com/tech-info/informix-tutorials/

Lester Knutsen


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.


Smart Trigger API for Java to monitor smart trigger session changes at the backend DB


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

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: 88 (+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

Inner Join 

Informix 11.5 and Server 2012R2 – Database stuck in Quiescent Mode

Backup from InformixHQ and continous log backup

Better performance with temp dbspace in RAM disc?

14.10 – direct flooding “Network driver cannot accept a connection on the port”

shmget: [ENOSPC][28]: key 525f4802: The server could not allocate shared memory because an operating system limit was reached

Where can I download ESQL/COBOL

Origina IBM Support


Gary Ben-Israel

Informix Resources

IIUG Website

Not a member, become an IIUG member and keep updated on all things Informix. It’s free.

IBM Informix Community

Not a member, join The IBM Informix community and connect with other Informix data experts.

IBM Informix RFE

Informix Requests for Enhancements.

Technical Articles



Over 10 Years of Informix Webcast Replays

Over 30 Years of Informix Blog Posts

Social Media

YouTube LinkedIn Twitter Facebook

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 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

Leave a comment

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