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.
Table of Contents
Editorial
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
gary@iiug.org
Highlights
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
Conference Corner
Informix Technology Days
Title: IBM TechXchange Informix Technology Days
Dates:
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
SAVE THE DATE!
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:
- Ensuring Data Integrity, Pavan Gummalla
- InformixHQ, Shubham Kapoor
- Check Your Backups with Archecker, Mike Walker
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.
Recent
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
Informix Client SDK 4.10.TC16 Windows 64 only installing as 32 bit
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.
Technical Articles
https://www.oninitgroup.com/technical-articles/
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