Creating EXPLAIN tables

This topic provides instructions for creating the EXPLAIN tables that SQL Tuning Services uses to store information about SQL statements, access paths, and other elements that can affect SQL performance.

About this task

Each tuning target database requires a set of EXPLAIN tables. Creating the EXPLAIN tables is a one-time step for each Db2® tuning target database. SQL Tuning Services provides an API to create these EXPLAIN tables or you can create EXPLAIN tables by referring to the Db2 for z/OS® EXPLAIN tables documentation.

Note: If the complete set of EXPLAIN tables already exists on a tuning target database, you do not need to complete this step for that database. SQL Tuning Services can use the existing EXPLAIN tables.

Procedure

Create EXPLAIN tables by referring to the Db2 for z/OS EXPLAIN tables documentation or by using the EXPLAIN Tables Management API.

If you use the EXPLAIN Tables Management API, see Example POST requests for creating EXPLAIN tables for syntax for the supported security mechanisms.