Data Vault Administrator Guide

6.5
- 6.5.1
- 6.5 HotFix 1
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Viewing Queries

You can view a list of the queries received from clients connected to the Data Vault.

To view the list of queries received from clients, select the

All Queries

node under the

Clients

node in the navigation pane. The information pane displays the list of all queries received from clients.

The following table describes the information displayed for the list of queries:

Property	Description
ID	Query identifier assigned by the Data Vault Service.
Client ID	ID of the client that sent the query request.
Start Time	Date and time when the Data Vault Service received the query.
Running Time	Amount of time it took to process the query.
Query Type	Type of SQL operation that is performed by the query. The query can have the following types of operation: SELECT INSERT UPDATE DELETE
Source Type	Type of data queried. The source type can be one of the following types: Compressed table in the Data Vault (ARC) Data Vault repository (MDB)
SQL	SQL statement in the query.
Status	Status of the query. The query can have one of the following statuses: PREPARED. The Data Vault Service is preparing the query. EXECUTING. The Data Vault Service is currently running the query. FETCHING. The Data Vault Service has completed running the query and is currently sending the query results to the client. If the client does not close the session, the query remains in FETCHING status. FAILED. The Data Vault Service failed to complete the query. TERMINATED. The Data Vault Service terminated the query before the query was completed. UNKNOWN. Status information for the query could not be retrieved.
Tasks [T/S/C]	Number of tasks for the query. The number of task for a query is equivalent to the number of partition data files that the query must access. For example if the Data Vault Service must access 20 different partition data files to complete a query, the Data Vault Service creates 20 tasks for the query. The Data Vault Administration Tool displays the task information in the following format: `total tasks` -> `started tasks` -> `completed tasks` `Total tasks` is the total number of tasks that a query must perform. The total number of tasks include tasks that are not started, tasks that have started, and tasks that are complete. `Started tasks` is the total number of tasks started but not yet completed by the query. `Completed tasks` is the total number of tasks completed by the query.
Rows	Number of rows fetched by the query from the Data Vault.
Volume	Amount of data fetched by the query from the Data Vault.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Viewing Queries

Viewing Queries