DQE Session Manager 

Definition

A portal utility that displays sessions running on the Distributed Query Engine, as well as the specific queries running in these sessions, and permits the portal administrator to view the details of any specific session and, if needed, to terminate a session, or its constituent queries.

Use

The Session Manager can display all processes, whether current or inactive, which have been launched for processing to the DQE. The Session Manager allows the portal administrator to manage these sessions, insofar it enables to monitor all sessions, current and inactive, or active sessions only.

The administrator can see which users have launched DQE sessions.

The administrator can see how long a session has been running, when the session queries were launched, and when query processing began.

The administrator can terminate sessions if needed, for example, sessions running for a long time with no results returned.

To access the Session Manager:

In the portal top-level navigation, choose System Administration ® Distributed Query Engine ® Session Manager.

Structure

The Session Manager iView is made up of two parts:

Sessions

The upper section, Sessions, displays the DQE sessions in tabular form, showing the user who launched the session and length of time for which the session has been running.

There is a checkbox above the table for showing active sessions only. Below the table are two buttons:

·        Details opens an additional table, Query Details in the lower part of the iView.

·        Terminate ends the processing of the selected session.

Query Details

The Query Details table, in the lower part of the Session Manager iView, shows the query of the selected session, including the following details

¡        Query string

¡        Query submit time

¡        Query processing start time

Below the table is a Terminate button for ending the processing of the selected query.