Configuring DB2 for z/OS subsystems for Visual Explain

Before you can use Visual Explain for SQL statements that run on DB2® for z/OS® subsystems, you must configure your DB2 subsystem to bind the required packages, create EXPLAIN tables, and grant privileges and access to users.
In the following products, you can use Visual Explain to view the access plan graph of the SQL statements. Before you use Visual Explain, you must configure your subsystem.

For all these products, you can configure the subsystem for Visual Explain by running a JCL job on the server. For Data Studio, Optim Query Tuner, and Optim Query Workload Tuner, you can also configure the subsystem for Visual Explain by following a wizard in the workbench.


Feedback