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 problems.

The session first generates a snapshot file, based on the locking log file(s). 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 the following 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, complete the following steps:

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 Generate. The session generates the snapshot file.
In the Generate HTML tab, specify the information required to generate the html report. For details, refer to the field help.
In the Generate HTML tab, click Generate. The session generates the html report.
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 Logging Parameters (ttaad4153m000) session.

Generate Snapshot

Log File / Dir

The location of the log file(s) where the database locking information is logged.

The session reads log information, for a specified time frame, from the specified log files and stores this information in a snapshot file. Then, the session generates an html report based on the snapshot file.

Note

If there is one log file, specify the path and name of the file. For example: /usr/bse/tmp/log_locking.1048612.
If there are multiple log files, specify the directory where the files reside. For example: /usr/bse/tmp.

Snapshot file

The path and name of the snapshot file to be generated. This file contains the log information for the selected date and time range.

Important!

The snapshot file must be stored in a folder different from the folder that contains the log files.

Date/Time

Use this field to specify the time frame for the log information that will be stored in the snapshot file.

Generate HTML

Target

The path and name of the html report file to be generated. For example: /home/jsmith/db_lock_report.html.

Date/Time

Use this field to specify the time frame for the log information that will be displayed in the html report.

All Tables

If this check box is selected, the report displays log information for all tables, for which log information is present in the snapshot file.

If this check box is cleared, you must select a table for which the report will display log information.

Table

The package code of the table for which the report will display log information.

Table

The module code of the table for which the report will display log information.

Table

The table number of the table for which the report will display log information.

All Companies

If this check box is selected, the report displays log information for all companies, for which log information is present in the snapshot file.

If this check box is cleared, you must select a company for which the report will display log information.

Company

The company for which the report will display log information.

Top

Use this field to display the top n problems in the report.

Important!

You must enter a value greater than zero.

Example

Enter 15. The report shows the following:

Report section	Displayed content
Wait time summary	The 15 transactions with the longest wait times. The corresponding details are displayed in the Wait time details section.
Lock time summary.	The 15 transactions with the longest lock times. The corresponding details are displayed in the Lock time details section.
Long running transactions summary	The 15 transactions with the longest transaction durations. The corresponding details are displayed in the Long running transactions details section. The Long running transactions summary section and the Long running transactions details section are only displayed if the Transaction Details check box is selected.

Transaction Details

If this check box is selected, the report contains the following extra sections, which display statistics on the duration of long running transactions:

Long running transactions summary
Long running transactions details

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.