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.