DB2 - Collecting data for database performance problems

In DB2 database performance troubleshooting , one of the challenges is to collect the right amount and type of data to assist the DBA to get clues. In How to report a DB2 performance problem there are questions to think about – guiding you towards a general approach to reporting a performance problem This post lists the information required when you’re sending me DB2 performance related queries. It gives me enough data to gain an overview of the database. It doesn’t guarantee a solution , but covers the main data sets. Run the following from a DB2 command window db2look... Read more →