Generate lock graph html output (ttstplocklog)

Use this session to generate an html report that shows the database lock history. You can use this report to identify, for example, long waiting times, long locks and retries, which cause performance issues.

The session first generates a snapshot file, based on the locking log files. This file contains all, or a subset of, the log records. Then, the session generates an html report that displays the contents of this snapshot file.

The report consists of these sections:

Section Description
legend Explains the terms used in the report.

Total wait time per table

Wait time summary

Wait time details

These sections show wait time statistics.

The wait time is the time between the moment a physical lock is requested and the moment the physical lock is successfully set.

Total lock time per table

Lock time summary

Lock time details

These sections show lock time statistics.

The lock time is the time between the moment the physical lock is successfully set and the end of the transaction (commit/abort).

Long running transactions summary

Long running transactions details

These sections show statistics on the duration of long running transactions.

The transaction duration is the time from the first logical lock until the end of the transaction (commit/abort).

These sections are only displayed if the Transaction Details check box is selected.

To generate and view the html report:

  1. In the Generate Snapshot tab, specify the information required to generate the snapshot file. For details, refer to the field help.
  2. In the Generate Snapshot tab, click Generate. The session generates the snapshot file.
  3. In the Generate HTML tab, specify the information required to generate the html report. See the field help.
  4. In the Generate HTML tab, click Generate. The session generates the html report.
  5. In the Generate HTML tab, click View. The generated report is displayed in your default html browser.
Note: You can only use this session if the logging of database locks is enabled. To enable this logging, use the session.

Actions/Reference menu

These options are available:

Generate

Generates the snapshot file and the html report file.

To view the generated report in your default html browser, click View

View
Displays the html report file, specified in the Target field, in your default html browser.