Highlights: Informix Sessions for IBM TechXchange, Barcelona
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
The IIUG was experiencing some email issues over the last few weeks. If you sent an email to any @iiug.org addresses and have not received a response, would you please resend your email. We want to ensure we have not lost any emails.
The Washington Area Informix Users Group (WAIUG) will be holding its meeting via the IIUG Tech Talks channel on December 7. This event is open to all. You don’t have to be a WAIUG member to attend. Registration is available below.
Great news! The IIUG and IBM have selected the Informix content to be offered at IBM TechXchange Conference EMEA 2024 in Barcelona. See the Highlights section below for more details.
Reminder, IBM has provided the IIUG with 40 complimentary passes to attend IBM TechXchange, making this an invitation only event. An email was sent last month to IIUG members who live near the Barcelona event. If you received this email and want to attend, please submit your request for your complimentary pass.
Stay tuned for additional opportunities to attend IBM TechXchange!
Rhonda Hackenburg
IIUG Insider Co-Editor
IIUG Board of Directors
rhonda@iiug.org
Highlights
Informix Sessions for IBM TechXchange, Barcelona
First, thanks to all of you who submitted sessions for IBM TechXchange Conference EMEA 2024. The IIUG worked with IBM to offer the following sessions:
- Informix Product Roadmap – Scott Pickett and Carlton Doe
- Things Fail! – Getting Serious About Redundancy! – Tom Girsch
- Capturing Data Changes from IBM Informix into your applications without polling using IBM Informix – Art Kagel
- Informix, the Database that does so much more – Mike Walker
- Informix and JDBC – ETL and DBA tools, tricks and traps – Proficio
- Understanding how to use Informix asynchronous post commit triggers – Carlton Doe, IBM
- The data integration between Watsonx.data, IBM Informix and Siemens journey into the MetaVerse – Henri Cujass and Mahran Meissner from Siemens
- Database Operations (DbOps) – Davorin Kremenjas and Marin Rasic
We look forward to seeing you there.
Rhonda Hackenburg
IIUG Planning Committee
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: This is a by invitation only event. IBM is providing the IIUG with a maximum of 40 complimentary passes. An email was sent to IIUG members who reside near the event. Stay tuned for additional opportunities to attend.
Rhonda Hackenburg
IIUG Board
Informix Tech Talks on YouTube
Upcoming Informix Tech Talks – December 7
Title: WAIUG Meeting
Speaker: Various
Date/Time: Thursday, December 7, 2023, 9:00 AM – 12:30 PM EST
Description: Sessions to be announced.
Register for WAIUG Meeting
Last Informix Tech Talks Replay
Replay of the Last Informix Tech Talks: October 26, 2023: Proving Stuff with Informix Internals, Mark Scranton
Informix Tech Talks YouTube Channel
Our YouTube Channel now has:
-
435 subscribers (12 subscribers since last month)
-
101 videos (1 new video since last month)
-
13,481 views (643 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
IBM is Looking 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 was scheduled to begin 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
IBM
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 8.0.55.31 in both Server and Client
- The Java version has been updated to Java 8.0.8.5
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
HCL
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.
Recent
Enhance onstat -g prc information
Enhance onstat -g dic information
Enhance sysproclan information
Informix should be supported as a Kubernetes based Database inside of the Container
have NVL() and COALESCE() accept host variables like other DB engines do
Better tool for performance analysis and tips
Add sid to onstat -g tpf output
Have another table sysesprof with reads/writes per session and bufferpool
Support for datetime with timezone
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
Informix IDS 14.10 for Linux RHE9 aarch64
Error -25582, what’s a reason of?
Safe to DROP sbspace with zombie objects?
Gary Ben-Israel
IIUG Board
Informix Resources
Not a member, become an IIUG member and keep updated on all things Informix. It’s free.
Not a member, join the IBM Informix community and connect with other Informix data experts.
Informix Requests for Enhancements.
Informix Blogs ans Wikis
Andrés Repossi https://andreserepossi.wixsite.com/hablemosinformix (In Spanish)
Technical Articles
https://www.oninitgroup.com/technical-articles/
https://www.oninitgroup.com/faq-items/cloud-backups-with-informix-14-10/
Over 10 Years of Informix Webcast Replays
Over 30 Years of Informix Blog Posts
Social Media
| YouTube | X (Twitter) |
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