DB2 Query Patroller Administration Guide

QueryAdministrator

This chapter introduces the QueryAdministrator utility. It provides procedures for starting and stopping QueryAdministrator along with general information on how to use the QueryAdministrator main window.

Note:

The procedures in this portion of the manual assume that you have already installed QueryAdministrator according to the instructions in the DB2 Query Patroller Installation Guide.

About QueryAdministrator

QueryAdministrator is a utility that provides an easy-to-use interface for administering the DB2 Query Patroller system. QueryAdministrator is a Java application that runs on Windows 32-bit operating systems.

QueryAdministrator enables the system administrator to manage the DB2 Query Patroller system parameters, create or delete profiles for DB2 Query Patroller users, manage nodes, result destinations, and manage data sources.

Starting QueryAdministrator

Use the following procedure to start QueryAdministrator:

1. Select Start > Programs > DB2 > QueryAdministrator.

   The QueryAdministrator Login window displays.

2. Enter the user name, password, and the database alias.

3. Click OK.

   The QueryAdministrator main window opens:
   
   

Stopping QueryAdministrator

To stop QueryAdministrator, close the window.

Displaying Columns

When viewing information on any of the tabs in the QueryAdministrator main window, you can choose the columns you wish to have displayed.

To choose the columns to display, complete the following steps:

1. Click Choose Columns.

   The Select Columns for Display window opens:
   
   

2. To add a column to the display, do the following:

   1. Select the column to be added from the Available Columns list.

   2. Click Add>> to add the column to the Selected Columns list.

   3. Select the newly added column in the Selected Columns list.

   4. Click Up or Down to move the newly added column to the position where you want it to display.

3. To remove a column from the display select the column to be removed from the Selected Columns list and click <<Remove.

4. Click Apply when you have finished adding and removing columns.

Any changes you make to the columns displayed are retained for the current session only.

Resizing Columns

Whenever you are viewing information on a tab in the QueryAdministrator main window you can resize any column to a preferred width.

To resize a column, complete the following steps:

1. Move the mouse pointer to the vertical line forming the right edge of the column heading. The mouse pointer changes to a double arrow.

2. Left-click and hold the mouse button on the vertical line; move the line to resize the column.

3. Release the mouse button.

Any changes you make to the columns displayed are retained for the current session only.

[ DB2 List of Books | Search the DB2 Books ]