Features and required tools
This section lists the features and the tools that are required to enable them.
| Tool | Feature | Reference |
|---|---|---|
| IBM® Db2® SQL Tuning Services for z/OS
Note: This is part of the IBM Db2 Accessories Suite for z/OS.
|
Tune a single query | |
| Explore tuning jobs and profiles | ||
| Explore SQL from sources | ||
| IBM Db2 Query Workload Tuner for z/OS® | All features provided by IBM Db2 SQL Tuning Services for z/OS | |
| Tune a workload | ||
| Create EXPLAIN tables for profiles | ||
| Query tuning advisor | ||
| IBM Db2 Administration Tool for z/OS | View storage, statistics, utility status, and utility history. | |
| Run Db2 and DSN commands | ||
| Generate DDL for multiple objects | ||
| IBM Db2 Automation Expert for z/OS | Run Db2 utilities (COPY, REORG, RUNSTAT) | |
| Run Db2 and DSN commands | ||
| View storage, statistics, utility status, and utility history. | ||
| IBM Db2 Analytics Accelerator for z/OS | Paired accelerators with subsystems | |
| Access IBM Db2 Analytics Accelerator Administration Services | ||
| IBM Db2 Analytics Accelerator Loader for z/OS | Load to accelerator | |
| IBM Db2 Analytics Accelerator Loader Server for z/OS
Note: This is part of the IBM Db2 Analytics Accelerator Loader for z/OS.
|
Discover and register IBM Db2 Analytics Accelerator Loader Server for the virtualization of mainframe data sources | |
| Explore virtual objects of mainframe data sources | ||
| Load to accelerator using virtual objects of mainframe data sources | ||
| Create a virtual table for IMS |