IIUG Insider (Issue #283) February 2024

Highlights: IBM Informix: What’s New and What’s Upcoming


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.


It is harder to set up a physical conference these days. 

The second best we have to offer is our Tech Talks on YouTube. 

Our 104 videos have already 15,902 views. We have 468 subscribers. 

You do not need to be a subscriber in order to view the videos. 

But we recommend you subscribe and get notified when a new video is posted. 

In addition, it demonstrates the strength of our community. All it takes is one click on the subscribe button. 

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors



IBM Informix: What’s New and What’s Upcoming

Date/Time: March 28 @ 11:00 am EDT 

The IBM Informix database serves as the foundation for thousands of applications and billions of devices worldwide. IBM is fully intent on investing in the future of IBM Informix with the next major release planned for launch in the first half of 2024. With the next major release of IBM Informix, IBM plans to redefine data scalability, enhance engine capabilities, and refine database administration to ultimately boost database performance. 

Hear from the IBM Informix Product Management team and IIUG about new capabilities in IBM Informix v14.10 and why you should upgrade to access better performance, scalability, operational efficiencies, and watsonx AI integrations in the upcoming major release, Informix v15. 

Learn new capabilities in IBM Informix v14.10 and why you should upgrade 

Learn new capabilities in the upcoming major release – Informix v15 

Learn about integration with watsonx.data for AI   


Key speakers:

Shripad Sonavnay 
Principal Product Manager, GTM – Db2 & Informix 

Carlton Doe
Executive IT Specialist – IBM Informix, IBM Data and AI 

Register Here 




Conference Corner

Informix Technology Days

Title: IBM TechXchange Informix Technology Days


March 13, 2024 9:30 a.m. – 6:00 p.m. Lectures

March 14, 2024 9:00 a.m. – 12:00 p.m. Hands-on labs

Location: Munich, Germany

At the IBM TechXchange Informix Technology Days in Munich, users of Informix databases systems will have the opportunity to learn about new features and about best practices for the successful operation of Informix. There will be presentations for developer and administrators. Customers and partners will have the opportunity to network with each other and ask all their questions directly to the experts from the lab, support, and product management.

For more information or to register: https://www.iiug.org/event/informix-technology-days/

There is no cost to attend this event!


IBM TechXchange Conference Las Vegas, NV, USA

Title: IBM TechXchange Conference 2024

Date: October 21-24, 2024

Location: Mandalay Bay – Las Vegas, NV, USA


Be in the know about the latest tech, certifications, education & AI trends.

Join us to gain industry-leading skills, get a first look at the latest product roadmaps, engage in hands-on experiences, earn industry-leading credentials, network with thousands of peers, and hear from the best and brightest minds working in tech today. Discover what’s to come in your area of focus. 

For additional information IBM TechXchange Conference 2024.



The IIUG is Still Gathering Speaker Interest for a 2024 Informix Event

As mentioned in last month’s Insider, the IIUG has begun discussions regarding our next event.  It is never to early to start thinking about topics you might want to share with the Informix community.  You can present topics on Informix or products or technology that work with Informix. As always, presentations are approximately 45-minutes in length.

If you think you are interested in presenting for the IIUG in 2024, please submit your name, and topic (if you have one) to rhonda@iiug.org. If you need help with a topic, we are always here for you.  Your participation as speaker will help guide the direction and format of our next event.

Keep following the IIUG Insiders, updates.

Rhonda Hackenburg
IIUG Board, Planning Committee


Informix Corner

A message from IIUG Board Member Vicente Salvador

Greetings, Informix Community!

Last month marked an important Informix Board of Directors meeting, where we witnessed significant collaboration among our esteemed board members – Cindy Lichtenauer (President), Tom Beebe, Gary Ben Israel, Henri Cujass, Rhonda Hackenburg, Art Kagel, Bruce Simms, me and our new IBM representative Carlton Doe.

Working with Carlton is a real pleasure and I appreciate the opportunity to work with one of the better Informix community representatives in the world.

I was excited to have IBM TechXchange Summit EMEA in the town where I live: Barcelona. I’ve let some time pass and to calm down to write this post with more brain and less heart.

A primary focus of our meeting was setting the objectives for the next Informix release and how we can proxy our community requirements thru IBM management. The board engaged in several in-depth discussions to ensure that IBM takes proper care of Informix and I’m happy to announce, for first time in the last several years, we received promising feedback from IBM managers.

IBM Informix is healthy and more and more users are buying Informix each year. IBM realizes that it should care about its current user community.

Proof of this is the Informix presence at IBM TechXchange in Barcelona and also Informix content for next IBM TechXchange in Las Vegas October 2024.

We will see if all this work materializes into fact, but expectations are better than in previous years.

Also, we had a lot of discussions about the next Informix release and its exciting enhancements. New embargos are still active regarding the next release, but we can share this is an ongoing process and it will be really impressive.

Finally, a personal thought, I’m very glad to meet all the Informix users coming from Europe who attended Informix sessions. This is something nice, as I know most of them but I didn’t have many opportunites to talk personally about informix in the last several years. Also, my best gratitude to all Informix users traveling from outside Europe to attend this event. It was really a pleasure.

Hope to see you soon October 2024 in Las Vegas.

Vicente Salvador
IIUG Board of Directors


Schedule Your Informix 14.10 Exam Today

The Informix 14.10 Badge exam is still available!

The exam will be administered online. You are required to complete the exam with a proctor from our approved list, or nominate one of your own, to be approved by IBM or the IIUG Board. You will be required to have a live webcam running as you complete the exam.

For those not familiar with the term Proctor: 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 ensure academic integrity guidelines are followed during the exam. 

Click here to learn more or schedule your exam.


Informix Tech Talks on YouTube

Upcoming Informix Tech Talks

In lieu of our March Tech Talks, we want to encourage everyone to attend the IBM Presentation “IBM Informix: What’s New and What’s Upcoming”.

Date: March 28, 2024

Time: 11:00 am EDT

See “Highlights” section of the Insider for more information and to register.


Last Informix Tech Talks Replay

Replay of the Last Informix Tech Talks: WAIUG Meeting, December, 2023: 


Informix Tech Talks YouTube Channel

Our YouTube Channel now has:

  • 468 subscribers (11 new subscribers)

  • 104 videos

  • 15,902 views (626 additional views)

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 Art Kagel 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.



InformixHQ – heatmap – feature 

 LOAD data in batch mode with DATASTUDIO 

Improve Ontape Point-in-Time Restores for Tables 



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

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

Assert Warning: Memory block header corruption detected in mt_realloc 2 

Find table accessing information 

What is dbsname BEFIMAGE? 

14.10.FC10W2 download 


Informix Client SDK 4.10.TC16 Windows 64 only installing as 32 bit 

The next IIUG Tech Talk: 

Syncing data using cdr sync


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.


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 *