Highlights: View the Informix IIUG World 2021 Virtual Conference opening keynote by Arvind Krishna, Chairman and Chief Executive Officer of IBM.
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
Our world is becoming virtual. We had a virtual conference, we are having a virtual board meeting, more server farms and databases are in the cloud, more people are working from home.
Is this a phase? Will we be back to face to face meeting or is this our new reality.
I miss meeting people in person. I hope our 2022 to meetings and conferences will be physical.
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
Highlights
IIUG World 2021 Virtual Conference Opening Keynote by Arvind Krishna, Chairman and Chief Executive Officer of IBM
Arvind Krishna delivered a great keynote to the IIUG World 2021 attendees. You can view it on the IIUG YouTube channel. Don’t miss it.
I will just quote Arvind’s closing sentence. “Informix will outlive all of us”. Coming from IBM’s Chairman and CEO this is a powerful statement.
Conference Corner
IIUG WORLD 2021 – Recap
Our first ever virtual technical event is now history. We had many participants who were able to enjoy three days of great content from their homes or offices around the world. Including 2 keynotes, over 30 sessions, one session on Informix Strategy, Roadmap and Licensing and one session to “Ask the Experts”, as well as several Sponsor sessions.
The IIUG Board and Planning Committee would like to thank all of our attendees, sponsors and especially our speakers who helped make this a success. Special thanks to Carlton Doe and Scott Pickett for their Informix Badge Preparation Training tutorials to help the Informix Community prepare for the NEW Informix certification exam.
We are looking forward to IIUG World 2022. Will it be another virtual event or back to an in-person event? Maybe it could be a hybrid event, offering the best of both worlds. Time will tell.
For those of you who attended IIUG World 2021, you should have received an email to complete a short survey to provide your feedback. These are your events and we strive to provide a quality event each year.
Rhonda Hackenburg
Planning Committee
IIUG Board Member
Informix Corner
Registration for the New Informix Certification Exam is Ready!
The IIUG has finalized the requirements needed to complete the NEW Informix 14.10 Certification badge. The test is now available!
There are two options to complete the exam:
- You were a paid registrant to IIUG World 2021. Paid registrants to IIUG World 2021 received a complementary one-time exam with a paid registration. You have until January 31, 2022 to complete your complementary exam.
- Pay $150 fee to take the exam. Exams must be completed within 90 days after purchase The $150 dollars is non-refundable. You will receive an email with a confirmation code with your payment. PAY HERE
To begin the exam registration process, email either your IIUG World registration code or your exam confirmation code to Stuart Litel (slitel@ibm.com). He will work with you to schedule your exam.
If you missed IIUG World 2021, you missed the Badge Preparation Tutorials offered by Carlton Doe and Scott Pickett. It is not too late: we will be offering replays for a nominal fee of $100 for both replays:
- November 22, 2021 8:00 AM EST Informix Badge Preparation Training – Part One – Carlton Doe
- November 29, 2021 8:00 AM EST Informix Badge Preparation Training – Part Two – Scott Pickett
The exam will be administered online. You are required to complete the exam with a proctor from our approved list, or nominate your own. You will be required to have a live webcam running as you complete the exam. (For those not familiar with the term Proctor: The word 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 then ensures academic integrity guidelines are followed during the exam.)
You will have 90 minutes to answer 60 questions. You must achieve a 72% to receive you badge.
If you have any questions, please contact conference@iiug.org
Rhonda Hackenburg
Planning Committee
IIUG Board Member
The PDF documentation set for Informix v.14.10.FC6 is now available
Great news!! The PDF documentation set for Informix v.14.10.FC6 is now available for download from the Library section of this community. The direct link is here!
Thank you to HCL for producing this set and making it available to the Community.
Carlton Doe
Informix Tech Talks on YouTube
222 subscribers, 21 great videos. Subscribe to our channel and enjoy great content.
All Past Tech Talks:
https://www.iiug.org/en/category/techtalks/
RFE Corner
IBM has an RFE – Request For Enhancements website.
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
Uphold Helpline Number {1-815-940-2323} Uphold customer service support number
Uphod {1-815-940-2323} Uphold wallet Support Number Uphold wallet customer service Helpline number
+1(815) 680-0302 Uphold Toll Free Number Uphold Support Number
cdr migrate should allow code-set migration
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: 98 (+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: 91 (+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: 84 (+0)
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
IIUG World 2021 Keynote by Arvind Krishna
For archecker gurus: how do I restore a sequence using archecker ?
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
