Generate lock graph html output (ttstplocklog)
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:
- In the Generate Snapshot tab, specify the information required to generate the snapshot file. For details, refer to the field help.
- In the Generate Snapshot tab, click . The session generates the snapshot file.
- In the Generate HTML tab, specify the information required to generate the html report. See the field help.
- In the Generate HTML tab, click . The session generates the html report.
- In the Generate HTML tab, click . The generated report is displayed in your default html browser.
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
- Displays the html report file, specified in the Target field, in your default html browser.