IBM SQL Tuning Services

SQL Tuning Services consists of a set of SQL analysis and tuning features that are delivered as RESTful APIs. You use these features to analyze and tune SQL applications that work with Db2® for z/OS®.

Some of the SQL Tuning Services features, including Visual Explain, Statistics Advisor, and Capture Query Environment, are available to licensed Db2 for z/OS users at no additional cost through the IBM® Database Services Expansion Pack feature of Db2 Accessories Suite for z/OS. An extended set of tuning features, including Access Path Advisor, Access Path Comparison, Index Advisor, and more, are available with IBM Db2 Query Workload Tuner for z/OS 6.1.

A list and descriptions of the APIs are available in the API reference topic. For the most current information about these APIs, consult the swagger doc that is available after you install the product at https://service_ip:httpsport/ tuningservice/v1/swagger-ui/index.html.