HP Neoview Management Dashboard Client Guide for Database Administrators HP Part Number: 546618-001 Published: April 2009 Edition: HP Neoview Release 2.
© Copyright 2009 Hewlett-Packard Development Company, L.P. Legal Notice Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Table of Contents About This Document.......................................................................................................11 Supported Release Version Updates (RVUs)........................................................................................11 Intended Audience................................................................................................................................11 New and Changed Information in This Edition...............................................
Selecting Grid Rows and Columns............................................................................................36 Sizing Grid Rows, Columns, and Grid Height..........................................................................36 To resize a grid column:.............................................................................................................36 To resize a grid row:..............................................................................................................
Graph Object History......................................................................................................................53 Show Related Apps.........................................................................................................................53 Show Related Disks.........................................................................................................................54 Show Related Files......................................................................
Graph Type List...............................................................................................................................67 Graph Color Sync Check Box..........................................................................................................67 Graph Color Toggle Check Box.......................................................................................................68 Graph in Grid Window Check Box....................................................................
Computed...................................................................................................................................81 Manual........................................................................................................................................81 Trace Requests Check Box...............................................................................................................81 Trace Replies Check Box................................................................
List of Figures 1-1 4-1 6-1 6-2 6-3 6-4 6-5 6-6 6-7 7-1 8 Dashboard Entity Screen...............................................................................................................18 Minimum State Menu....................................................................................................................34 CPU Entity Screen.........................................................................................................................85 Disk Entity Screen...................
List of Tables 6-1 6-2 6-3 6-4 6-5 6-6 6-7 7-1 CPU Entity Attributes ..................................................................................................................86 Disk Entity Attributes ...................................................................................................................87 ProcessBusy Entity Attributes.......................................................................................................89 Query Entity Attributes .........................
About This Document This manual describes the Dashboard Client, which provides a network-wide system monitoring, statistics collection, and presentation infrastructure for Neoview platforms. You can use the Dashboard Client to monitor the performance and availability of CPU, Disk, ProcessBusy, Query, QueryRTS, Table, and TMF entities. Supported Release Version Updates (RVUs) HP Neoview Release 2.4 Intended Audience This manual is written for database administrators who use the Dashboard Client.
Chapter Describes... Chapter 5, Using the Client Property Sheets The Dashboard Properties window in the Dashboard Client interface and how to use it to customize your Dashboard environment Chapter 6, Using Entity Screen Information How to use the information provided by the most important Dashboard entities, including the Query Runtime Statistics and Table entities.
{ } Braces Braces enclose required syntax items. For example: FROM { grantee[, grantee]...} A group of items enclosed in braces is a list from which you are required to choose one item. The items in the list can be arranged either vertically, with aligned braces on each side of the list, or horizontally, enclosed in a pair of braces and separated by vertical lines.
Line Spacing If the syntax of a command is too long to fit on a single line, each continuation line is indented three spaces and is separated from the preceding line by a blank line. This spacing distinguishes items in a continuation line from items in a vertical list of selections. For example: match-value [NOT] LIKE pattern [ESCAPE esc-char-expression] Related Documentation This manual is part of the HP Neoview customer library.
Neoview Performance Analyzer Online Help Context-sensitive help topics that describe how to use the Neoview Performance Analyzer to analyze and troubleshoot query-related issues on the Neoview data warehousing platform. Neoview Reports Online Help Help topics that describe how to use the HP Neoview Reports Tool. Neoview Repository User Guide Information about using the Repository, including descriptions of Repository views and guidelines for writing Neoview SQL queries against the views.
HP Encourages Your Comments HP encourages your comments concerning this document. We are committed to providing documentation that meets your needs. Send any errors found, suggestions for improvement, or compliments to docsfeedback@hp.com. Include the document title, part number, and any comment, error found, or suggestion for improvement you have concerning this document.
1 Introduction to Dashboard Dashboard Client Overview The Neoview Management Dashboard provides an infrastructure for monitoring the operational status and performance of system resources and queries on the Neoview platform. The Dashboard Client runs on Microsoft Windows XP workstations and provides a graphical user interface (GUI) to Dashboard statistics and intelligent agent functions. The Client communicates with Dashboard server components on the Neoview platform through the Client Server Gateway (CSG).
Figure 1-1 Dashboard Entity Screen Client Features The Dashboard Client includes a powerful set of graphics, controls, and toolbars that help you perform ad hoc browsing, reporting, and analysis of application and statistics for a Neoview platform.
• • • • • Dashboards, which can be named, saved, and displayed to provide unique sets of user-defined graphic views Automated alerts and detailed notification reports that can be sent via wireless phone, pager, e-mail, or internet browser Reports that can be sent when objects change state and can be scheduled to report at various times of the day or stored for use in web content at the end of each analysis sample Reports that can be obtained by selecting a busy object such as a disk and then selecting Sho
stop the Host Session using the Session window's menus and toolbar. For more information, see “Session Window” (page 55). Real-time Data Management To minimize the amount of host I/O required for standard real-time displays, Dashboard maintains a real-time hierarchical cache of statistics. This data cache improves performance and provides fast response times for specific interactive queries.
Client Support for International Character Sets The Neoview Management Dashboard supports international character sets, including ISO8859-1, Japan Shift-JIS, and Unicode, with the following restrictions: • Non-ASCII character set support is provided for only the following entities, fields, window and a character: Entity Fields Query ClientID, ApplID, SQLText, DSN QueryRTS ClientID, ApplID, ServiceName, QueryName Table Domain Name, Catalog, Schema, Table Name, Columns (Missing Stats), Repair Action
2 Installing the Client For the software and instructions you need to install the Dashboard Client on a Windows XP workstation, see the HP Software Depot homepage at: http://www.software.hp.com From the HP Software Depot homepage, search for Neoview Dashboard to locate the Client software executable and installation instructions. Select the product, place your free order, and download the software to your workstation.
3 Starting and Running the Client This section describes these topics: • • “Starting the Dashboard Client” “Starting and Configuring the Client Server Gateway (CSG)” Starting the Dashboard Client To start the Dashboard Client from Microsoft Windows, click the Start button on the Windows taskbar, select Programs, and click the Neoview Management Dashboard menu item. When started, Dashboard displays a startup dialog box with Setup, Connect, and Cancel buttons, which should be used as shown: Button Use to..
4 Using the Client Windows You use the Dashboard Client to obtain real-time and historical views of the Neoview environment, to see everything from generalized overviews of availability and performance for system and application objects to detailed customized views of specific segment-entity-object-attribute combinations. The Client provides a consistent viewing paradigm for Neoview platform objects including CPU, Disk, ProcessBusy, Query, QueryRTS, Table, and TMF.
You use pull-down and shortcut menus, drop-down lists, and toolbar buttons to control the display in the Browse window and to navigate to other windows in the Dashboard environment: • • • • • Use drop-down lists or toolbar buttons to select the segment, entity, and object of interest to you. The grid and graph in the Browse window update in real time as data for the selected resource arrives from the Neoview platform. Focus your attention on a specific data item by selecting it in the graph.
Display Query entity information Display QueryRTS entity information NOTE: The Query and QueryRTS entities are currently represented by the same icon. Mouse over the icon on the toolbar to discover which entity it represents.
Display Dashboard Properties window Display Download Wizard dialog box Rotate 3D Graph (Must be enabled from the password-protected Property sheet.
Selecting a View To indicate what kind of data you want to see in the Browse window, you make selections from lists that appear along the top of the Browse window. For example, you might want to see a display of data for all disks on a specified segment and to limit the display to disks that have warnings associated with them. The combination of criteria that you specify is called a “view.
If the workstation does not respond in a reasonable amount of time, look at data one segment at a time or create individual Graph windows for each segment. For more information, see “Browse Window Shortcut Menus” (page 44). Selecting an Entity Entities include classes of objects such as processing nodes (CPUs), disks, processes, and queries. You can change the entity displayed in the Browse window using the Entity list or the Entity toolbar buttons.
Selecting an Object To change the object or objects displayed in the Browse window, use the Object drop-down list. The names in the Object list reflect the entity you have selected for display. For example, if the current entity is Disk, the Object list lists all the disks configured on the selected segment. It is possible for an entity to be disabled in a configuration.
Do not select All Segments from the Segment list (*) when viewing more than one sample. Such a specification could require the analysis of performance information for thousands of objects. In general, slow workstation responsiveness might indicate that you are trying to display too many samples.
Status of PC-Host Session ----The Browse window has a PC-Host Session Status display that consists of PC and Host icons connected by a communications link. The PC icon is a shortcut to the Dashboard Properties window. To open the Dashboard Properties window so you can change Dashboard properties, click the PC icon. The Host icon is a shortcut to the Dashboard Session window. To open the Session window so you can check the status of the Host Session and view the Session log, click the Host icon.
Managing Grid Rows, Columns, and Grid Height Selecting Grid Rows and Columns You can select grid rows, columns, or cells in a Browse window. You can graph or copy selected cells to the clipboard using shortcut menus. • • • • To select a grid row, click the first element of the row. The entire row is highlighted. To select a grid column, click the heading of the column. The entire column is highlighted. To select a grid cell, click the cell of interest. The cell is outlined.
Use the Command Wizard to obtain detailed host reports: 1. 2. 3. 4. 5. 6. 7. Click the Command Wizard button labeled with the Binoculars icon. From the Command To Execute list, select the command to execute. From the Segment list, change the segment. From the Font list, specify the font. Select Log to display a list of recent performance monitor host log events for the specified segment. Select Status Monitor to display the status of the Dashboard subsystems on the specified segment.
OEM Toolbar Button Click the OEM toolbar button to enable or disable Dashboard access to the Open Enterprise Management Gateway (OEM). This button has two states. When clicked, Dashboard access to the OEM is enabled. When not clicked, Dashboard access to the OEM is disabled. The OEM and OIL buttons are mutually exclusive. When one is enabled, the other is disabled. Therefore, when the OEM is enabled, the OEM adapter interface can use the OIL.
2. Drag in the direction you want to rotate the graph: • Change the rotation of a graph by dragging the mouse to the left or right. • Change the elevation of a graph by dragging the mouse up or down. To permanently save Browse window graph rotation or elevation changes, select the Save Rotate Angles check box on the Graph property sheet.
• • • To save the Suppressed Object State List, click Save. This list is reapplied to existing objects when you restart the Client. If you do not click Save after changing the Suppressed Object State List, the changes are only temporary. To close the State Suppression dialog box, click Close. To get help for the State Suppression dialog box, click Help. Thresholds Toolbar Button To display the Utilization Thresholds control panel, click the Thresholds toolbar button.
Menu Items Description Print Prints the Browse window. Exit Leaves the current Browse window. If the current Browse window is the last one, a dialog box asks whether you want to shut down Dashboard. To shut down Dashboard, click OK. To continue using Dashboard and leave the view unchanged, click Cancel. Edit Menu Items Menu Items Description Copy Copies selected grid rows, columns, or cells to the clipboard. Copy delimits data columns with commas.
View Menu Items 42 Menu Items Description Session Opens the Dashboard Host Session window. Graph Nodes Creates a new Graph window for each segment monitored. Each Graph window then updates in real time as data is received from the host system. Use this menu item to view the overall performance of your network. If you monitor a small number of segments, you can repeatedly select an entity and then select Graph Nodes to obtain a mixed set of graphs on different entities.
Menu Items Description Tile Grid Windows Tiles the screen with Browse windows. This function is enabled only when more than one Browse window exists. If the OIL tree view currently appears, the area to the right of the OIL is tiled with Browse windows. Tile Report Windows Automatically tiles the region to the right of the Browse window with the current Report windows. This function is enabled only when more than one Report window exists. Delete Report Windows Deletes all Report windows.
Help Menu Items Menu Items Description Contents Displays the Help Contents for the Dashboard product. Architecture Displays an architectural overview discussion of the Dashboard products. About Displays product release version and copyright information about Dashboard. Browse Window Shortcut Menus You can display shortcut menus in the Browse window graph and grid areas. To open a shortcut menu in a Browse window: 1. 2. Right-click a grid row, column, or cell.
Menu Items Description Graph Row/Column Graphs the selected grid row or column in the graph area of the Browse window States Displays a legend showing Dashboard state icons and their meanings Suppress States Suppresses state reporting for selected objects Object State Changes (OSC) Window You can use the Object State Changes (OSC) window to obtain a history of object state changes. The OSC view provides both a high-level graphical overview of object state changes and a detailed log of state changes.
Copy scoreboard and log information to clipboard Magnify or shrink scoreboard Display or hide date in state change log Show or hide scoreboard Show or hide statistics tips Show or hide current object state counts Show State thresholds dialog box Show Dashboard properties window Refresh OSC window OSC Window Functions The Object State Change window provides functions that allow you to analyze object state changes.
• • • • • • • • • • • “OSC Remove Selected” (page 48) “OSC Tile” (page 48) “OSC Copy” (page 49) “OSC Magnify” (page 49) “OSC Show Date” (page 49) “OSC Show Score Board” (page 49) “OSC Show Tips” (page 50) “OSC Show State Counts” (page 50) “OSC Thresholds” (page 51) “OSC Properties” (page 51) “OSC Refresh” (page 51) OSC Find Related Use the Find Related function to find all items in the change log related to the currently selected object.
11:00 \Hpq001\ProcessBusy\0 Low > High Busy 85.5% 11:10 \Hpq001\ProcessBusy\0 Low > High Busy 87.8% 11:20 \Hpq01\ProcessBusy\0 Low > High Busy 81.2% 11:30 \Hpq01\ProcessBusy\0 Low > High Busy 89.3% 11:40 \Hpq01\ProcessBusy\0 Low > High Busy 89.3% 11:50 \Hpq01\ProcessBusy\0 Low > High Busy 89.3% To manually select multiple log items (for example, the first three items at 11:00, 11:10, and 11:20, control-click them.
Use the Tile OSC function to tile or dock the OSC window with Browse window. This function is useful for placing the Browse and OSC windows in a side-by-side arrangement. OSC Copy Use the Copy OSC function to copy scoreboard and log information to clipboard. This function is useful when you want to include information from the OSC view in a Microsoft Word document or Excel spreadsheet.
OSC Show Tips Use the Show Tips function to show or hide tips that appear as you move your mouse over elements of the scoreboard and state change log. As you move your mouse over elements in the scoreboard, color-coded statistical tips appear describing both the number of state changes and the total number of objects in a given state. As you move your mouse over state change entries in the log, Dashboard continuously searches for other items in the log that match the object under the mouse.
OSC Thresholds Use the Thresholds function to display the Utilization Thresholds control panel. OSC Properties Use the Properties function to open the Dashboard Properties window. OSC Refresh Use the Refresh function to refresh the scoreboard and log in the OSC window. Graph Window A Graph window provides a compact graphical performance view that is useful for maintaining multiple status-orientated views of various segment-entity-object combinations.
Graph Window Menus Function Description Show Object Details Displays a graph and a list view of object details or opens a report window with detail information Show Object History Displays the recent history of object performance Graph Object History Displays recent object history of selected object Show Related Apps Shows applications related to the selected object Show Related Disks Shows disks related to the selected object Show Related Processes Shows processes related to the selected objec
Show Object Details To display all performance properties and values for the selected object or to open a detail report window for the selected object, select Show Object Details. The Report window displays a graph of the user-defined graph attributes. Below the graph is a scrollable list view of all Dashboard performance properties for that object and their values. Show Object History To display a detailed recent history report for the selected object, select Show Object History.
Show Related Disks To display a report of disk volumes related to the selected object, select Show Related Disks. When this report is generated, a query is first posted to your host system and the response appears in a scrollable view of disk volume performance information related to the selected object. If the selected object is a CPU or a Process, the report shows the disk processes running in that CPU and a detailed listing of related performance statistics.
Option Description Seconds Controls the measurement interval in seconds. If you are comparing data to Dashboard, use the same sample interval as Dashboard, which is the default. Otherwise, you can pick a shorter or longer interval. You are limited to one measurement at a time to protect the use of system resources. Sync Synchronizes the measurement to start and stop in sync with the Dashboard sample interval. This option can used for comparative analysis of stats.
Session Window Pull-Down Menus File Menu Items Menu Item Description Start Session Starts your Host Session and enables the state of the Client Server Gateway check box on the SSG property sheet. Stop Session Stops your Host Session and disables the state of the Client Server Gateway check box on the SSG property sheet. Save Log and Save Log As Saves the current Session log to disk. Select Save Log As to specify the name of the log file before saving the disk file. Close Closes the Session window.
Time Synchronization Toolbar Button Only HP Support can use this feature. Properties Window Toolbar Button Click the Properties Window toolbar button to display the Dashboard Properties window. Use the Dashboard Properties window to customize your environment by specifying which entities and performance attributes appear in the Browse and Graph windows and to specify session properties.
5 Using the Client Property Sheets The Dashboard Properties window gives you many options for customizing the Dashboard environment, including the ability to specify which entities are retrieved from Neoview platforms; the attributes to display for each entity; the state determination algorithm for each attribute; and the font, graphing options, and host retrieval options to use. Most Dashboard property sheets are password-protected. However, the OSC and Font property sheets are not password-protected.
Use this dialog to: • • • • • Control which attributes are displayed in the data grid of Browse windows Control which attributes are displayed in the graphs of Browse and Graph windows Set the normalization value for attributes Set the state determination algorithm for attributes Find the exact meaning of a specific entity attribute For example, to see the description of an attribute for an entity: 1. Specify the entity, to display its attributes in the Attribute property sheet: a.
Graph-Max Field When an attribute has its Show in Graph property set, you can specify the Graph-Max normalization value for that attribute. The Graph-Max field is the unlabeled field immediately to the right of the Show in Graph check box. This value determines the maximum graph amplitude or normalization value for the attribute.
State Determination ALL Button The State Determination ALL button is an advanced feature that selects a range of attributes from the first attribute that has a state attribute associated with it through the last attribute for the current entity. This button lets you quickly select a range of attributes starting with the first attribute that has a state associated with it, also known as a value,state StatePair.
Use Value Graph Value Option The Use Value Graph Value option indicates that attribute state information is determined directly by the value of that attribute. This value is graphed. Entities can have metrics that provide both value and state information in ordered pairs of numbers; for example, Busy and BusyState. The metric portion is the actual value of the attribute, and the state portion is the entity agent’s state determination objective associated with the metric.
chosen, the operational state of the object is graphed, and that state icon appears next to the Status attribute in the data grid. Default Performance and Availability Objectives for Neoview Platforms The Neoview platform comes preconfigured with a set of availability and performance objectives suitable for most configurations. For example: • • • • • A system disk should be less than 95% full. A processing node should have fewer than 200 processes waiting to execute.
Clear Registry Button To clear all of your registry settings, click the Clear Registry button. Because all existing settings are lost, a confirmation dialog box appears. Custom Dashboard configuration settings are also lost, and Dashboard reverts to default settings. If you click Yes, all settings are cleared, the Dashboard Client terminates, and you must restart your Dashboard session. You can configure your new settings when the session is restarted.
When the Set Password dialog box appears, you can protect property sheets by selecting check boxes for each property sheet that you want protected. Once you enter a password and click Set Password, the property sheets you selected are protected. You can set a Password Reminder, which is provided if someone cannot remember the password. To access protected property sheets: 1. 2. 3. Display the Dashboard properties window, and select property sheets as you would normally.
Delete Removed Select the Delete Removed menu to control when removed objects are deleted. These options are available: Never Select this option if you want removed objects to be indefinitely retained by your Client session. This setting means the Client will never delete removed objects from the Client data cache. (You can manually delete objects in cache by selecting Edit > Clear Data in the main browse window).
Dashboard, OEM, and OIL are synchronized, indicating the relative utilization state of each object. Graph Color Toggle Check Box To alternate the color of repeating rows of graph colors between a light and dark shade of the same color, select the Graph Color Toggle check box. Graph in Grid Window Check Box To display a graph in the Browse window, select the Graph in Grid Window check box.
Select ALL to remove the limit altogether. However, selecting ALL can lead to performance degradation when you display a large number of objects or rows. High Contrast Check Box When the Dashboard client is installed on a workstation for the first time, the background color for entity screens is gray. When the Dashboard client is installed on a workstation where it has been installed before, the background color for entity screens depends on the setting if this check box.
Open Enterprise Management Check Box The Open Enterprise Management check box lets you display Dashboard segment, entity, and object performance information in the OEM gateway. To enable the Dashboard interface to the enterprise management gateway, select the Open Enterprise Management check box. When the OEM interface is active, you can access Dashboard information from the OEM framework.
OEM Full Context List The OEM Full Context list controls the amount of object-state information passed to the OEM. Normal Context is the default that provides limited information. Other options are Full Context as XML and Full Context as CSV format. The OEM context options are Normal Context When this option is selected, the Client context string for each object contains only the name and value of the attribute with the highest alert state. This option is the default context string.
When you use Dashboard with the OIL, the main Dashboard Browse window is positioned to the right of the OIL window and resized to match the OIL window's size. You can then display Graph and Report windows to the right of the main Browse window. Populate OIL with Objects Check Box The Populate OIL with Objects check box controls whether the OIL view is populated with the objects known to Dashboard.
For example, if the performance utilization threshold is set to 80 percent and has a red Critical alert icon, any object with a graphed performance attribute of 80 percent or more utilization has a red critical alert icon propagated upward through the hierarchy for that object. Utilization Threshold Sliders The five Utilization Threshold sliders control the performance utilization thresholds of up to five performance indicator icons.
• • • • • • Specify whether state change downgrades are monitored Specify the minimum state change monitored Specify the maximum number of changes to be retained Specify how late data integrity checks are performed Specify an audible alert state change threshold To configure e-mail, wireless phone, and pager alerts and report notifications Monitor Object State Changes Check Box The Monitor Object State Changes check box controls whether Dashboard performs object state change monitoring.
alert notifications to occur. The Notify button is located on the OSC property sheet because its actions are directly related to the Minimum State Change setting. Notifications can occur: • • • • At regular intervals during the day such as every 1, 2, 3, 4, 8, 12 … hours At specific times such as 7:30, 10:00, 12:45, 15:27 … When objects change state When new sampling activity occurs To control the notification rule as well as the content of what is reported, use the Notify control panel.
When you select Automatic, Dashboard automatically determines whether data received from each segment, entity, and object is arriving in a timely manner. If not, Dashboard flags the time for the object as down time. When you select a Late Data time, Dashboard delays its Automatic late data check by that amount. For example, if you select 30 seconds, Dashboard delays its late data alert by an additional 30 seconds. During this delay, data might arrive from the nonresponding object.
Profile check box: Allows you to enable or disable notify profiles that you have configured. For example, you could disable the Alerts profile while on vacation or enable a Report profile while traveling on business so that you periodically receive reports via e-mail.
object-state changes that should be displayed for this report. Alerts are reported with most recent state changes listed first, followed by less recent changes. Score Check Box: If selected, a color-coded score-board matrix of object types versus object-state counts is generated whenever a notification occurs for this profile. This report is useful for providing the overall health of system, subsystem, and application objects.
From field: Defines the return e-mail address shown in the e-mail or phone alert. If you are using short messaging, you might want to keep this field short. Subject field: Defines the subject sent with the e-mail or phone alert. If you are using short text messages, you might want to leave this field blank or keep the subject short. Priority: Defines the priority of the notification message. Standard RFC 821 priorities are used: Normal, Urgent, Non-Urgent.
• required. The SMTP user and password fields might not be required, depending on your server configuration. If you supply a user and optionally a password, you must select the Logon check box. SMTP and POP fields supplied: Use this combination when POP authentication is required to use the SMTP server. Some SMTP servers cross-validate that a given user has first logged on to the POP server. If this is the case, you must supply your POP user and password.
None To manually control host data retrieval, select None. The None option specifies that Dashboard does not automatically retrieve host data on a periodic basis, even when the Host Session is enabled. This option is useful when you are doing manual, specific performance downloads using the Download toolbar button in the main Browse window to view data at a specific time of day.
Trace Audits Check Box To trace each entity sample in the Dashboard Session window, select the Trace Audits check box. To view this trace, select View > Session in the Browse window. Show CSG Until Connected Check Box To display the CSG when Dashboard requests a connection to your Neoview platform, select the Show CSG Until Connected check box. Once connected, the CSG is minimized. This option lets you view the progress of the connect sequence during Dashboard startup.
HP recommends that you not change these settings because Dashboard Client and Server settings are automatically determined by the Client. However, advanced users might want to use the Client to analyze nondefault Dashboard configurations. To open the SSG Advanced control panel: 1. 2. 3. Select View > Options or click the Properties toolbar button. The Dashboard Properties window appears. Click the SSG tab. The SSG property sheet appears. Click the Advanced button. The SSG/CSG Advanced dialog box appears.
Accept Server Initiated Flow Control Option The Accept Server Initiated Flow Control option lets the Dashboard Server initiate I/O Flow Control to your Client if the Dashboard Server is appropriately configured. Only HP Support may set or reset this option. Term Name Check Box The Term Name check box controls whether your Client/Server session uses your fixed workstation name or a dynamic name. When you select the Term Name check box, the session name is the same as your workstation machine name.
6 Using Entity Screen Information This section describes the active Dashboard entity screens and their attributes.
CPU Entity Attributes Table 6-1 describes the attributes displayed on the CPU entity screen. Table 6-1 CPU Entity Attributes Attribute Description Default Attribute for Graph? Default Attribute for Grid? Busy% Percentage of the processing node that is busy Yes during the sample interval. Yes Chit Disk cache hit rate per second for the processing node. Yes Yes Cpu Number of the processing node on the Neoview platform. No Yes Disk Disk I/O rate per second for the processing node.
Figure 6-2 Disk Entity Screen Disk Entity Attributes Table 6-2 describes the attributes displayed on the Disk entity screen. Table 6-2 Disk Entity Attributes Attribute Description Default Attribute for Graph? Default Attribute for Grid? Busy% Percentage of time a disk is busy reading, writing, and seeking. Yes Yes Chit Total cache hits per second for all block sizes. Yes Yes DiskName Logical disk volume name. No Yes Fragment Size of the largest fragment on the disk volume, in megabytes.
Table 6-2 Disk Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Qlen Disk process receive queue length integrated Yes over the sample interval. Yes Read% Percentage of time a disk is busy reading. Yes Yes Reads Number of Encapsulated SQL Access No Manager (ESAM) read operations per second. Yes Requests Number of disk I/O requests per second. Yes Yes Status Operational status of the disk.
Figure 6-3 ProcessBusy Entity Screen ProcessBusy Entity Attributes Table 6-3 describes the attributes displayed on the ProcessBusy entity screen. Table 6-3 ProcessBusy Entity Attributes Attribute Description Default Attribute for Graph? Default Attribute for Grid? AncestorName Name of the process that started the busy No process. This name consists of the segment name, followed by either a process name, like $ZAAM, or pair of identifying numbers like 1,177.
Table 6-3 ProcessBusy Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? ProgramFileName Program object filename on the disk. No Yes RcvMsg Messages received per second. Yes Yes RcvQ Process receive queue length integrated. No Yes SndMsg Messages sent per second. Yes Yes Status Operational status of the process. A green Up No icon, which signifies the process is up with no thresholds, is the only state for the busiest process.
Query Entity Attributes Table 6-4 describes the attributes displayed on the Query entity screen. As the two rightmost columns show, several Query entity attributes are not displayed in the graph or grid areas of the screen (for example, BusyESPCPU, BusyESPPIN, and BusyESPSeg). Table 6-4 Query Entity Attributes Attribute Description Default Attribute for Graph? Default Attribute for Grid? AppID The name of the application as supplied by Neoview SQL.
Table 6-4 Query Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Sys% System utilization percentage for all query processes during the last interval. Sys% only includes processes for which Busy is greater than the value of BusyVal. Yes Yes Time Time of statistics. No Yes TotCon% Cumulative system utilization percentage for the connection server . No No TotEsp% Cumulative system utilization percentage for all the executor processes.
Query Time Advancement The Client and Dashboard database key only supports resolution to the whole second. However, query events can occur in sub-second times. For example, the Start event and End event for a query might be generated in less than one second. However, the Query SGP cannot write two records for the same query to the database in less than one second. If it attempts to do so, a Duplicate Record error (10) is received. The Query SGP uses time advancement to resolve a series of sub-second events.
Figure 6-5 QueryRTS Entity Screen QueryRTS Entity Attributes Table 6-5 describes the attributes displayed by default on the QueryRTS entity screen. With the exception of attributes that provide identifying information for the query and estimates made when the query is prepared, all attributes are updated as the query executes.
Table 6-5 QueryRTS Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Username Neoview user name of the user who started the query No Yes Role Role of the Neoview user who started the query. No Yes ClientID Name of the device from which the query was No sent. Yes ApplID Name of the connectivity driver used to send the query, e.g., ODBC.
Table 6-5 QueryRTS Entity Attributes (continued) 96 Attribute Description BusiestESPSeg Segment of the busiest Executor Server Process. No Yes BusiestESPCPU Processing node of the busiest Executor Server No Process. Yes BusiestESPPIN Process identification number of the busiest Executor Server Process. No Yes CompileStartTS Local civil time at which the query began compilation. No Yes CompileEndTS Local civil time at which query compilation ended.
Table 6-5 QueryRTS Entity Attributes (continued) Attribute Description Default Attribute for Graph? EstIoTime Estimated time, in seconds, required to perform No i/o for this query, including seeks and data transfers. Estimated at the time the query is prepared. Yes EstMsgTime Estimated time, in seconds, required for No messaging. Estimated at the time the query is prepared. Yes EstTotalTime Estimated total CPU time, in seconds.
Table 6-5 QueryRTS Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? StatsErrorCode Warning returned to the stats collector by RTS. No Yes SqlSpaceAlloc For Master Executor and ESPs, kilobytes of SQL No space allocated. This type of memory continues to grow during query processing. (Compare SQLHeapAlloc.) Yes SqlSpaceUsed For Master Executor and ESPs, kilobytes of SQL No space actually used.
Table entity information can be useful when you are trying to understand why a query is performing badly, because missing or obsolete statistics can cause poor query performance. Table fragmentation (requiring a REORG on the table) is another possible cause of poor query performance. It follows that monitoring tables proactively, and updating statistics or reorganizing tables as required, is a good way to prevent query performance problems from arising.
Table Entity Attributes Table 6-6 describes the attributes displayed on the Table entity screen. Table 6-6 Table Entity Attributes Attribute Description Default Attribute for Graph? Default Attribute for Grid? Catalog Catalog name of the table or materialized view. No Yes Schema Schema name of the table or materialized view. No Yes Name Name of the table or materialized view. If you No rename the object, the new name will appear the next time the display is refreshed.
Table 6-6 Table Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? MinStatsTime Earliest time at which some set of histogram statistics for the object were created. No Yes MaxStatsTime Latest time at which some set of histogram statistics for the object were created. No Yes DistinctStats Number of distinct times at which histogram statistics for the object were created. Yes Yes RepairAction SQL command (i.e.
Figure 6-7 TMF Entity Screen TMF Entity Attributes Table 6-7 describes the attributes displayed on the TMF entity screen. Table 6-7 TMF Entity Attributes 102 Attribute Description Default Attribute for Graph? Default Attribute for Grid? Active “Yes” means an audit dump is currently dumping. No Yes BeginTr Begin transaction status (enabled or not enabled). Yes Yes Catalog Catalog status. No Yes Duration Elapsed time of the longest-running transaction, in seconds.
Table 6-7 TMF Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Status Operational status of Neoview transaction Yes services. A green Up icon signifies that transaction services are available. A red Down icon signifies that transaction services are not available. Yes Time Time of statistics. A red Down icon signifies the time is outside the sampling interval.
7 Using Command and Control to Manage Queries Dashboard Command and Control allows authorized users to suspend, resume, and kill Neoview SQL queries running on a Neoview platform. You access Command and Control for a selected query using a shortcut menu from the Query entity grid, graph, and sort views. NOTE: The Suspend and Resume commands are disabled in the current release of Dashboard but are reserved for future use.
4. 5. Select Kill. If you selected multiple queries in Step 2, the same action is performed on all of them. The Confirm Operation dialog box appears: Do one of: • • • • 106 Click No to dismiss the dialog box and cancel the Manage action on a single selected query or for one query at a time. Click No to All to dismiss the dialog box and cancel the Manage action on all selected queries. Click Yes to accept the Manage action on a single selected query or for one query at a time.
6. The Login dialog box appears when you issue the first command of the session. The title bar identifies the Neoview platform host to which you are connecting. a. b. • • Enter your Neoview platform login user name and password. Either: Select Cancel to dismiss the dialog and cancel the Manage action. Select Login to proceed with the Manage action and start the CSG process.
Table 7-1 Operations Status Window Information (continued) Column Provides This Information... End Time The time the action request was completed. Result A numeric value and text that describes the result of the action. The numeric value of zero signifies the action was successful. All other values signify failure.
NOTE: Do not confuse the Operations Status window information with the Command and Control log, which is maintained and stored by the Dashboard Server on segment 1 of the Neoview platform. The contents of the Command and Control log cannot be deleted.
8 Switching Between Neoview Platforms To change the current Dashboard host session from the current Neoview platform to another Neoview platform: 111
1. Stop the current Dashboard host session: a. From the Dashboard Client, open the Host Session window by clicking directly on the blinking green Host icon at the top center of the screen. NOTE: Be sure to click directly on the blinking green Host icon to avoid opening the Help screen. 112 b. From the Host Session window, select File > Stop Session. c. From the CSG main window, select the Start/Stop Host Session (blue chevron) icon to stop the current session. d.
e. Wait for the message Host session terminated.
2. Configure the connection to the new Neoview platform: a. From the Client main window, click the Show Options Dialog icon. The CSG options dialog appears. b. 114 Select the TCP/IP tab and enter the IP address of the other Neoview platform.
c. 3. Click OK. Establish the connection to the new Neoview platform: a. From the CSG main window, click the Start/Stop Host Session icon to establish the connection. b. Wait for the message Host in session.
4. 116 Restart the host session: • From the Host Session window, select Select > Start Session.
5. Clear data from the previous Neoview platform: a. From the Client toolbar, select Edit > Clear Data. b. Wait for data from the new Neoview platform to appear.
Index A P Attribute property sheet , 59 ProcessBusy entity , 88 Property sheets Attribute, 59 Font, 64 General, 64 Graph, 67 OEM, 69 OIL, 71 OSC, 73 SSG, 80 B Browse window , 27 C Character sets supported, 21 Client features, 18 GUI components, 19 installing, 23 overview, 17 starting, 25 CPU entity , 85 CSG starting and configuring, 25 D Disk entity , 86 Documents, related information, 14 E Entities CPU, 85 Disk, 86 ProcessBusy, 88 Query, 90 QueryRTS, 93 Table, 98 TMF, 101 Q Query entity , 90 QueryR
