Overview of DB2 data extractor

In order to use the DB2® Performance Analysis Reports, the DB2 data extractor must be turned on when the Observation Request is entered. You must select the DB2 data extractor in the Schedule New Measurement panel.

The DB2 extractor collects measurement data directly related to SQL activity. During each sampling interval, Application Performance Analyzer interrogates DB2 to determine if the application or transaction is currently performing a DB2 request. If it is, a DB2 measurement record is created that describes the request. If the request was to process an SQL statement then details of the SQL statement are also recorded. These DB2 records later are analyzed to produce the DB2 reports.