.
Locking activity reports
The reports in this section are sample lock trace activity reports. The batch lock trace activity reports provide the following reports for Db2 performance lock trace data:
- Summary reports
- Lock trace reports
- Timeout report
- Deadlock report
Summary reports
The lock trace activity summary reports summarize the associated events across the entire selected interval, and by up to 2 selected GROUPBY qualifiers. The default GROUBPY qualifiers are AUTHID and PLAN.
The reports automatically summarize by lock resource name, and produce sub-totals at the main grouping levels.
The following reports are included:
Report | Title | Sample report |
|---|---|---|
BLKSUMSU | Lock summary suspensions | |
BLKSUMLO | Lock summary lockout report | |
BLKSUMDT | Lock summary detail report |
Lock trace reports
The lock trace reports display details from each associated event record in chronological order, without summarization.
The following reports are included:
Report | Title | Sample report |
|---|---|---|
BLKTRCSU | Lock trace suspensions report | |
BLKTRCLO | Lock trace lockout report | |
BLKTRCDT | Lock trace event detail report |
Timeout report
The following reports are included:
Report | Title | Sample report |
|---|---|---|
BTIMEOUT | DB2 timeout report |
Deadlock report
The following reports are included:
Report | Title | Sample report |
|---|---|---|
BDEADLOCK | DB2 deadlock report |
Related topic