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.
- IBM® Data Studio
- IBM InfoSphere™ Data Architect
- IBM Optim™ Database Administrator
- IBM Optim Development Studio
- IBM Optim Query Tuner and Optim Query Workload Tuner
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.