Blog

This session will provide an overview of the Db2 SQL performance tools and methods included in IBM i. The presentation will provide particular focus on obtaining value from Visual Explain, the Index Advisor and the SQL Plan Cache. These options leverage ‘always available’ information to make powerful tools readily available to the database engineer.

IBM i has delivered a web based interface for managing the IBM i for many years. Sadly, this interface was built back in the infancy of Web technologies and struggled when it came to usability and performance. Today we have a brand new Navigator! This interface is built on Angular and SQL Services. This session will show you how it can be used to manage multiple systems in a simple to use web infrastructure. Much of this session will be live demo showing the speed and simplicity of managing many aspects of your IBM i.

Db2 Web Query is the analytics family of products integrated with IBM i. In this session Doug Mack will cover options and considerations for deploying DASHBOARDS to the business or even for systems monitoring purposes that an IBM i Administrator might like! See the new DESIGNER, part of Version 2.3.0, and “Automated Insights” using AI/ML models in the cloud!

This session will cover, at a high level, many techniques for integrating Db2 and RPG workloads with almost anything. There will be particular emphasis on the recently announced HTTP functions in Db2. These functions enable HTTP requests to be made through simple SQL. The new functions are leaner, faster, and easier to use than their SYSTOOLS predecessors!