Setting up an SQL Tuning Services user environment

Use the instructions in this section to set up a user environment after SQL Tuning Services has been installed successfully. SQL Tuning Services.

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.
Creating a tuning profile
A tuning profile is a set of JDBC connection information that makes a Db2 for z/OS tuning target subsystem available to SQL Tuning Services. It includes a valid Db2 for z/OS user ID and password, security information, and location information for the tuning target subsystem (host, location, and so on).
Invoking SQL Tuning Services APIs
Verify that your SQL Tuning Services environment is set up correctly by invoking an SQL Tuning Services API from the Swagger interface.

Parent topic: IBM SQL Tuning Services