Category Archives: WAIUG

WAIUG Meeting Dec 7th 2023

The next WAIUG meeting will occur virtually on Dec 7th 2023. 9am – 1pm EST. It will be an exciting set of technical talks from presenters with the developers of Informix from HCL as well as user speakers.

Presentations by:

  • HCL – Pavan Gummalla – Ensuring Data Integrity and Confidentiality in Informix Database
  • HCL – Shubham Kapoor – Sneak peek at updates to InformixHQ with Demo
  • Laurent Galais and Delane Freeman with FourJs – 4GL and Genero
  • Mike Walker – Check your backups with archecker.
    You ARE testing your backups aren’t you? The Informix archecker utility can be used to verify that your Informix backups are ‘good’, and also to perform table-level restores from a backup…a handy feature after a ‘whoops, I shouldn’t have run that in production’ moment! Mike will explain how to use this utility to verify backups and perform table-level restores, and demonstrate these features.

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.

Please RSVP here to attend (Webex)

Tech Tip – CSDK Install 4.50FC10 on Win11

Some users may find that when installing 4.50FC10 on Windows 11 the installer crashes with:

Flexeraaw7$aaa: Windows DLL failed to load
at Flexeraaw7.af(Unknown Source)
at Flexeraaw7.aa(Unknown Source)
at com.zerog.ia.installer.LifeCycleManager.init(Unknown Source)
at com.zerog.ia.installer.LifeCycleManager.executeApplication(Unknown Source)
at com.zerog.ia.installer.Main.main(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at com.zerog.lax.LAX.launch(Unknown Source)
at com.zerog.lax.LAX.main(Unknown Source)

To solve this issue, open a windows command window and

set JAVA_TOOL_OPTIONS="-Dos.name=Windows 7"
installclientsdk.exe

WAIUG December 2022 Meeting Replay

Thank you for everyone who attended! For those of you that missed it or want more information below is the replay and slides from the meeting. Our next meeting will be somewhere in middle 2023, so please stay tuned. If you wish to present or have ideas for topics please reach out and let us know.

WAIUG Part 1 – Welcome and Doing Storage Better by Art Kagel
Replay on YouTube: https://youtu.be/JE70r-2chOs
Slides
Welcome by Thomas Beebe and Doing Storage Better – Exploring the best and worst options by Art Kagel

WAIUG Part 2 – Informix HQ by Shubham Kapoor
Replay on YouTube: https://youtu.be/vxaIHHEujSQ

WAIUG Part 3 – Explaining Explain Plans by Mike Walker
Replay on YouTube: https://youtu.be/8UIVIQBFzoU
Slides
Query execution plans are the best tool to give a detailed insight into exactly how a query is being run by Informix. They are the first stop when trying to understand just why a query is running slower than expected.

In this presentation, Mike Walker will show how to obtain a query plan and how to interpret it.
He will also describe what he looks for in the plan that shows where their tuning opportunities are hiding.

WAIUG Part 4 – Conclusion, Oracle Style Global Temp Tables by Art Kagel and Informix Certification by Rhonda Hackenburg
Replay on YouTube: https://youtu.be/0CPNA6N82kk

Extra presentation by Art Kagel on Oracle Style Global Temp Tables. Informix Certification by Rhonda Hackenburg and Meeting Conclusion by Thomas Beebe

Thank you again to the support of the IIUG for making this happen.
The next IIUG Tech Talk will be Feb 2nd:
Informix Sysmaster Database Queries for monitoring and performance tuning by Lester Knutsen

WAIUG Meeting Dec 8th Coming Up

The next WAIUG meeting will occur virtually on Dec 8th 2022. 9am – 1pm EDT. 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
  • Tom Girsch
  • Shubham Kapoor – Informix HQ
  • Mike Walker – Explaining Explain Plans
    • Query execution plans are the best tool to give a detailed insight into exactly how a query is being run by Informix.
      They are the first stop when trying to understand just why a query is running slower than expected.

      In this presentation, Mike Walker will show how to obtain a query plan and how to interpret it.
      He will also describe what he looks for in the plan that shows where there tuning opportunities are hiding.

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.

Please RSVP here to attend (Webex)

WAIUG Meeting From July 14th 2022

Thank you to our amazing presenters for a fantastic user group meeting. As always, thank you for the user group members and interested parties for attending.

Presentations

Shripad Sonavnay – Informix Roadmap – Youtube Replay

Stuart Litel – Informix 14 Certification Exam – Youtube Replay

Mike Walker – Informix Auditing SlidesYoutube Replay

Paul Watson – Beginners Guide To CDC SlidesYoutube Replay

We will be planning our next meeting for Fall/Winter timeframe. If there is a class you would be interested in teaching, or if there is a topic you want to hear about please reach out to us at Contact Us.

WAIUG Virtual Meeting July 14th 2022

The WAIUG is back and excited to bring you a new and exciting set of Informix technical talks on July 14th 2022 from 9:30am-1pm. This free virtual meeting is open to anyone in the Informix community who wants to pick up some new skills and learn some new things around Informix.

We are finalizing the class lineup but we will have excellent talks from Paul Watson (Oninit), Mike Walker (xDB Systems) and more. Stay tuned here for a full list of presenters and classes.

Paul Watson – CDC – A beginners guide

Change Data Capture or CDC is a very useful weapon to have in your arsenal, whether it is just a quick what happened or a full blown forensic tool  However, many people have never heard of it or are scared to use it.  This presentation will examine the various APIs show how to build a working DBA tool

Sign up below to make sure to reserve your spot. Once you RSVP we will have your information and will send out an invite to the virtual meeting in a few weeks.

WAIUG July 2021 Meeting Recap

Thank you for everyone who attended as well as anyone who may be coming here after the fact to watch the replay.

Also, thank you to our amazing presenters and the IIUG team for supporting us.

Youtube Replays

The Slide Decks

We will be having our next meeting in Q4 of 2021. If you would be interested in presenting or have a particular topic you would like to see addressed, please use the contact us link at the top.

A replay of the meeting will be posted shortly.

WAIUG Virtual Meeting July 22nd 2021

The WAIUG is excited to announce an upcoming virtual meeting on July 22nd from 1pm – 4pm EDT on July 22nd.

This Free meeting is run in conjunction with the IIUG webcast series and will give a longer set of sessions from some excellent presenters:

Scott Pickett – Informix with NoSQL

Paul Watson – Creating C-UDRs for Informix

Carlton Doe – Introduction to the Informix 14 certification exam

Thomas Beebe – Getting started with Informix Connection Manager

We really hope you can make the sessions. Please RSVP for the meeting here