Show TOC

Displaying Active LocksLocate this document in the navigation structure

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.

You can choose from the following lock modes:

  • 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 protects data (reference data for planning functions for example) against changes at runtime.

    Note

    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 finds all existing locks for the planning-relevant InfoProviders in this InfoProvider (aggregation levels or MultiProviders, for example).

  2. Select the user. You can use wildcard searches, like 'PRE*'or '*ABC*'. The active locks are listed in the Locks: Header Entries table and the Lock Records table.

  3. Notify the user and delete any locks.

    Note

    If you want to delete active locks, use SAP lock management (transaction SM12). Depending on where the lock table is stored, you might 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.

    In SAP lock management (transaction SM12), you cannot see which data records are locked however. To do this, use the maintenance transaction for lock settings in planning (transaction RSPLSE).