Understanding TM1 lock modes

TM1® uses a set of three lock modes to control access to TM1 data.

When the TM1 server is running, these locks are applied to individual objects, such as cubes, views, and dimensions, as these objects are accessed.

TM1 Top displays the status of these locks for the objects being used by the current threads running in a TM1 server. Lock status is displayed by TM1 Top under the State, Obj Lock Status, and Total Lock Status fields.

The lock modes for TM1 objects are described in the following table.

Lock Mode

Description

R

R-lock (read lock) - A shared lock that allows many threads to read from an object at the same time, but does not allow another thread to modify or write to this object until all R-locks have been released.

IX

IX-lock (intent-to-write-lock) - A lock that reserves the right for a thread to obtain a W-lock on an object when all R-locks have been released. Only one thread at a time is allowed to have an IX-lock on an object.

W

W-lock (write lock) - An exclusive lock that allows only one thread at a time to access and write changes to an object. No other thread can read or modify this object until the W-lock has been released.