Highlights: Unlocking the Power of Real-Time Monitoring with InformixHQb
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
We are approaching the last quarter of 2024. On December 31 the current IIUG board will end its two-year term. We will announce the election for the 2025-2026 board in October. If you want to participate in the process, please take the time to ensure your IIUG Membership is up to date.
Informix 15 is coming real soon. I hope that the September Insider will have information regarding this release.
Another Informix session was added to October’s TechXchange, Informix 15: What’s New and What’s Next, to be presented by Carlton Doe.
| Login | Join IIUG |
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
gary@iiug.org
Highlights
Unlocking the Power of Real-Time Monitoring with InformixHQb
In today’s fast-paced digital world, maintaining optimal database performance is crucial. InformixHQ revolutionizes database management with its robust real-time monitoring capabilities, providing a comprehensive view of your Informix server instances.
Key Features of Real-Time Monitoring in InformixHQ:
Instant Performance Insights:
Track key metrics such as CPU usage, memory utilization, and query performance in real-time. This allows you to quickly identify and resolve bottlenecks, ensuring smooth operation.
Customizable Dashboards:
Tailor your monitoring dashboards to display the most relevant information for your specific needs. Whether you’re focused on resource management, query optimization, or system health, InformixHQ provides the flexibility to visualize the data that matters most to you.
Proactive Issue Detection:
With real-time monitoring, InformixHQ enables proactive issue detection, allowing you to address potential problems before they escalate. This minimizes downtime and ensures that your systems remain reliable and responsive.
Historical Data Analysis:
InformixHQ doesn’t just provide real-time data; it also stores historical performance metrics. This allows you to analyze trends over time, helping you make informed decisions to optimize your database performance.
Why Real-Time Monitoring Matters:
Real-time monitoring with InformixHQ empowers database administrators to stay ahead of issues, optimize performance, and ensure the reliability of their database environments. By leveraging these capabilities, you can maintain high availability, reduce operational costs, and deliver better experiences to end-users.
How to Enable Real-Time Monitoring in InformixHQ:
- Select Data Sources:
- Log into InformixHQ and select the Informix server instances you wish to monitor in real time.
- Access the Monitoring:
- Navigate to the monitoring section and configure sensors of your
- Customize Your Dashboard:
- Navigate to dashboard section. Add and arrange widgets that display real-time metrics relevant to your environment.
- Set Alerts for Critical Metrics:
- Enable notifications for key performance indicators to ensure you’re alerted to any issues immediately.
- Start Monitoring:
- Begin tracking your server’s performance and use the insights to optimize your database operations.
Get Started with InformixHQ Today:
Unlock the full potential of your Informix database with the power of real-time monitoring. Start using InformixHQ to gain deep insights into your database performance and ensure your systems are always running at their best.
Ajay Satbhadre
HCL
ajayanand_satbhadre@hcl-software.com
Conference Corner
IBM TechXchange Conference Las Vegas, NV, USA
Title: IBM TechXchange Conference 2024
Date: October 21-24, 2024
Location: Mandalay Bay – Las Vegas, NV, USA
ANOTHER NEW SESSION WAS ADDED: Informix 15: What’s New and What’s Next, presented by Carlton Doe, Carlton Doe, IBM. Informix Evangelist and author, introduces the newest version of Informix and highlights its many improvements and innovations. The performance you enterprise relies on is getting even better, just in time for your increasingly complex workloads. Whether you rely on Informix for transactional processing, analytics or AI with watsonx—don’t miss this informative session.
REMINDER: Due to a delay in the release of Informix V15. There will not be sufficient content to provide an Informix track. Therefore, the IIUG Board will not participate. We will continue to support this event and provide any Informix information regarding this event when it becomes available to us.
Be in the know about the latest tech, certifications, education & AI trends.
Join IBM to gain industry-leading skills, get a first look at the latest product roadmaps, engage in hands-on experiences, earn industry-leading credentials, network with thousands of peers, and hear from the best and brightest minds working in tech today. Discover what’s to come in your area of focus.
Informix Sessions:
|
Informix 15: What’s New and What’s Next Carlton Doe, IBM Informix Evangelist and author, introduces the newest version of Informix and highlights its many improvements and innovations. The performance you enterprise relies on is getting even better, just in time for your increasingly complex workloads. Whether you rely on Informix for transactional processing, analytics or AI with watsonx—don’t miss this informative session. |
Carlton Doe, IBM Wednesday, October 23, 11:30 am Session 3334, South, Banyan, Level 3 |
|
Informix for watsonx – your way into AI – guide, examples and a fantastic success story Companies using IBM Informix can now unlock additional value from their Informix data through integration with watsonx. Watsonx facilitates rapid, governed access to data residing in IBM Informix, to enable the creation of real-time dashboards and insights reporting, as well as the processing of new analytics use cases and AI models. With watsonx.data’s new connector for IBM Informix, users can easily access and query multi-modal data types in IBM Informix as well as other data sources with zero-ETL, while delivering built-in governance, security, and automation. The watsonx.ai Informix connector makes it easy to build your AI use case. |
Henri Cujass, leole IT Thursday, October 24, 8:30 am Session 2269, South, Jasmine G, Level 3 |
|
Informix, the database that does so much more! Informix has been part of IBM’s portfolio since 2001. A lot has happened to it since then to keep it a feature rich, cutting edge, fast database, with a huge range of applications. From its small footprint, autonomous features, MQTT and NoSQL support that makes it ideal as an embeddable database, to its speed, reliability and scalability as an Enterprise database, Informix is a great choice for so many applications. TimeSeries and Spatial support add capabilities to a relational database without the need to add to the software stack. Mike is an IBM Champion and has used Informix for over 25 years. This presentation will describe at a high level the many features of Informix that make it such a versatile product, and how it is so much more than just a standard relational database. |
Mike Walker, xDB Systems, Inc Tuesday, October 22, 11:30 am Session 2912, South, South Seas D, Level 3 |
|
Securing Informix Connections with SSL Security has become more important than ever. Between compliance rules and best security practices there are many new rules and regulations that face a DBA these days. One of the most important, and often overlooked areas of security is the encryption of data-in-transit. Informix has a few different ways of establishing encryption. In this session we will cover how to configure SSL listeners in a variety of situations. This will help all types of Informix installs. From multiple edge IoT devices to huge data warehouses, this will be a valuable class for any administrator that needs to implement it. This is a technical talk focused as a how-to for getting SSL up and running in your Informix environment. |
Thomas Beebe, xDB Systems, Inc Wednesday, October 23, 1:30 pm Session 2938, South, Jasmine G, Level 3 |
|
NEW: Using multiple data integration tools in a data architecture in the banking industry Architecture and projects associated with the integration (Datastage and Data Replication) of multiple data sources (informix and third party) to a data warehouse to define the consume of information of data analysts, BI developers and other business users. |
Carlos Hernandex, Gerente, Intercam Details have not yet been posted Session 2983 |
|
NEW: The WWT Advanced Technology Center: IBM Products, Use Cases, Integration, and Lessons Learned The WWT Advanced Technology Center is a $850 million collaborative ecosystem to design, build, demonstrate, and deploy innovative technology products and integrated architectural solutions. We have built an environment with IBM Power Systems, IBM Storage, and Red Hat Openshift – integrated with each other and with other vendors – to demonstrate the strength of IBM solutions. The environment builds awareness and credibility within a new IBM business partner, support POCs and demos, educate, and highlight opportunities for integration and interoperability, with a special focus on AI use cases, AI infrastructure, and hybrid and private cloud. In this session, multiple IBM Champions will describe what we’ve built, the various integrations and POCs that have been explored, and lessons learned. |
Ryan Avery, Storage Solution Architect, World Wide Technology Kevin Gee, Global Technical Solutions Architect (Field CTO), World Wide Technology Tuesday, October 22, 4:30 pm Session 2863, South, Oceanside B, Level 2 |
For our Informix Community members who use or are interested in Informix as well as other IBM products you can learn more here: IBM TechXchange Conference 2024.
Rhonda Hackenburg
IIUG Board
Informix Corner
Informix Tech Talks on YouTube
Upcoming Informix Tech Talks
There is currently no Tech Talks for September.
Last Informix Tech Talks Replay
Replay of the Last Informix Tech Talks: Exploring the Informix Sysmater Database – Lester Knutsen – August 2024
Informix Tech Talks YouTube Channel
Our YouTube Channel now has:
-
509 subscribers (4 new subscribers)
-
107 videos (1 new video)
-
18,924 views (412 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
Schedule Your Informix 14.10 Exam Today
The Informix 14.10 Badge exam is still available!
The exam will be administered online. You are required to complete the exam with a proctor from our approved list, or nominate one of your own, to be approved by IBM or the IIUG Board. You will be required to have a live webcam running as you complete the exam.
For those not familiar with the term Proctor: 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 ensure academic integrity guidelines are followed during the exam.
Click here to learn more or schedule your exam.
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
FOT Indexes to support multi-index scans
FOT Indexes to support OR queries
Better documentation on syscdr database
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: 108 (+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: 105 (+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: 93 (+0)
Created: December 24, 2018
Status: Future consideration
Gary Ben-Israel
IUG Board
IBM Informix Forum Corner
Join and visit the IBM Informix community forum
Recent Posts
Message:-9272 SQL State:IX000 Unknown error message -9272.
How to manage Informix optimizer?
Informix DB2Connection Implicit Transaction
onload utility runtime performance issue
onaudit: precision of datetime of audited events?
Gary Ben-Israel
IIUG Board
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/
Over 10 Years of Informix Webcast Replays
Over 30 Years of Informix Blog Posts
Social Media
| YouTube | X (Twitter) |
Forums, Groups, Videos, and Magazines
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