IIUG Insider (Issue 278) September 2023

Highlights: IBM is Looking for Informix 15 Beta Testers


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.


IBM will have a TechXchange in Europe early 2024.

Unlike Think, TechXchange is a technical conference, there will be 15 sessions selected by the IIUG Board.

Seven will be Informix sessions and 8 sessions that are of interest to Informix users. The IIUG Board will take part in the registration process and will offer up to 40 free conference passes.

Stay tuned!


Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors




IBM is Looking For Informix 15 Beta Testers

IBM is accepting applications from customers who want to participate in the first beta test of Informix 15.

You can be among the first to review Informix 15.  This is your opportunity to provide valuable feedback as you help IBM review the next release.

Testing should begin around October 18, 2023.

To be considered for this opportunity, you will be required to have a corporate email address. This email will be used by IBM to perform their export check to clear you for behind-the-scenes access to Informix 15.

If you want to submit your request to become an Informix 15 beta tester or would like additional information, please contact Scott Pickett at spickett@us.ibm.com.


Scott Pickett



Informix Corner

TechXchange Conference EMEA in Barcelona 2024 – Registration Opening Soon

Title: IBM TechXchange Conference EMEA 2024: Community & Learning for Tech Experts

Date: 22-25 January 2024

Location: CCIB – Centre de Convenciones Internacional de Barcelona, Barcelona, Spain

NOTE: There is no registration cost for this event.  IBM is providing the IIUG with a maximum of 40 IIUG members to attendees.  Please stay tuned for more details on IIUG membership registration opportunities.

Rhonda Hackenburg
IIUG Board



Informix 14.10 and CSDK 4.50 Latest Drops are Available

A new PID of the 14.10 server and the 4.50 client is now out on Fix Central as of September 28th, 2023.

Highlights of 14.10.xC10W1 and 4.50.xC1W1:

  • Both have upgraded installers which now allow us to officially certify these new PIDs and subsequent releases of 14.10 on Windows 2022 (APAR IT41511).
  • The Informix Warehouse Accelerator (IWA) has a fix for Red Hat 8.5 compatibility (APAR IT41190).
  • GSKit has now been upgraded to in both Server and Client
  • The Java version has been updated to Java

As a reminder, the Beta program is starting soon for vNext and if you are interested, let us know! Contact Scott Pickett (spickett@us.ibm.com) if you are interested.

Karen Qualley


Informix Tech Talks on YouTube

Upcoming Informix Tech Talks – October 26

Title: Proving Stuff with Informix Internals

Speaker: Mark Scranton

Date/Time: Thursday, October 26, 2023, 2:00 PM EDT

Description: Mark will use internals to prove concepts and fundamentals of IDS, including staples as well as some new features.

Register for Proving Stuff with Informix Internals


Last Informix Tech Talks Replay

Replay of the Last Informix Tech Talks: August 24, 2023:  Informix and OneDB, Paul Watson


Informix Tech Talks YouTube Channel

Our YouTube Channel now has:

  • 423subscribers (12 subscribers since last month)

  • 100 videos

  • 12,828 views (476 new views since last month)

Informix Tech Talks YouTube Channel Videos

Past Informix Tech Talks Replays


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/


RFE Corner

IBM has an RFE – Request For Enhancements website.

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




For the -12.. Conversion errors, please specify the column name.

Create an InformixHQ sensor to obtain the slowest queries directly from InformixHQ repository instead local SQLTRACE on the instance..

Create an InformixHQ sensor to obtain the slowest queries directly from InformixHQ repository instead local SQLTRACE on the instance..


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

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

Created: December 24, 2018

Status: Future consideration

Gary Ben-Israel
IIUG Board



IBM Informix Forum Corner

Join and visit the IBM Informix community forum

Recent Posts

Innovator-C on AIX

onsmsync used to recycle backups : how effective is it?

Smart BLOB 16359 bytes, w/ ref count = 1, yet apparently not used by any table        

Mirroring plogspace?

Fragmentation problem


Gary Ben-Israel
IIUG Board


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.


Informix Blogs ans Wikis

Andrés Repossi https://andreserepossi.wixsite.com/hablemosinformix (In Spanish)


Technical Articles



Over 10 Years of Informix Webcast Replays

Over 30 Years of Informix Blog Posts


Social Media

YouTube LinkedIn X (Twitter) Facebook


Forums, Groups, Videos, and Magazines

The IIUG old forums at http://www.iiug.org/forums/technical.php *** NO LONGER ACTIVE ***

Informix Marketing channel on YouTube http://www.youtube.com/user/informixmarketing?feature=results_main



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 *