Wait Situations 

The SQL Locks user menu also contains a display of exclusive wait situations.

Use this analysis, for example, in the following situation: You are using the Task Manager to monitor tasks with the Vwait state over a longer period of time.

Prerequisites

The user has been assigned a role in accordance with the authorization concept.

You are in the user menu of the user with the authorizations that correspond to this role.

The liveCache database instance is in the ONLINE operational state.

Procedure

...

       1.      In the user menu, choose liveCache Assistant(transaction LC10).

       2.      Enter the name of the database connection.
You can select the name from the list of existing names. You can restrict the search for the required name.

       3.      Choose liveCache → Monitoring.

       4.      Choose Problem Analysis → SQL Locks → Wait Situations.

Result

The system displays a list of all current wait situations for SQL locks in the liveCache database instance.

Exclusive locks can significantly reduce the performance of the liveCache database instance.

You can also use options provided in the Console.

See also:

Concepts of the Database System, Overview of Task States