SQL Activity reports and traces
SQL Activity reports and traces show information about SQL activities that occur during the processing of a DB2 application.
Use this report set to:
- Analyze SQL calls within a logical unit of work.
- Analyze the access paths selected by the DB2 optimizer for local SQL calls.
- Observe the Data Manager scans, locking, buffer manager I/O and other related DB2 activity that occur during the execution of SQL requests.
- Collect the SQL activity according to author, plan name, or other OMEGAMON for Db2 Performance Expert identifiers.