Bookshelf v7.5: Server Session Management

Siebel Analytics Server Administration Guide > Administering the Query Environment >

Server Session Management

The Session Manager is used in online mode to monitor activity. The Session Manager shows all users logged into the Siebel Analytics Server and all current query requests for each user. The Siebel Analytics Server administrator can disconnect any users and kill any query requests with the Session Manager.

Using the Session Manager

The Session Manager contains two windows:

The top window, the Session window, shows users currently logged into the Siebel Analytics Server.

The bottom window, the Request window, shows active query requests for the user selected in the Session window.

Table 17 and Table 18 describe the columns in the Session Manager windows.

Table 17. Fields in the Session Window
Column Name	Description
Session ID	The unique internal identifier that the Siebel Analytics Server assigns each session when the session is initiated.
Query Server	The Siebel Analytics Server that serviced the request.
User	The name of the user connected.
Client Type	The type of client connected to the server.
Catalog	The name of the presentation catalog to which the session is connected.
Repository	The logical name of the repository to which the session is connected.
Logon Time	The timestamp that shows when the session initially connected to the Siebel Analytics Server.
Last Active Time	The timestamp of the last activity on the session.

Table 18. Fields in the Request Window
Column Name	Description
Session ID	The unique internal identifier that the Siebel Analytics Server assigns each session when the session is initiated.
Query Server	The Siebel Analytics Server that serviced the request.
Request ID	The unique internal identifier that the Siebel Analytics Server assigns each query when the query is initiated.
Start Time	The time of the individual query request.
Last Active Time	The timestamp of the last activity on the query.
Status	The status of the query. See Siebel Analytics Server Administration Tool Online Help for the meanings of the different statuses.
Description	Not used.

To open the Session Manager

In the Administration Tool, open a repository in online mode, and then select Manage > Sessions.

To disconnect a user from a session

Select the user in the Session Manager top window.

Click Disconnect.

The user session receives a message indicating that the session was terminated by an administrator. Any currently running queries are immediately terminated, and any outstanding queries to underlying databases are canceled.

To kill an active query

Select the user session that initiated the query in the top window of the Session Manager.

Once the user is highlighted, any active query requests from that user are displayed in the bottom window.

Select the request you want to kill.

Click Kill Request to terminate the highlighted request.

The user receives a message indicating that the query was terminated by an administrator. The query is immediately terminated, and any outstanding queries to underlying databases are canceled.

Repeat this process to kill any other requests.

To control the update speed

Select Normal, High or Low from the Update Speed drop-down list. Select Pause to keep the display from being refreshed.

How often the Session Manager display refreshes is a function of the amount of activity on the system.

To refresh the display at any time, click the Refresh button.