Display of Active Locks 

Use

On the Lock tab page, you can see the selections that are currently locked for each InfoProvider and user. This is similar to the Select Lock Entries function in SAP lock management (transaction SM12).

Features

Table Locks: Header Entries

The system displays the header entries for each locked selection (InfoProvider, User Name, Lock Mode, Lock Records, Lock Handle). The user name, number of records in the locked selection, and lock mode are of particular interest.

The following lock modes are available:

●      E (exclusive): Write lock that is used for all data that is edited in change mode; the data is locked and can be edited by one user only.

●      S (shared): Read lock that means that reference data for planning functions, for example, cannot be changed at runtime.

For more information about the lock modes, see SAP Lock Concept.

The lock handle (a 32-character GUID) represents a locked selection.

Table Lock Records

The system displays the locked selections. The display is grouped by header entry (Lock Handle), Characteristic, type of interval (Interval) and the lower and upper interval boundaries of the selection (Internal Characteristic Value). The selections themselves are normally displayed in the lock table: For each characteristic, each selection is a disjunctive union of open, half open and closed intervals.

The type of interval can be:

●      ( ) for an open interval

●      [ ) or ( ] for a half open interval

●      [ ] for a closed interval

Activities

...

       1.      Select the InfoProvider. The system determines all existing locks for the real-time InfoCubes that are included in the InfoProvider (the aggregation levels or MultiProviders, for example).

       2.      Select the user. You can use wildcard searches as follows: ‘PRE*’ or ‘*ABC*’. In the Locks: Header Entries table and the Lock Records table, the system lists the active locks.

       3.      Notify the user and if necessary, delete the locks.

If you want to delete active locks, use SAP lock management (transaction SM12). Depending on where the lock table is stored, you may have to select a different lock structure.

■       Lock table on SAP lock server: Table name RSPLS_S_LOCK.

■       Lock table in shared objects memory: Table name RSPLS_S_LOCK_SYNC.

■       Lock table in SAP liveCache: Table name LCA_GUID_STR.

However, in SAP lock management (transaction SM12) you cannot see exactly which data records are locked. To see which individual data records are locked, use the maintenance transaction for lock settings in planning (transaction RSPLSE).