Viewing Integration Services Users with Locks

The CB_CONCURRENCY table in OLAP Metadata Catalog contains information about the users who access OLAP models and metaoutlines. This table contains the following columns:

CB_USER_NAME: the name of the user accessing the OLAP model or metaoutline; for example, sa.
CB_USER_SESSION_ID: a system-generated reference number that uniquely identifies an editing session
CB_OBJECT_ID: an OLAP model or metaoutline number
CB_OBJECT_TYPE: a type reference that indicates whether the user is accessing an OLAP model or a metaoutline
- The number 1 represents an OLAP model.
- The number 2 represents a metaoutline.
CB_OBJECT_LOCK: a lock reference number that indicates whether the user has a read or write lock
- The number 1 represents a read lock.
- The number 2 represents a write lock.
CB_LOCK_TIMESTAMP: the date and time that the user acquired the lock

To determine which users are accessing a specific OLAP model or metaoutline:

Enter the following SELECT statement in the OLAP Metadata Catalog database, using the tools for the data source you are using:
```
SELECT CB_USER_NAME, CB_OBJECT_ID, CB_OBJECT_TYPE,
       CB_OBJECT_LOCK, CB_LOCK_TIMESTAMP
FROM CB_CONCURRENCY
```
View the results.
In the following example, the sa user is the only user currently accessing an OLAP model or metaoutline. The sa user has two read locks on one OLAP model and one read lock each on two different metaoutlines.
```
CB_USER_NAME CB_OBJECT_ID CB_OBJECT_TYPE CB_OBJECT_LOCK CB_LOCK_TIMESTAMP
------------ ------------ -------------- -------------- -----------------
sa           889844639        1               1         Apr 9 2004 4:43PM
sa           889845263        2               1         Apr 9 2004 4:43PM
sa           889844639        1               1         Apr 9 2004 5:20PM
sa           892167813        2               1         Apr 9 2004 5:20PM
                                                      (4 row(s) affected)
```
You can determine the following information from the sample CB_CONCURRENCY table shown in the preceding list:
- The first row of the results tells you that the sa user (CB_USER_NAME = sa) has a read lock (CB_OBJECT_LOCK = 1) on an OLAP model (CB_OBJECT_TYPE = 1) with an ID of 889844639.
- The second row of the results tells you that the sa user (CB_USER_NAME = sa) has a read lock (CB_OBJECT_LOCK = 1) on a metaoutline (CB_OBJECT_TYPE = 2) with an ID of 889845263.
- The third row of the results tells you that the sa user (CB_USER_NAME = sa) has a read lock (CB_OBJECT_LOCK = 1) on an OLAP model (CB_OBJECT_TYPE = 1) with an ID of 889844639.
- The fourth row of the results tells you that the sa user (CB_USER_NAME = sa) has a read lock (CB_OBJECT_LOCK = 1) on a metaoutline (CB_OBJECT_TYPE = 2) with an ID of 892167813.

When you open a metaoutline, you receive a read lock on the metaoutline and on the OLAP model on which it is based; therefore, you can assume that the sa user is working on two different metaoutlines based on the same OLAP model.