SQL activity reports

The reports in this section are sample SQL activity reports. The batch SQL activity reports provide the following reports:

Related topic

Important

Each of the SQL activity reports has two versions; one version has workload summaries, and one version does not.

The following workload summaries are provided in the workload version of each report:

Summary reports

The summary report supports GROUPBY thread summarization with the standard thread qualifiers, and summarizes SQL activity by package.

The following reports are included:

Report	Title	Sample report
BSQSUMP	Summary SQL by PGM/PKG	Summary-SQL-report-by-PGM-PKG-BSQSUMP
BSQSUMPW	Summary SQL by PGM/PKG with workloads	Summary-SQL-report-by-PGM-PKG-with-workloads-BSQSUMPW

The detail trace reports report threads separately and summarize SQL event data at the respective levels.

The following reports are included:

Report	Title	Sample report
BSQTRCP	Thread SQL trace summary by PGM/PKG	Thread-SQL-trace-summary-report-by-PGM-PKG-BSQTRCP
BSQTRCPW	Thread SQL trace summary by PGM/PKG with workloads	Thread-SQL-trace-summary-report-by-PGM-PKG-with-workloads-BSQTRCPW
BSQTRCS	Thread SQL trace summary by PGM/PKG and statement number	Thread-SQL-trace-summary-report-by-PGM-PKG-and-statement-number-BSQTRCS
BSQTRCSW	Thread SQL trace summary by PGM/PKG and statement number with workloads	Thread-SQL-trace-summary-report-by-PGM-PKG-and-statement-number-with-workloads-BSQTRCSW
BSQTRCT	Thread SQL trace by occurrence—event timestamp	Thread-SQL-trace-report-by-occurrence-event-timestamp-BSQTRCT
BSQTRCTW	Thread SQL trace by occurrence—event timestamp—with workloads	Thread-SQL-trace-report-by-occurrence-event-timestamp-with-workloads-BSQTRCTW
BSQLIX	SQL create thread index	SQL-create-thread-index-report-BSQLIX
BSQLLT	SQL long trace	SQL-long-trace-report-BSQLLT
BSQTRCCC	SQL compatibility exception trace by event	SQL-compatibility-exception-trace-by-event-report-BSQTRCCC