The SQL Activity Report

This topic shows examples of SQL Activity reports and the commands used to generate them.

These example reports are summarized and sorted at the following levels:
  • All
  • Cursor
  • Statement ID
  • Statement number
  • Statement type
  • Program
  • Thread

The SQL Activity report groups SQL Activity according to a combination of up to three OMEGAMON for Db2® PE identifiers. This grouping is applied to any SUMMARIZEBY, SORTBY, or WORKLOAD options you specify.

The ORDER subcommand specifies by which OMEGAMON for Db2 PE identifiers, and in which order, the SQL Activity is reported. If you specify no OMEGAMON for Db2 PE identifiers with ORDER, the default order of PRIMAUTH and PLANNAME is used.