Highlights: IIUG World 2021 – Registration Open and Keynote Speakers Announced
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
Finally, IBM and HCL have a roadmap for Informix. We are still not permitted to share it with you
But it looks promising. I hope we could share the roadmap in the next Insider.
At least the Informix development continues. I wish I could say the same about marketing.
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
Highlights
IIUG World 2021 – Registration Open and Keynote Speakers Announced
Join us for IIUG World 2021, October 5-7, 2021.
Great News! We were able to confirm our keynote speakers for this year’s IIUG World event. It is always nice when your first choices are available and willing to help with the event.
Arvind Krishna – IBM Chairman and CEO
Madhu Kochar – IBM Vice President, Product management, Data and AI
Seth Dobrin – VP and Chief Data Officer for IBM Analytics
Special thanks to Arvind, Madhu and Seth. We look forward to having you as part of our team.
We have begun working the session schedule. I can tell you there will be at least one Roadmap session, since most everyone is interested in this session. Here is a sampling of topics you might find of interest:
- Informix Roadmap and licensing
- Informix in Cloudpak for Data
- What’s new in SQL?
- Best Practice(s) Using Keystores
- Easy App Development using Informix Containers
- Safeguard Your Data with Encrypted Backups
- Learn All About Backups from Secondaries
- What’s New with Informix Replication?
- Going from Development to Production with IBM Informix Editions
- What’s new in the Kernel?
Don’t forget, speaker submission is open through August 31. It is not too late to submit your abstract to the Planning Committee to be a part of this year’s event. Submit Abstract.
Registration is now open for IIUG World 2021! Register before September 1, 2021 to take advantage of the Early Bird Price of $150. Registration will be $199 after that. Your paid registration includes:
- Access to two Certification Preparation Tutorials held after IIUG World 2021
- One complimentary pass to take the newly released Official IBM Informix 14 .10 certification exam.
Register for IIUG World 2021 today!
Visit IIUG World 2021 for more details.
Rhonda Hackenburg
IIUG World Planning Committee
Informix Corner
Next Informix Tech Talks
Webinar title: Introduction to Informix Enterprise Replication
When: Thursday, September 2, 2021 2:00pm EDT
Speaker: Paul Watson
Registration: https://www.iiug.org/en/services/next-webcast/
Informix Tech Talks on YouTube
Part 3 – by Carlton Doe, Fred Hubbard, Walt Hultgren, Lester Knutsen, and Mike Reetz
Description: More stores from the past, including the role the Informix users played in the Informix port to Linux, adding technical content and the “Ask The Experts” sessions to the Informix Worldwide Conferences and the growth of the International Informix Users Group.
This video is the third in the series on the History of Informix Users and will be available on YouTube on August 15th, 2021, at: https://www.youtube.com/c/InformixTechTalksbytheIIUG
Part 1 and 2 are available at: https://www.iiug.org/en/2021/06/24/informix-tech-talks-history-of-the-informix-user-groups/
All Past Tech Talks:
https://www.iiug.org/en/category/techtalks/
Informix Training
Informix for Database Administrators Training Course – September 20-24, 2021
Advanced Informix Performance Tuning Course – October 25-29, 2021
https://advancedatatools.com/training/course-schedule/
Informix xc6 Webinar series replays are available online
3.4.1. Webinar title: Latest enhancements in IBM Informix 14.10xC6
Speaker: JC Lengyel
Description: Join us for an overview of Informix 14.10xC6 enhancements. We’ll give you a preview to enhanced performance, security and availability in the latest release.
3.4.2. Webinar title: IIUG/IBM xc6 Webcast – Kernel, Enterprise Replication and SQL features
Speaker: Carlton Doe
3.4.3. Webinar title: IIUG/IBM xc6 Webcast – IHQ and Backup from RS secondary
Speaker: Carlton Doe
RFE Corner
IBM has an RFE – Request For Enhancements website.
https://ibm-data-and-ai.ideas.aha.io/?project=INFX
Please visit this site to vote for your favorite enhancements and place new requests. It is friendly and has a nice look and feel.
Recent
Allow indexes to be made invisible to queries
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: 94 (+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: 86 (+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: 79 (+1)
Created: December 24, 2018
Status: Future consideration
Gary Ben-Israel
IBM Informix Forum Corner
Join and visit the IBM Informix community forum at http://www.iiug.org/community
Recent posts
Possible CM / CSDK 4.50.FC6 / SSL Issue
Informix Client CSDK Parameters
Gary Ben-Israel
Informix Resources
IIUG website
www.iiug.org
IBM Informix community
http://www.iiug.org/community
Informix Blogs and Wikis
Please note: The list below contains only blogs that were active in the last six months.
- Art Kagel http://informix-myview.blogspot.co.il/
Technical articles
https://www.oninitgroup.com/technical-articles/
https://www.oninitgroup.com/faq-items/cloud-backups-with-informix-14-10/
Social Media
YouTube: https://www.youtube.com/c/InformixTechTalksbytheIIUG
Linkedin: https://www.linkedin.com/groups/25049
Twitter : https://twitter.com/iiug
Facebook : https://www.facebook.com/IIUG.Informix
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 now 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
