Collecting service SQL documentation
Service SQL documentation is the standard format for query problem analysis documentation, for use by IBM® Support. It includes the data definition statements (DDL), catalog statistics, EXPLAIN records, and other data that describes a Db2 for z/OS® environment.
Before you begin
- Ensure that the latest Db2 maintenance is applied.
- You must have appropriate Db2 administrative authority.
- If you want to report an access path performance problem and you have not already done so,
complete the following tasks first:
- Investigate the problem, as described in Investigating access path problems.
- If you are unable to resolve the problem, collect diagnostic data, as described in Collecting data for access path performance problems.
About this task
The service SQL documentation includes information that describes the following aspects of the environment for Db2 for z/OS SQL statements:
- Objects such as tables, indexes and views that are referenced by the SQL statements
- Catalog statistics the Db2 to select access paths for the SQL statements
- EXPLAIN table information that describes access paths for the SQL statements
- Db2 module details
- Subsystem parameter settings
IBM Support can use this information to re-create and analyze the performance problems.
Procedure
To generate problem analysis documentation for a Db2 environments:
What to do next
For information about submitting the service SQL data to IBM Support, see Contacting IBM Support about Db2 problems.