IIUG Insider (Issue #252) July 2021

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.

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

gary@iiug.org

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.

Click here for replay

3.4.2. Webinar title: IIUG/IBM xc6 Webcast – Kernel, Enterprise Replication and SQL features

Speaker: Carlton Doe

Click here for replay

3.4.3. Webinar title: IIUG/IBM xc6 Webcast – IHQ and Backup from RS secondary

Speaker: Carlton Doe

Click here for replay

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

Rubrik Anyone

14.10 user/connection limits?

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.

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

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

Published
Categorized as Insider

By Vicente Salvador

Board member since 2014, a user since 1989 and Informix fan. I'am software architect which allow me to combine technical and business skills.