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.
Table of Contents
Editorial
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
gary@iiug.org
Highlights
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
IBM
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 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 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.
Recent
For the -12.. Conversion errors, please specify the column name.
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
onsmsync used to recycle backups : how effective is it?
Smart BLOB 16359 bytes, w/ ref count = 1, yet apparently not used by any table
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