DB2 z/OS EXPLAIN is a vital tool available for application developers and database administrators who need to understand what access paths have been chosen by the DB2 Optimizer, and why. This presentation starts with the very basics of DB2 for z/OS EXPLAIN, and builds on that to provide you with the understanding of its infrastructure. You will learn about the EXPLAIN tables, how to populate them and how to analyse the information in them.