https://www.ibm.com/docs/en/db2/11.5.x?topic=cpcedgr-example-using-package-cache-information-db2advis-look-performance-improvement-opportunities
Using package cache information and db2advis to look for performance improvement opportunities
The Design Advisor can analyze SQL statements to make recommendations for how to improve database performance.