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.