Highlights: IIUG Sale – Purchase the Informix 14.10 Exam for $49.99 US
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
The IIUG board consists of ten members: one IBM rep (who does not stand for election and nine elected members.
There were nine seats available for the election that was to start on November 28.
However, there were only eight candidates, so we do not have to hold an election.
We would like to thank Lester Knutsen and Ognjen Orel, who are not continuing, for the great work and their huge contribution.
We are welcoming our new members Tom Beebe and Henri Cujass.
The 2023-2024 board members are:
President
Cindy Lichtenauer
IBM Rep
Stuart Litel
Members (by alphabetical order)
Tom Beebe
Gary Ben-Israel
Henri Cujass
Rhonda Hackenburg
Art Kagel
Vicente Salvador
Bruce Simms
To learn more, visit the IIUG Board of Directors page.
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
gary@iiug.org
Highlights
IIUG Sale – Purchase the Informix 14.10 Exam for $49.99 US
We are running an end-of-the-year sale price for the Informix 14.10 Exam.
Purchase the exam by the Midnight December 31, 2022, EST, for $49.99 and take up to 90-days to schedule and complete your exam.
Once you have successfully completed your exam you will receive your Badge from IBM to use on you resume, email signature or wherever you what to promote your Informix skills.
Click here to purchase your Informix 14.10 exam or learn more.
Rhonda Hackenburg
IIUG Board of Directors
rhonda@iiug.org
Informix Corner
Informix Tech Talks on YouTube
Upcoming Informix Tech Talks
Title: Washington Area Informix Users Group Meeting
Date: Thursday, December 8, 2022
Time: 9:00 am EST
The next WAIUG meeting will occur virtually on Dec 8th, 2022. It will be an exciting set of technical talks from presenters with the developers of Informix from HCL as well as user speakers. Topic descriptions will be posted shortly.
Presentations by:
- Art Kagel – Doing Storage Better – Exploring the best and worst options
- Shubham Kapoor – Informix HQ
- Mike Walker – Explaining Explain Plans
- With additional information on the Informix 14 Badge Exam
If you are new to the WAIUG, we are a free community drive user group focused on educating and sharing experiences for Informix users of all skill levels and backgrounds.
For additional information visit www.waiug.org
Rhonda Hackenburg
rhonda@iiug.org
Past Informix Tech Talks Replays
All Informix Tech Talks replays are available at: https://www.iiug.org/en/category/techtalks/
And on YouTube at: https://www.youtube.com/c/InformixTechTalksbytheIIUG
Replay of the last Informix TechTalks: Informix 14 – A Features Review of the Entire Release by Carlton Doe and Scott Pickett
Informix Tech Talks YouTube Channel
We now have 314 subscribers to our YouTube channel.
We have 85 videos on YouTube on our Channel.
Our Channel has received over 7,451 views so far!
Informix Tech Talk YouTube Channel Videos
Past Informix Tech Talks Replays
Lester Knutsen
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/
Lester Knutsen
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
Smart Trigger API for Java to monitor smart trigger session changes at the backend DB
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: 104 (+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: 98 (+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: 88 (+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
Informix 11.5 and Server 2012R2 – Database stuck in Quiescent Mode
Backup from InformixHQ and continous log backup
Better performance with temp dbspace in RAM disc?
14.10 – direct flooding “Network driver cannot accept a connection on the port”
Where can I download ESQL/COBOL
Gary Ben-Israel
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/
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 |
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