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.