Highlights: Informix 15.0.1 is available now; Find out what’s new!
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.
Table of Contents
Editorial
Informix 15.0.1 is finally released. Read the highlights and find out more about it. We are expecting more releases and more new features keeping Informix the best OLTP database.
If you know Informix users that are not IIUG members encourage them to join. If you are an IIUG member and are interested in joining the IIUG Board of Directors, please note that elections for the IIUG Board of Directors 2027-2028 will be announced in October 2026. Stay tuned.
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
gary@iiug.org
Highlights
Informix 15.0.1 is available now; Find out what’s new!
Informix 15.0.1 includes performance and administration enhancements designed to help teams run high-volume workloads and achieve faster recovery times. NOTE: Some of these features required changes to low-level disk structures, so moving to Informix 15.0.1 involves an in-place conversion. This means it is exceptionally important to take a good backup before upgrade.
What’s new:
Parallel Checkpoint for improved uptime and recoverability
- This new feature parallelizes the initial phase of a checkpoint, allowing multiple threads to concurrently process multiple buffer pools, which accelerates the flushing phase.
Kernel Async IO (KAIO) for advanced format devices with high capacity (>512k block size)
- Apps submit I/O request to high-capacity storage for processing without waiting for the I/O operation to complete for optimal performance (large datasets)
Enhanced administration for new databases
- New optional “Create database” parameters for: Isolation level, DB locale, Log mods
Archecker enhancements
- Parallel table restore for faster fragmented table restores with archecker
- Support for complex fragmentation schemes and expressions in , such as interval-based fragmentation
InformixHQ improvements making it easier to manage and monitor your Informix environment
- Hot Tables and Indexes dashboard diagnostics
- New block state alert, hide Group, Display updates
- Swagger API
- Repository Database Space Full Indication
Karen Qualley
HCL
Conference Corner
IBM TechXchange Conference 2026 – Save the Date!!
October 26 – 29, 2026
Atlanta, Georgia, USA
Receive a 40% discount to IBM TechXchange 2026 if you register now.
NOTE: You will be taken to the IBM sign in page to register for this event. You must have an IBM account to register for this event. There is a link on the page to create your IBM account.
Stay tuned for future updates!
Invite colleagues to join us at IBM TechXchange 2026!
We can’t wait to see you in Atlanta in 2026!
#IIUG #IBMTechXchange #Informix
Rhonda Hackenburg
IIUG Board
Informix Corner
What is the difference between Informix Mod Packs, Fix Packs and Cumulative Special Builds (CSBs)?
To summarize, Informix provides maintenance through three primary delivery vehicles, all of which undergo extensive quality assurance to ensure system reliability.
- Mod Packs (v15 only): Released periodically to introduce significant new features and provide fixes for Known Issues (KIs).
- Fix Packs: Periodic maintenance releases that focus exclusively on delivering fixes for KIs.
- Cumulative Special Builds (CSBs): Targeted releases for urgent, core KIs that provide fixes faster than standard cycles while maintaining the reliability of a Fix Pack.
| Vehicle Type | Purpose | Version Examples |
| Mod Pack | New features + fixes (v15+) | 15.0.0, 15.0.1 |
| Fix Pack | Periodic maintenance & bug fixes | 15.0.1.1, 14.10.xC13, 12.10.xC16 |
| Cumulative Special Build (CSB) | Urgent/Core bug fixes | 15.0.0.1.4, 14.10.xC12W17, 12.10.xC16W3 |
A more comprehensive overview is now available in the Informix Support policy statement.
Karen Qualley
HCL
Upcoming: APAC HCL Informix® Technical User Session – 3 March 2026
Join us for the APAC HCL Informix® Technical User Session, a live technical deep dive built for developers and DBAs who run and build on HCL Informix®. This session will cover HCL Informix 15.0.1, including what’s new in the release, what’s coming next, and practical ways teams can improve performance, uptime, and operational efficiency in real-world environments.
Date: 3 March 2026
Time: 1:00 PM AEDT (Sydney/Melbourne)
Location: Virtual via Zoom
Hear directly from HCL Informix experts as they walk through key 15.0.1 updates, share upgrade guidance and lessons learned, and highlight underused capabilities that can streamline everyday development and administration.
You’ll also hear from Liew Kim Non from DB Solve Technologies Consulting, who will share how they’re helping customers upgrade to HCL Informix 15 in place, with practical modernization guidance to streamline operations and future-proof applications.
This session will cover:
- What’s new in HCL Informix 15.0.1 and why it matters
- Product direction and roadmap highlights
- Upgrade planning best practices and real-world lessons
- Hidden or underused capabilities that simplify development and operations
You’ll hear from:
- John (JC) Lengyel – Chief Architect, HCL Informix, Actian
- Mark Tritaris – Sales Engineer, Actian
- Naag Balakrish – Channel Sales Engineer, Actian
- Liew Kim Non – Managing Partner, DB Solve Technologies Consulting
Live chat Q&A will be available throughout the session, so you can get direct answers from HCL Informix specialists and technical leaders.
Informix is a trademark of IBM Corporation in at least one jurisdiction and is used under license.
Nick Johnson
Sr. Product Marketing Manager|Database & Launches, Actian
Informix Tech Talks on YouTube
Upcoming Informix Tech Talks
There will be no Tech Talks for February
Rhonda Hackenburg
IIUG Board
Last Informix Tech Talks Replay
Replay of the Last Informix Tech Talks: January 2026 – Understanding how Indexes in Informix Work by Mark Jamison
Informix Tech Talks YouTube Channel
Our YouTube Channel now has:
- 581 subscribers (1new subscriber)
- 119 videos (1 new video)
- 26,322 views (359 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 your presentation.
If you are interested in producing a 15 – 45-minute presentation, please contact either Art Kagel or Bruce Simms for additional information.
Rhonda Hackenburg
IIUG Board
Informix Training
Free Informix Tutorials Videos – a step-by-step approach to using Informix Database Servers is available at https://advancedatatools.com/tech-info/informix-tutorials/
2026 Update to Informix Badging Process
The Informix 14.10 Badge exam is NOW available.
Click here for information on how to register for the exam.
Rhonda Hackenburg
IIUG Board
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.
Recent
Have an new TEMP_TABLE_SIZE = [LARGE|SMALL] onconfig and session parameter
Popular
Informix should be able to change owner on tables and any other objects (110 votes)
Backup Individual database, not entire instance (95 votes)
IBM Informix Forum Corner
Join and visit the IBM Informix Community Forum
Recent Posts:
DIRECT I/O (KAIO) Disabled in RHEL 9
Informix 15.0.0.2 IL1: Insert from SMALL table into temp LARGE table very slow
Can’t license IDS version from FixCentral?
Java Version for Informix Installation
IDS 14.10.FC13 compatibility with other Informix tools
Logical log’s and initialize new instance
Error in COMMIT WORK when trying to add a chunk
DRDA redirection to HDR primary
Gary Ben-Israel
IIUG Board
Informix Technical Content
Views referenced in other views
It is common that a view selects from another view. The problem is that when we drop a view all the views that are selecting from it are dropped as well. We want to find those views so we can recreate them. The problem is that the column viewtext in sysviews is a CHAR(256), so the viewtext resides on many rows. Hence the table name we are searching can be split on two rows which makes it difficult to find. You can use a SPL function to do the search. It is then easy to add a view that returns the desired results.
create function view_in_view_fn(view_name nvarchar(128), match_view nvarchar(128))
returning smallint;
define all_view_text lvarchar(30000);
define view_text nchar(256);
define s_no integer;
let all_view_text = null;
foreach
select seqno, viewtext into s_no, view_text
from systables a, sysviews b
where b.tabid = a.tabid
and a.tabname = view_name
order by seqno
if all_view_text is null then
let all_view_text = view_text;
else
let all_view_text = trim(all_view_text)||view_text;
end if
end foreach
if all_view_text matches “*”||trim(match_view)||”*” then
return 1;
else
return 0;
end if
end function;
create view view_in_view
(parent_view, child_view) as
select b.tabname, a.tabname
from systables a, systables b
where a.tabtype = “V”
and a.tabname != b.tabname
and view_in_view_fn(a.tabname, b.tabname) = 1;
create view view_in_view
(parent_view, child_view) as
select b.tabname, a.tabname
from systables a, systables b
where a.tabtype = “V”
and a.tabname != b.tabname
and view_in_view_fn(a.tabname, b.tabname) = 1;
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.
Blogs / Newsletters
Art Kagel – https://informix-myview.blogspot.com/
Mary Schulte – ACTIAN https://www.actian.com/blog/databases/user-friendly-external-smartblobs-using-a-shadow-directory/
Gerd Kaluzinski – German Informix Newsletter – NEW!!
IBM Informix RFE
IBM Informix RFE – Informix Requests for Enhancements.
Technical Articles
Oninit Group
WAIUG (Washington Area Informix User Group) Tech Tips
Over 10 Years of Informix Webcast Replays
Over 30 Years of Informix Blog Posts
Social Media
| YouTube | X |
IIUG’s own Art Kagel was recently features on the Tech Sharmit Podcast to talk about his life and involvement with Informix and database systems.
Catch the podcast here (https://www.youtube.com/watch?v=l81pLa7i-J0)
Forums, Groups, Videos, and Magazines
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