IIUG Insider (Issue #281) December 2023

Highlights: Get Your Complimentary Informix 14.10 Badge Exam at IBM TechXchange Summit EMEA

 

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

The last day of December was a special day. At least for those who write it MMDDYY, the way it is done in the US. 

The date was123123. 

Not much is happening as it was the holiday season. We are starting a new year. 

I wish all IIUG members, IBM and HCL employees a happy 2024. 

I would like to send special greetings to Scott Pickett who retired after 38 years of supporting the IIUG community and the Informix product. We love you Scott and wish you all the best on your new journey. 

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
gary@iiug.org

 

 

Highlights

Get Your Complimentary Informix 14.10 Badge Exam at IBM TechXchange Summit EMEA

 

IBM is offering complimentary Informix 14.10 badging exams at this event. 

Attend IBM TechXchange Summit EMEA in Barcelona, January 22 – 25, 2024 to take advantage of complimentary IBM badging.

We have been promoting this event for several months, and we were recently informed the Informix badging exam will be available during this event. 

Not only is attendance to TechXchange Summit EMEA complimentary, but now you can obtain your complimentary Informix 14.10 badge exam.  This is a savings of $150 on the Informix 14.10 exam, simply by attending this event.

The Informix 14.10 badge exam is a series of 60 questions, and you will have 90 minutes to complete the exam.  Achieve 72% to receive your IBM Badge.

Informix 14.10 badge certification is currently scheduled:

  • Tuesday, January 23
6:00 PM – 8:00 PM
  • Wednesday, January 24
6:00 PM – 8:00 PM

We still have a few complimentary passes available for this event, so grab your invitation to the event and your complimentary exam today.  Send your request to Cindy Lichtenauer at cindy@iiug.org.

See the Informix Corner for additional information on IBM TechXchange Summit EMEA.

Don’t miss the opportunity to this premier event. 

 

Rhonda Hackenburg
IIUG Board, Planning Committee

 

Informix Corner

IBM TechXchange Summit EMEA in Barcelona 2024

IT’S NOT TOO LATE TO REQUEST YOUR INVITATION

WE STILL HAVE A FEW COMPLIMENTARY PASSES AVAILABLE

Title: IBM TechXchange Summit EMEA 2024

Date: 22-25 January 2024

Location: CCIB – Centre de Convenciones Internacional de Barcelona, Barcelona, Spain

 

Innovating in the Age of AI: Transformative Learning for Technologists

Reasons to attend:

  • Explore the impact Generative AI will have on enterprise technologists using IBM products
  • Build deep technical expertise through a guided approach to learning
  • Get your hands on the tech with hands-on labs
  • Gain new certifications and level up your technical skills
  • For technologists by technologists
  • Join your community and connect with your peers
  • Meet with sponsors who could help you with current and future projects
  • There are 8 tracks with more than 450 sessions
  • This is an invite only, complimentary event

Featured Speakers include:

  • Dinesh Nirmal – Senior Vice President, Products, IBM
  • Nicholas Renotte – Chief AI Engineer, IBM Client Engineering
  • Rikke Jacobsen – CEO, CogniTech A/S, IBM Champion
  • Paul Mendelson – Product Manager, PMSquare, IBM Champion
  • Jason Gartner – GM, IBM Technical Sales & Client Engineering
  • Torbjörn Appehl – ISV Advisor, Built on Power, IBM Champion
  • Jean-Georges Perrin – Co-Founder, AbeaData, IBM Champion
  • Anant Jhingran – CTO, IBM Software

To learn more about this event:  https://www.ibm.com/community/ibm-techxchange-summit-emea/

NOTE: This is a by invitation only event.  We have a few complimentary passes available.  Please contact Cindy Lichtenauer at cindy@iiug.org if you are interested in attending this event.

Rhonda Hackenburg
IIUG Board

 

 

Informix Tech Talks on YouTube

Upcoming Informix Tech Talks

There will be no Tech Talks for January 2024.

 

 

Last Informix Tech Talks Replay

Replay of the Last Informix Tech Talks: WAIUG Meeting, December, 2023: 

 

Informix Tech Talks YouTube Channel

Our YouTube Channel now has:

  • 449 subscribers (5 new subscribers)

  • 104 videos (3 new videos)

  • 14,651 views (542 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

There were no new RFEs submit last month.

 

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

Check if buffers are in swap? 

Shrink after successful repack made Informix to exit 

What prevents a RSS to roll forward as fast as its primary? 

ALTER TABLE removes it from audit trail 

 

Gary Ben-Israel
IIUG Board

 

Informix Resources

IIUG Website

Not a member, become an IIUG member and keep updated on all things Informix. It’s free.

IBM Informix Community

Not a member, join the IBM Informix community and connect with other Informix data experts.

IBM Informix RFE

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 LinkedIn X (Twitter) Facebook

 

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