Skip to Content
Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Data Collector

At the heart of 

SQL Performance

’s data collection capabilities is the Data Collector, which provides user access to performance data.

Data Collectors are defined in the DOMPLEX option set. You can define any number of Data Collectors on each IBM z/OS system (only if each Data Collector is defined to only one DOMPLEX). Each Data Collector can monitor any number of Db2 subsystems and can support up to 999 concurrent users. In addition, the Data Collector can issue commands on behalf of SQL Performance users to IBM Db2 or z/OS, and OPERTUNE for DB2.

Related topic

SQL-Performance-for-DB2-architecture

The Data Collector’s unique method of gathering information eliminates the need for expensive SQL traces by retrieving data directly from Db2 control blocks and trace data sets to satisfy requests from users. This collection method creates records of summarized accounting statistics, object access statistics, SQL text, and SQL error data—and writes them to LOGSET files.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

SQL Performance for DB2 13.1