SQL activity reports

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

Note

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