Bookshelf v7.8.2: Server Session Management

Server Session Management

The Session Manager is used in online mode to monitor activity. The Session Manager shows all users logged into the session, all current query requests for each user, and variables and their values for a selected session. Additionally, the administrator can disconnect any users and kill any query requests with the Session Manager.

How often the Session Manager data refreshes depends on the amount of activity on the system. To refresh the display at any time, click Refresh.

Using the Session Manager

The Session Manager contains an upper and a lower pane:

The top window, the Session window, shows users currently logged into the Analytics Server. To control the update speed, from the Update Speed drop-down list, choose Normal, High, or Low. Select Pause to keep the display from being refreshed.

The bottom window contains two tabs.

The Request tab shows active query requests for the user selected in the Session window.
The Variables tab shows variables and their values for a selected session. You can click the column headers to sort the data.
NOTE: Only 7.7 Analytics Server return information about variables. If the Administration Tool connects to an older-version server online, only the Requests tab will be visible in the Session Manager dialog box.

Table 33 and Table 34 describe the columns in the Session Manager windows.

Table 33. Fields in the Session Window
Column Name	Description
Session ID	The unique internal identifier that the Analytics Server assigns each session when the session is initiated.
User	The name of the user connected.
Client Type	The type of client connected to the server.
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 Analytics Server.
Last Active Time	The timestamp of the last activity on the session.

Table 34. Some Fields in the Request Tab
Column Name	Description
Session ID	The unique internal identifier that the Analytics Server assigns each session when the session is initiated.
Request ID	The unique internal identifier that the 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.

To view the variables for a session

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

Select a session and click the Variables tab.

For more information about variables, see Using Variables in the Analytics Repository.

To refresh the view, click Refresh.

To close Session Manager, click close.

To disconnect a user from a session

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

Select the user in the Session Manager top window.

Click Disconnect.

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

To close Session Manager, click close.

To kill an active query

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

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

After 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 the administrator. The query is immediately terminated, and any outstanding queries to underlying databases are canceled.

Repeat this process to kill any other requests.

To close Session Manager, click close.