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 InfoSphere Optim™ Query
Tuner and InfoSphere 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, InfoSphere Optim Query Tuner, and InfoSphere Optim Query
Workload Tuner, you can also configure the subsystem for Visual Explain
by following a wizard in the workbench.