The purpose of this presentation is to give an overview of methods used in everyday SQL tuning of transactional databases, when an SQL query or a Batch job is underperforming and a quick solution is required. Describe generally available tools in DB2 that can assist in the daily SQL tuning and/or SQL performance problem detection. Describe how to find out what is happening right now in a database. Describe how to gather historical performance data for a database. Describe how to analyse locking issues. Describe how to identify the hottest tables and SQL queries in a database. Show several real-life scenarios of poorly performing SQL and what was done to improve it.
This is a sequel to a last year's presentation on a then ongoing migration from an on-premise Db2 V11.1 mission-critical database to an AWS Cloud installation. The migration has been completed since, quite successfully and this presentation will pick up where the last one stopped, showing exactly what was done and how, including further lessons learnt and tips for others considering a similar DB2 migration.
SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.
8 reasons to come Speakers Events Contact
VODICE - 12th - 15th June 2023