Hello,
I have a new article on my blog concerning using subqueries to improve performance. Applicable to Db2 across all platforms.
https://www.db2expert.com/db2expert/db2-sql-and-application-performance-part-3-using-subqueries-to-reduce-calls-to-the-data-server/
Cheers,
Dan Luksetich