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.
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.
Related topic