HP Neoview Release 2.4 Software - Manual (Page 32)

NOTE: Neoview Query Viewer does not show the Get Session or Load Triage buttons.
Configure Live View Options
To configure the Live View options, use the Tools>Options menu to adjust the settings. From
the Options menu, you can set the following options:
Controls This Option ...
Displays the number of seconds to wait for establishing a connection. Connection Timeout
Displays the number of seconds to wait when executing any command. The default value
is 600 (seconds). To ensure that query management actions execute correctly, do not set
this value to a value lower than 600. Command Timeout
Controls the maximum number of data points to graph for trending statement counters
and platform performance indicators. This is the amount of historical information the
client keeps in memory. Live Range
Controls whether times are displayed in the local client time zone or in the time zone
where the Neoview platform resides. Show times in local time
zone
Controls whether SQL statements that are transaction boundaries (such as
BEGIN/COMMIT WORK or BEGIN TRANSACTION/END TRANSACTION) are retrieved
and displayed. Filters transaction boundaries. This option can also be controlled from
the Live View Options right-click menu. Hide Transaction Bounds
Controls whether recently executed SQL statements (in the last minute) are also
downloaded and displayed along with currently running queries as per the repository.
This option can also be controlled from the Live View Options right-click menu. Hide Completed Queries
Customize the Live View
To customize the list of columns you want to display, right click on the grid or on the tabular
listing of queries and select the Customize Grid Columns menu item. When you select the
Customize Grid Columns option, a dialog box appears that allows you to individually select or
deselect the list of columns of the list of running queries that you wish to display in tabular form.
Save your customized layout with the Workspace menu Save option. The layout is stored in
the Neoview Performance Analysis Tools installation directory. The layout is called default.wks
and is stored in this directory: C:\Program Files\Hewlett-Packard\Neoview
Performance Analysis Tools
.
You can customize and set the refresh frequency on the right-click menu on the grid. The default
refresh frequency is 5 minutes for a Release 2.2 platform and 30 seconds for a Release 2.3 or later
platform (WMS-enabled). The right-click menu also shows the query view options shortcuts.
This controls whether completed SQL statements or SQL statements that are transaction
boundaries are downloaded and displayed in the Live View.
The right-click menu allows you to select all the queries in the display (grid or tabular) and copy
the details to the clipboard. You and the DBA role can kill the queries that you own.
Kill Queries
The Kill Selected Queries option allows you to kill the selected queries in the Live View. You
must own the selected queries. Select one or more queries, and select the Kill Selected Queries
option from the right-click menu. A dialog appears that asks you to confirm the operation. This
operation is performed asynchronously, and after it completes, a notification bubble appears
which provides the status of the background operation (query kill). After the operation completes,
the query row changes color and the query state changes to Abnormally Terminated. Queries
with the Abnormally Terminated state will age out and be removed from the display.
32 Use the Live View Pane