| 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
Fields | Description
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
Fields | Description
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
Commands | Description
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.