Bookshelf Home | Contents | Index | Search | PDF

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, all current query requests for each user, and variables and their values for a selected session. Additionally, the Siebel Analytics Server 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 Siebel 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 Siebel Analytics Servers 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 26 and Table 27 describe the columns in the Session Manager windows.

Table 26.  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 27.  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 view the variables for a session

1. In the Administration Tool, open a repository in online mode and choose Manage > Sessions.
2. Select a session and click the Variables tab.
3. To refresh the view, click Refresh.
4. To close Session Manager, click close.

To disconnect a user from a session

1. In the Administration Tool, open a repository in online mode and choose Manage > Sessions.
2. Select the user in the Session Manager top window.
3. 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.

4. To close Session Manager, click close.

To kill an active query

1. In the Administration Tool, open a repository in online mode and choose Manage > Sessions.
2. 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.

3. Select the request you want to kill.
4. 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.

5. To close Session Manager, click close.

Bookshelf Home | Contents | Index | Search | PDF