Collapse AllExpand All

12.3. Lock Manager

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 System > Utilities > Process/Lock Manager. 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:

Lock Manager List

Note

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:

Filter

Select a filter from the list of available filters, then select the QUERY button to generate search results. Only saved filters will appear in this list.

MORE

Select this button to show the parameters underlying the saved filter. To hide the parameters, click the MORE button a second time.

Query Builder

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.

SAVE

Select to save your filter for future use. Saved filters will appear in the list of available filters.

MANAGE

Select to manage your saved filters. To learn more about managing filters, please see Section 2.1.2, “Search Filters”.