The OLAPOPERATE Procedure

Listing Active Sessions on an OLAP Server

You can list information about active sessions on the OLAP Server with the LIST SESSIONS statement.

LIST SESSIONS [CUBE=cube-name ] [USER=user-id] [OUT=data-set];

If the CUBE option is specified, the output contains information about all sessions currently accessing the specified cube. If the USER option is specified, the output contains information about all sessions for the specified user. If neither option is specified, then all active sessions are displayed.

If the OUT option is specified, the output is written to the specified data set.

The LIST SESSIONS statement generates the following information:

Session ID: is the unique session identifier.

Session Owner: is the user ID of the session owner.

Seconds Inactive: is the number of seconds since the last query for this session.

Results Sets Open: is the number of open results sets for the session.

The following information is available for clients connecting to a SAS 9.2 or later version of the OLAP server:

Cube Names: presents the names of the cubes being used by this session.

Here is an output example for LIST SESSIONS.

Session ID: C3144659-F1B5-48E1-84D0-48DC439946A3
Session owner: olaptst1@CARYNT
Session name:
Session description:
Session seconds inactive = 69 and open results = 3

For clients connected to a SAS 9.2 or later OLAP server, the cubes that are active for the session are also listed.

Cube CENSUSCMR is active in this session.
Cube MDDBCARS is active in this session.