Database locks are used to prevent more than one user from editing the same information at the same time. Locking is necessary to insure database integrity. However, locks can sometimes be held for too long for trivial reasons. In these cases, you may want to examine and release locks, as needed.
To review the locks on your database, go to
. The Process/Lock Manager window will show you all the processes and locks currently in use. As you can see in the following screenshot, you can "kill" processes on this screen by right-clicking on the process you want to release:The Lock Manager utility is only available to admin users.
The default filter shows all active processes and locks. You can build your own search criteria using the following options:
Select a filter from the list of available filters, then select the
button to generate search results. Only saved filters will appear in this list.Select this button to show the parameters underlying the saved filter. To hide the parameters, click the
button a second time.When building a custom query, you have the following options:
Select to add a new parameter to the query.
Select to remove a parameter from the query. This option is disabled for default parameters.
Select to save your filter for future use. Saved filters will appear in the list of available filters.
Select to manage your saved filters. To learn more about managing filters, please see Section 2.1.2, “Search Filters”.