Opening Keynote with Arvind Krishna and Mike Gilfix
A01. Informix Strategy, Roadmap and Licensing
B02. Undocumented and little known Informix features
In this demo heavy session we will cover undocumented and little known Informix features. We will cover little known features including undocumentation onstat options e.g. the per session stored procedure cache included some known defects and how these can be detected to see if they are impacting your system!
A02. Informix in .Net World- New Features in .Net Core Provider
*What’s .Net Core? *.Net timeline with Informix *Functionalities of .Net Core Provider *.Net Framework Vs .Net Core : Comparison *Live Demo
C02. IBM Community meets IBM Champions.
How to engage with your fellow Informix users worldwide
A03. What's New in SQL?
Highlights for SQL and the latest updates.
B03. DBOps (Database Operations)
Everyone in IT is talking about DevOps and its derivatives: DevSecOps, SysOps, GitOps… and other Ops’es, but rarely anyone mentions good old databases in that context. Especially the ones with decades on their backs which just happen to work (TM) so no need to “Ops” them, right? Nope! Despite relational databases having a good track […]
C03. FOUR J's - Genero: the 21st Century 4GL.
There are still many, many Informix-4GL legacy applications in production, driving major corporation’s core business processes. Seemingly frozen in time, these applications have not progressed in over 20 years creating a significant risk to the business. CIOs and IT Managers alike are frustrated they cannot take advantage of their true value and search in vain […]
A04.Modernization: Informix CP4D and Kubernetes Operators
What’s new with Informix containers
B04. Informix Performance Tuning 38 years of lessons learned
In this session I will revisit some of the standard monitoring and tuning techniques I have presented before, but updated with what I have learned in 38 years of working with Informix servers. We will also cover some new ground and metrics that have changed over the years.
C04. Cognos 101: More than a reporting system
C13. 4GL is dead, long live BDL!
BDL – Business Development Language is the backbone of Genero, a modern Low-Code Development Platform that is 100% compatible with 4GL. Please join us for a technical review to learn how we have liberated 4GL from its legacy constraints and evolved the language to incorporate modern paradigms such as polymorphism, RESTful services, responsive design, SaaS […]
Wednesday Keynote -Dr. Seth Dobrin
In this session, Dr. Seth Dobrin, IBM’s first-ever Global Chief AI Officer, will share how he created a human-centered framework to operationalize AI at scale. By sharing his experience in leading data and AI transformations for multinational companies, Dr. Dobrin will show how IBM uses this framework to address the most urgent challenges businesses face […]
A05. Making the most of Informix Primary Storage Manager
With Informix version 12, IBM introduced PSM, a replacement for the frustrating and slow ISM (Informix Storage Manager). In this performance boosted, streamlined, powerful storage manager Informix now allows the use of onbar to perform backups when you don’t have a commercial storage manager available. In this talk we will go over how to get […]
C05. Asynchronous Post Commit Triggers in 14.10
This session will cover the new ASYNC post commit trigger introduced in IDS version 14.10. and also paved a way for the streaming analytics. There will be a short demonstration to show case this feature with few real life applications.
B05.TimeSeries and Covid
We start by learning why we should care about time series and then learn their basic characteristics. We can then apply what we just learned and more to COVID-19 data, starting with where we can get the multiple datasets available. We can then use multiple methods to process and visualize the data and see the […]
A06. Safeguard your data with encrypted backups; best practices
This session covers the motivation to protect the information we are storing in the database, and the use of Remote Key Store, to use state-of-the-art software and hardware servers that support the encryption key lifecycle and cryptographic operations, Integrated Backup Encryption in Informix
B06. Informix SQL Performance Tuning Tips
Understanding your application in how to tune SQL. Present case studies on how to improve SQL performance. Give examples of methods and tools used in tuning SQL. Utilize new features to improve SQL Performance.
C06. Informix Benchmarks on Cloud Systems
How fast will your database run in the cloud compared to your hardware? After working with customers moving their databases to the cloud and testing our new Informix training systems, I will share observations and performance recommendations. I will also share results using the benchmarks from my Fastest Informix DBA contests. I found a 25% […]
A07. What's new in the Kernel
Highlights for Kernel and the latest updates.
B07.Informix Version 14 New Features
In this demo heavy talk we will go over the latest Informix Version 14 new features including limitations and associated feature requests.
C07.Querix - Cloud-Native development in 4GL
Querix offers you all the tools and services you need to transform your Informix 4GL applications to the next level. In this sessions, we will show: Lycia in Kubernetes cluster(Load Balancing, Hot Deployment) Lycia extension for Web Based IDE (Basic Features, Remote Development, CI/CD, Remote Debugging) Web Services with REST API (4gl functions and apps […]
B08.Informix CSDK & Open Source Drivers - Extensive Features with Value Additions
Introduction of New Features in CSDK: Development of Open Source Drivers (Customer Delight), Smart trigger feature in Python Driver, The InformixAlchemy adapter, and Node-informixdb – node.js Informix driver
A08. Security Highlights; Best Practices using Keystores
This session covers in depth the use of SSL/TLS certificates for encrypted communication with Informix. * What is a certificate. * Where do you get one. * How are they used – how does it work. * Creating/Maintaining keystores for Informix SSL/TLS communication. * Troubleshooting SSL/TLS communication problems. * Anything else you want me to […]
C08. Extend your 4GL resources with Four Js Professional Services
Your legacy Informix 4GL application is critical to your business, but it needs modernizing. It’s too costly to rewrite and too honed to your business to replace with a packaged solution. You are at an impasse and doing nothing. Four Js Professional Services is here to help you make your users and management happy. We […]
Informix Badge Preparation Training Part One
IBM has recently released an Informix v.14.10 badge exam. It covers version 14.10 up to, but not including FC6. Together, Scott Pickett and Carlton Doe are covering all the technology and features tested in the exam. Each session will cover about half the material. These are “Death by Powerpoint” type sessions, there are hundreds of […]
A09.Informix HQ: What is new in InformixHQ
Introduction to Schema Manager Features and Custom Dashboard.
C09. Monitoring Informix with Prometheus and Grafana
Observability aids increase Database Availability, which in turn drives up customer trust and business revenue. Grafana, Prometheus, Telegraf are the popular open-source products for monitoring databases today. This presentation exhibits how these products can be used for monitoring, analyzing, and visualizing key Informix database servers KPIs and metrics. A custom shell script was written to […]
B09. Why use Automatic Space Management?
Traditionally, one of the more mundane jobs of a DBA has been to add space when needed. The introduction of automatic space management in Informix has made that task simpler, and at the same time given the DBA additional ways to perform that task. You can now stretch out cooked chunks, automatically or manually…no more […]
A10. What's new in Replication?
This session covers various additions in 14.10 related to replication (ER, HDR, RSS & SDS)
B10. Informix and CloudPak for Data - "All-in-One" Demo
At the beginning of the session we will discuss how to create the external connection to the Informix instance running in the CP4D. We will explain in the detail how and where to get the required parameters for the sqlhosts setting. After that we will demonstrate the correct connection setting in the remotely running dbaccess […]
C10. Analytics with Python, Notebooks and Informix
Python is the language of choice for many data scientist. Notebooks have become a popular environment for interactive work with databases. This presentation shows how Python and Notebooks can be used for accessing, analyzing and visualizing data stored in Informix databases. This will be done on the basis of frequent use cases.
A11. Conversion/Reversion for HDR/RSS Secondaries
This session covers conversion support for HDR/RSS secondary servers that avoids rebuilding of the secondary servers from backup.
B11. Happy Database=Happy Life - keep Informix up and running
Are you fed up with “No more pages” errors, and “Logical Log Files are Full” messages? Keep your system running smoothly by taking proactive action before problems occur! This presentation will cover some of the things to watch out for, and provide practical examples for monitoring the health of your database. Supporting databases for many […]
C11. Why you should move from ontape to onbar and backups from secondaries
This session covers the benefits of using onbar over the ontape. We will also cover advance features of onbar, like backup and restore different storage spaces in parallel, and On-Bar/ontape backups in RSS servers
A12. Why/how to use openssl; SSL communication and certificates
Configuring SSL certificate for application development using openssl.
B12. Data Management Console (DMC) for Informix on Cloud Pak
Highlight the Data Management Console for Informix in Cloud Pak for Data
C12. IDS smart monitoring using InformixHQ
*How to configure Agent for a secure connection ( SSL ) *Configuring Sensors for collecting monitoring data *Creating Alerts for sensors *Configuring SMTP for the Alert Incidents *New UI for the Incident screen with advanced filter
A13. Ask the Experts
C14. Developing IoT and Hybrid applications with 4GL: am I dreaming or is this really
4GL is known among our community as a great language for ERP and backend applications, but when it comes to cloud or more sophisticated environments like hybrid programming: end of the game!!! In this sessions, we will show: how to use Lycia 4GL instructions and data types that will make it possible achieve solid and […]
Informix Badge Preparation Training Part Two
IBM has recently released an Informix v.14.10 badge exam. It covers version 14.10 up to, but not including FC6. Together, Scott Pickett and Carlton Doe are covering all the technology and features tested in the exam. Each session will cover about half the material. These are “Death by Powerpoint” type sessions, there are hundreds of […]