Record Lock Tracking Utility

Menu Path: System Administration Images\bluerarw.gif Utilities Images\bluerarw.gif Record Lock Tracking Utility

Purpose

View information about locked records.

Overview

Use Record Lock Tracking Utility to display locked record information, such as the user that has locked records. You can also output a log of locked record and transaction information to a file. A record is locked when it is being updated by a user. When a record is locked, another user cannot update it, so it is important to track the records that are locked.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Record Lock Tracking Utility window.

Show Data

Click this button to display locked record information in the Locks grid and transaction information in the Transactions grid based on the selected criteria.

See File

Click this button to view output locked record information in the default Windows spreadsheet application. This button is only enabled if a record is displayed in the Locks grid, and the File check box is selected.

See Record

Click this button to view output locked record information in the default Windows text file viewer application. This button is only enabled if a record is displayed in the Locks grid.

Get Call Stack

Click this button to view output call stack (active subroutine) information in the default Windows text file viewer application for the selected record lock. This button is only enabled if a record is displayed in the Locks grid.

NOTE The AppServer must be the same for the current user and the user that locked records.

Main Tab Fields and Buttons

Field or Button

Description

User Options

Select whether to view locked records for yourself, all users, or a specific user. If you select the Specific User radio button, specify the user ID in the User field.

Transaction Options

Select whether the Transactions grid displays transactions for all locked records or only a locked record selected in the Locks grid.

User

Click the Lookup button to select a user ID for which to view locked records. This Lookup button is only enabled if you select the Specific User radio button.

File

Select this check box to output the locked record and associated transaction information to two files. If you select this check box, enter the folder paths and names for the files in the Lock File and Transaction File fields.

Display Other DB User Columns

Select this check box to display information for record locks of other databases (e.g., a custom database).

Lock File

Enter a folder path and file name for the output locked record information, or click the Lookup button to select a path and file name. This field is only enabled if the File check box is selected.

Display Exclusions

Select this check box to display locked records for tables that are commonly locked, which do not cause performance issues. This check box is cleared by default.

Transaction File

Enter a folder path and file name for the output transaction information, or click the Lookup button to select a path and file name. This field is only enabled if the File check box is selected.

Highlight Deadlocks

Select this check box to highlight deadlocks in red in the Locks grid. A deadlock occurs when two actions are each waiting for the other to finish.

Locks

This grid displays locked record information based on the selected criteria. The check box in the Waiting column is selected for a record for which a user (other than the one who locked the record) is waiting.

Transactions

This grid displays transaction information for all locked records or a selected locked record (based on the selected option for the Transaction Options radio set).