Menu Path: System Administration Utilities Record Lock Tracking Utility
View information about locked records.
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.
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. |
Field or Button |
Description |
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. |
|
Select whether the Transactions grid displays transactions for all locked records or only a locked record selected in the Locks grid. |
|
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. |
|
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. |
|
Select this check box to display information for record locks of other databases (e.g., a custom database). |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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). |