IIUG Insider (Issue #279) October 2023

Highlights: Informix Sessions for IBM TechXchange, Barcelona

 

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 IIUG was experiencing some email issues over the last few weeks. If you sent an email to any @iiug.org addresses and have not received a response, would you please resend your email.  We want to ensure we have not lost any emails.

 

The Washington Area Informix Users Group (WAIUG) will be holding its meeting via the IIUG Tech Talks channel on December 7.  This event is open to all.  You don’t have to be a WAIUG member to attend.  Registration is available below.

 

Great news! The IIUG and IBM have selected the Informix content to be offered at IBM TechXchange Conference EMEA 2024 in Barcelona. See the Highlights section below for more details.

Reminder, IBM has provided the IIUG with 40 complimentary passes to attend IBM TechXchange, making this an invitation only event.  An email was sent last month to IIUG members who live near the Barcelona event. If you received this email and want to attend, please submit your request for your complimentary pass.

Stay tuned for additional opportunities to attend IBM TechXchange!

 

Rhonda Hackenburg
IIUG Insider Co-Editor
IIUG Board of Directors
rhonda@iiug.org

 

 

Highlights

Informix Sessions for IBM TechXchange, Barcelona

First, thanks to all of you who submitted sessions for IBM TechXchange Conference EMEA 2024.  The IIUG worked with IBM to offer the following sessions:

  • Informix Product Roadmap – Scott Pickett and Carlton Doe
  • Things Fail! – Getting Serious About Redundancy! – Tom Girsch
  • Capturing Data Changes from IBM Informix into your applications without polling using IBM Informix – Art Kagel
  • Informix, the Database that does so much more – Mike Walker
  • Informix and JDBC – ETL and DBA tools, tricks and traps – Proficio
  • Understanding how to use Informix asynchronous post commit triggers – Carlton Doe, IBM
  • The data integration between Watsonx.data, IBM Informix and Siemens journey into the MetaVerse – Henri Cujass and Mahran Meissner from Siemens
  • Database Operations (DbOps) – Davorin Kremenjas and Marin Rasic

We look forward to seeing you there.

Rhonda Hackenburg
IIUG Planning Committee

 

 

Informix Corner

TechXchange Conference EMEA in Barcelona 2024 – Registration Opening Soon

Title: IBM TechXchange Conference EMEA 2024: Community & Learning for Tech Experts

Date: 22-25 January 2024

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

NOTE: This is a by invitation only event.  IBM is providing the IIUG with a maximum of 40 complimentary passes.  An email was sent to IIUG members who reside near the event.  Stay tuned for additional opportunities to attend.

Rhonda Hackenburg
IIUG Board

 

 

Informix Tech Talks on YouTube

Upcoming Informix Tech Talks – December 7

Title: WAIUG Meeting

Speaker: Various

Date/Time: Thursday, December 7, 2023, 9:00 AM – 12:30 PM EST

Description: Sessions to be announced.

Register for WAIUG Meeting

 

 

 

Last Informix Tech Talks Replay

Replay of the Last Informix Tech Talks: October 26, 2023:  Proving Stuff with Informix Internals, Mark Scranton

 

Informix Tech Talks YouTube Channel

Our YouTube Channel now has:

  • 435 subscribers (12 subscribers since last month)

  • 101 videos (1 new video since last month)

  • 13,481 views (643 new views since last month)

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 Bruce Simms or Rhonda Hackenburg for additional information.

Rhonda Hackenburg
IIUG Board

 

 

IBM is Looking Informix 15 Beta Testers

IBM is accepting applications from customers who want to participate in the first beta test of Informix 15.

You can be among the first to review Informix 15.  This is your opportunity to provide valuable feedback as you help IBM review the next release.

Testing was scheduled to begin October 18, 2023.

To be considered for this opportunity, you will be required to have a corporate email address. This email will be used by IBM to perform their export check to clear you for behind-the-scenes access to Informix 15.

If you want to submit your request to become an Informix 15 beta tester or would like additional information, please contact Scott Pickett at spickett@us.ibm.com.

Scott Pickett
IBM

 

Informix 14.10 and CSDK 4.50 Latest Drops are Available

A new PID of the 14.10 server and the 4.50 client is now out on Fix Central as of September 28th, 2023.

Highlights of 14.10.xC10W1 and 4.50.xC1W1:

  • Both have upgraded installers which now allow us to officially certify these new PIDs and subsequent releases of 14.10 on Windows 2022 (APAR IT41511).
  • The Informix Warehouse Accelerator (IWA) has a fix for Red Hat 8.5 compatibility (APAR IT41190).
  • GSKit has now been upgraded to 8.0.55.31 in both Server and Client
  • The Java version has been updated to Java 8.0.8.5

As a reminder, the Beta program is starting soon for vNext and if you are interested, let us know! Contact Scott Pickett (spickett@us.ibm.com) if you are interested.

Karen Qualley
HCL

 

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

 

Enhance onstat -g prc information 

Enhance onstat -g dic information 

Enhance sysproclan information 

Informix should be supported as a Kubernetes based Database inside of the Container 

have NVL() and COALESCE() accept host variables like other DB engines do 

Better tool for performance analysis and tips 

Add sid to onstat -g tpf output 

Have another table sysesprof with reads/writes per session and bufferpool 

Support for datetime with timezone 

 

 

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

 

Informix IDS 14.10 for Linux RHE9 aarch64 

Error -25582, what’s a reason of? 

Safe to DROP sbspace with zombie objects? 

Cleaning up datablades 

Optimizer question 

 

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.

 

Informix Blogs ans Wikis

Andrés Repossi https://andreserepossi.wixsite.com/hablemosinformix (In Spanish)

 

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 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