HP Neoview Management Dashboard Client Guide for Database Administrators HP Part Number: 544569–001 Published: August 2007 Edition: HP Neoview Release 2.
© Copyright 2007 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.......................................................................................................13 Supported Release Version Updates (RVUs)........................................................................................13 Intended Audience................................................................................................................................13 New and Changed Information in This Edition...............................................
Sizing Grid Rows, Columns, and Grid Height..........................................................................36 To resize a grid column:.............................................................................................................36 To resize a grid row:...................................................................................................................36 To resize the grid height:............................................................................................
Show Related Disks.........................................................................................................................54 Show Related Files...........................................................................................................................54 Show Related Processes...................................................................................................................54 Show Related Expand Lines.............................................................
Graph in Grid Window Check Box.................................................................................................67 Label Rows with Names Check Box................................................................................................67 Label Names Compressed Check Box.............................................................................................68 Graph Percent Check Box.....................................................................................................
Trace Replies Check Box..................................................................................................................81 Trace Audits Check Box...................................................................................................................81 Show CSG Until Connected Check Box..........................................................................................81 Auto Connect to CSG at Startup Check Box.................................................................
List of Figures 1-1 4-1 6-1 6-2 6-3 6-4 6-5 7-1 Dashboard Entity Screen...............................................................................................................20 Minimum State Menu....................................................................................................................34 CPU Entity Screen.........................................................................................................................86 Disk Entity Screen..............................
List of Tables 6-1 6-2 6-3 6-4 6-5 7-1 CPU Entity Attributes ..................................................................................................................86 Disk Entity Attributes ...................................................................................................................88 ProcessBusy Entity Attributes.......................................................................................................90 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 objectives of the CPU, Disk, , ProcessBusy, Query, and TMF entities. Supported Release Version Updates (RVUs) This manual supports N02.02 and all subsequent N-series RVUs until otherwise indicated in a replacement publication.
UPPERCASE LETTERS Uppercase letters indicate keywords and reserved words. Type these items exactly as shown. Items not enclosed in brackets are required. For example: SELECT Italic Letters Italic letters, regardless of font, indicate variable items that you supply. Items not enclosed in brackets are required. For example: file-name Computer Type Computer type letters within text indicate case-sensitive keywords and reserved words. Type these items exactly as shown.
… Ellipsis An ellipsis immediately following a pair of brackets or braces indicates that you can repeat the enclosed sequence of syntax items any number of times. For example: ATTRIBUTE[S] attribute [, attribute]... {, sql-expression}... An ellipsis immediately following a single syntax item indicates that you can repeat that syntax item any number of times. For example: expression-n… Punctuation Parentheses, commas, semicolons, and other symbols not previously described must be typed as shown.
Neoview Customer Library • Administration Neoview Database Administrator’s Guide Information about how to load and manage the Neoview database by using the Neoview DB Admin and other tools. Neoview DB Admin Online Help Context-sensitive help topics that describe how to use the HP Neoview DB Admin management interface. Neoview Guide to Stored Procedures in Java Information about how to use stored procedures that are written in Java within a Neoview database.
Publishing History Part Number Product Version Publication Date 543654–001 HP Neoview Release 2.0 March 2007 544569–001 HP Neoview Release 2.2 August 2007 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: pubs.comments@hp.
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.
• • • • • • • • Object State Change (OSC) view, which provides a history of all object state changes Internationalization and user-customization of objects, states, icons, and colors Object Integration Layer (OIL) tree view, which provides hierarchical access to all objects Monitoring the CPU, Disk, ProcessBusy, Query, and TMF entities 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
Session Window Dashboard can retrieve both real-time and historical statistics information. Through the Session window, you can view, start, stop, and track the progress of the Host Session. You can start and 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.
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 these products, place your free order, and download the files to your workstation. The downloadable files include: • • NVMD_Client_Setup.
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 these types of Neoview platform objects: CPU, Disk, ProcessBusy, Query, and TMF.
Component Description Described in Dashboard Properties window Lets a database administrator customize the Dashboard environment. Section 5, Using the Client Property SheetsChapter 5 (page 59) OIL tree view Provides a hierarchical view of host “OIL Property Sheet” (page 70) segments, entities, and objects so that you can view the overall availability and performance of many segments, entities, and objects.
Display Entity toolbar Display CPU entity information Display Disk entity information Display ProcessBusy entity information Display Query entity information Display TMF entity information Select All objects for the current segment-entity Select First object in the Object list Select Last object in the Object list Select Previous object in the Object list Select Next object in the Object list Set Samples count to one, set it to +10 until max rows/object, then set it back to 1 Refresh Client with
Suppress State reporting for selected objects Display Utilization Thresholds dialog box Display Dashboard Properties window Display Download Wizard dialog box Rotate 3D Graph (Must be enabled from the password-protected Property sheet.
Browsing and Analyzing Segments, Entities, and Objects The buttons on the left half of the Browse Window toolbar let you specify the “view” (determining the kinds of data to be displayed) and adjust the look of the display, for instance by resizing rows and columns. 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.
Selects the next segment in the Segment list 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.
It is possible for an entity to be disabled in a configuration. In that case, even if a segment contains objects of that type, the Object list is empty for the entity because the host segment does not report on them. Only HP support personnel can enable and disable Dashboard entities. To select an object using the Object list: 1. 2. Click the arrow in the Object list. Select the desired object from the list, or select all items in the list by selecting the asterisk (*).
looking at data one segment at a time or creating individual Graph windows for each segment, as described in “Browse Window Shortcut Menus” (page 44). Selecting Minimum State Figure 4-1 Minimum State Menu To control whether objects of a particular state appear in the Browse window, use either the State Filter Toolbar near the upper right corner of the Browse Window or the Minimum State pull-down menu shown in expanded form in Figure 4-1.
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. Health Indicators The PC-Host Status window provides an overall indication of the health of the Client-Server session.
• • To select a grid cell, click the cell of interest. The cell is outlined. To select a range of cells, click and drag the range of cells, rows, or columns. The range is highlighted. Sizing Grid Rows, Columns, and Grid Height You can manually resize grid rows or columns in the Browse window. To resize a grid column: 1. 2. Move the cursor over the column heading dividing line that you want to resize. Click and drag the line until the column is the preferred width. To resize a grid row: 1. 2.
6. 7. Select Status Monitor to display the status of the Dashboard subsystems on the specified segment. Click Save As in the Command Wizard window to save the contents of the window to disk. To display help for the Command Wizard window, use the Help toolbar. Download Wizard Toolbar Button Normally, Dashboard retrieves the most recent data in the host database, providing a real-time view of your Neoview platform.
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. To specify additional options that control how Dashboard accesses the OEM, use the OEM property sheet in the Dashboard Properties window. OIL Toolbar Button Click the OIL toolbar button to enable or disable Dashboard access to the Object Integration Layer (OIL). When you click the button, Dashboard access to OIL is enabled.
To use the Rotate Graph toolbar button: • • Click the Rotate Graph toolbar button to rotate the viewing angle of the Graph in the Browse window slightly each time it is clicked. Click this button repeatedly to show the graph at a variety of angles, retracing prior viewing angles at the end of each complete rotation. Sort View Toolbar Button Use the Sort View toolbar button to obtain sorted views of Dashboard performance information.
Browse Window Pull-Down Menus The Browse window includes various pull-down menu functions.
Edit Menu Items Menu Items Description Copy Copies selected grid rows, columns, or cells to the clipboard. Copy delimits data columns with commas. You can then paste clipboard information into a text window.Select FileSave Data to save all of the information in the grid to a disk file. Copy HTML Copies selected grid rows, columns, or cells to the clipboard in HTML text format. Copy HTML delimits data with color-coded state information. Data is also formatted in HTML table format.
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 Delete Graph Windows Deletes all Graph windows. Arrange Graph Windows Arranges all existing Graph windows so they appear to the right of the Browse window. Arrangement is based on the size of the last Graph window that you resized. To control the appearance of the Graph windows, repeatedly resize a Graph window and select Arrange Graph Windows.By comparison, the Tile Graph Windows function resizes the Graph windows to fit equally into the area to the right of the Browse window.
Menu Items Description Suppress States Suppresses state reporting for the selected objects. To select a single object, click any cell in the row associated with the object. To select a range of objects, click and drag a range of rows. The range is highlighted.Once you select the objects for state suppression, click the Suppress States toolbar button. You can also select View > Suppress States. The State Suppression dialog box appears.To add Selected Objects to the Suppressed Object State List, click Add.
3. Select the function from the shortcut menu. For information about the Manage menu commands (Kill, Suspend, and Resume) available from the Query entity graph, grid, and sort views, see Chapter 7 (page 99). Browse Window Shortcut Menu Functions Browse Window Shortcut Menus Function Show Object Details Displays a graph and a list of object details, or opens a report window with detail information. Show Object History Displays the recent history of object performance.
Each row of the scoreboard represents the different entity types monitored (for example, CPU, Disk, and Expand entities). Each column of the scoreboard represents different possible object states (for example, Up, Down, and Warning states). Selecting a cell in the scoreboard causes an analysis of the OSC log in the lower part of the window. All object state changes that match the selected entity and state are selected.
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. The upper part of the window provides a summary of state changes, and the lower part of the window provides a detailed log of each object state change.
OSC Find Related Use the Find Related function to find all items in the change log related to the currently selected object. When you select a log item in the OSC change log and select Find Related, Dashboard finds all state change instances in the OSC log for the object you selected. Each of these state changes is then also selected. You can then examine all state changes related to a given object and perform other operations on these items, such as Acknowledge or Remove.
you click the log items you want to add to the selection list. To graph these items, select the Graph Selected menu item or toolbar button. If you select multiple log items and use the Graph Selected function, the selected items should all be log items for the same object. Otherwise, confusing nonorthogonal graphical information is generated.
OSC Magnify Use the Magnify OSC function to magnify or shrink OSC window contents. This function is useful when you want information displayed with larger or smaller fonts and icons. OSC Show Date Use the Date function to display or hide the date in the object state change log. When you initially start Dashboard, date information in the OSC log is redundant. However, after several days, depending on how you use the OSC view, you might want to display both the date and time of state changes.
the object under the mouse, a tip appears indicating the number of times that object appears in the log. For example, if 17 x appears as you move your mouse over a log item, there are 17 items in the log for that object. You can use this feature to quickly determine which objects occur frequently in the log. You can also determine this is by sorting items in the log. You can sort items in the log by clicking log headings. For example, to sort by object name, click the heading labeled Domain Name.
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. Each Graph window contains only one graph and can be made small enough to maintain numerous views at once. Graph windows update in real time.
Function Description Show Related Processes Shows processes related to the selected object Show Related Expand Lines Shows Expand lines related to the selected object Refresh Refreshes the current Browse window Properties Opens the Dashboard Properties window Graph Type Displays a list of graph types such as 2D-Bar, 3D-Bar, Surface, Tape, and so on To open a shortcut menu in a Graph window: 1. 2. 3. Click a graph element. Click the graph element label. Select the function in the menu.
This function lets you extend the history information for any object that appears in the Browse window. Select the object and then select Graph Object History from the menu. Dashboard automatically back fills the object history in the Browse window. Show Related Apps To display a report of applications related to the selected object, select Show Related Apps.
that are automatically displayed in a report window. The Show Related Measurement control panel options are: Node controls the Segment name to be analyzed. Entity controls the Entity to be analyzed. Object controls the Object to be analyzed. The initial segment, entity, object values are for the object you initially selected. TopN controls the number of busiest components displayed for the selected object.
To save the Session log to disk, select File Save from the Session window. 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.
Click the Clear Session Log toolbar button to delete the contents of the current Session log. Time Synchronization Toolbar Button For details, see Time Sync on page 4-34. 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 password-protected 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. 1. Open the Dashboard Properties window by doing one of: • In the Browse window, select View > Options.
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.
8 (down). When the Status attribute is graphed and the Use State Graph State option is chosen, the operational state of the object is graphed, and that state icon appears next to the Status attribute in the data grid. Entity Property Sheet Only HP support personnel can access and use the Entity property sheet. NOTE: CPU, Disk, Query, ProcessBusy, and TMF are the five entities that are automatically enabled at Dashboard startup.
Data Query Tool Bar Enable Check Box To display the toolbar in the main Browse window, select the Data Query Tool Bar Enable check box. Icons Button Click the Icons button on the General property sheet to configure the icons and colors you want to represent objects and states in Dashboard, OIL, and OEM windows. When you click the Icons button, the Icon Server control panel appears. The Icon Server lets you configure your icons and colors.
Considerations If you specify a password with no property sheets protected, you own the Set Password dialog box even though no tabs are protected. Thus other users can have access to all property sheet settings, but they are prevented from setting the property sheet password. If you specify no password and no property sheets are protected, you have reset property sheet protection. Other users can then enable property sheet protection. If you select the ALL check box, all property sheets are selected.
Stretch/Compress Grid Columns to Fit Window Check Box Select the Stretch/Compress Grid Columns to Fit Window check box to automatically stretch or compress the grid column width automatically. When this check box is selected and the Browse window is resized, the grid column width for each column is apportioned automatically based on its relative width. Columns with more text are wider, and columns with less text are narrower.
Label Names Compressed Check Box To display object row labels in condensed form, select the Label Names Compressed check box. To display the object rows with their fully expanded name, clear this check box. Graph Percent Check Box If you want the data in graphs to be normalized, select the Graph Percent = value/Graph-Max*100 check box. Use the Attribute property sheet tab to set the Graph-Max normalization value for each entity attribute.
OEM Property Sheet The OEM property sheet controls how segments, entities, and objects are displayed in the Open Enterprise Management (OEM) gateway. Also use this property sheet to control the display of availability and performance icons. Enable the OEM gateway when you want an enterprise management gateway view of segments, entities, and objects known to Dashboard. When you select an entity or object in the OEM framework, Dashboard reports on the selected segment, entity, or object.
Show Utilization in OEM Check Box To display state icons representing alert levels of segments, entities, and objects in the OEM, select the Show Utilization in OEM check box. When this check box is selected, icons are automatically propagated upward through the OEM hierarchy based on the state determination algorithms you specify. You can specify utilization thresholds using the Thresholds button on the OEM property sheet. You can also access thresholds through the Browse window Thresholds toolbar button.
Icons representing the relative alert levels of segments, entities, and objects can be displayed in the OIL. Alert icons are automatically propagated upward through the OIL tree hierarchy. This propagation algorithm assures that even when the OIL tree is collapsed, the highest utilization of segments, entities, or objects is visible. OIL Property Sheet Check Boxes Object Integration Layer Check Box The OIL provides a hierarchical tree view of segments, entities and, optionally, objects.
can also access the Utilization Thresholds control panel by clicking the Thresholds toolbar button in the Browse window or by selecting View > Thresholds in the Browse window.
Utilization Threshold Preset Buttons The Utilization Thresholds control panel contains a set of threshold preset buttons so that you can quickly set Utilization Threshold sliders to predetermined values. OSC Property Sheet The OSC property sheet controls whether Object State Changes are monitored and how they are displayed. OSC monitoring provides both high-level graphical overviews of object state changes and a detailed log of state changes.
determine not only when an object's utilization increased but also when it decreased. From a performance perspective, it might be important to know that a disk such as $DATA went from the Up state to the High utilization state at 8:05. It might be equally important to know that $DATA went from High utilization to the Up state at 8:08. If you want to track state degradation, see “State Downgrades Monitored Check Box” (page 74). Notify Button The Notify button displays the Notify Control Panel.
For example, if you select 200 as the maximum, up to 200 of the most recent state changes are retained in the OSC log. The OSC log is retained in workstation memory for fast access. Because detailed statistics are stored in the Dashboard Server, the OSC log is small and uses little workstation memory. Late Data Integrity Check List The Late Data Integrity Check list controls whether late data integrity checking is performed and, if so, how early or late data can be before it is flagged as a down time.
Report content can vary from short text messages to rich color-coded HTML content. Notifications can contain single or multiple reports. Notify Profile The Profile portion of the Notify control panel allows you to customize notification rules. Profile list: Allows you to configure multiple notification profiles (each with different SMTP server, Recipients, Notify Rule, Content, and report styles).
The Notify Rule menu allows you to control what conditions will cause a profile to send a notification. Notifications can occur: • • • • At periodic time intervals such as Every 1, 2, 3, 4, 6, 8, 12 .. Hours; At user-defined times such as 6:17, 7:30, 9:45, 11:00, 12:55, 15:05, … When object-state changes occur, OnStateChange When new sampling analysis activity occurs, OnEachSample Alerts Menu: If the value selected is zero, the display of an Alerts report is disabled for this profile.
Notify Recipients To, CC, BCC fields: Define the recipients who receive electronic mail (e-mail) notifications. These fields all accept comma-separated lists of e-mail addresses to whom notifications will be mailed, courtesy copied, or blind copied. For example, To field recipients can be specified as: To: John.Doe@MyEmail.com, 8885551234@Mobile.Att.
Valid options for configuring access to intranet and or internet mail servers follow. You should contact your system administrator for assistance if you are not familiar with configuring access to e-mail servers. Three configuration possibilities: • • • POP and SMTP Server fields blank: Leaving both the POP and SMTP fields blank allows you to use the Dashboard notification mechanism locally, without sending e-mail or pager notifications.
When you enable the CSG for the first time, you might need to go to the Client Server Gateway Options window to configure your TCP/IP or Asynchronous transport communication settings. See “Starting and Configuring the Client Server Gateway (CSG)” (page 25). If you cannot establish a Host Session using the Client, use the Dashboard Session log and the CSG terminal window to inspect your Host Session dialog. Also review your CSG Options to confirm host communication settings.
Trace Requests Check Box To have requests to the host system traced in the Dashboard Session window, select the Trace Requests check box. Select View > Session in the Browse window to view this trace. Because Dashboard performance is degraded while tracing, you should usually disable tracing. Trace Replies Check Box To have replies from the host system traced in the Dashboard Session window, select the Trace Replies check box. To view this trace, select View > Session in the Browse window.
SSG/CSG Advanced Button The Advanced button displays the SSG/CSG Advanced control panel. HP recommends that you not change these settings. SSG/CSG Advanced Control Panel The SSG/CSG Advanced control panel manages advanced property settings for the Dashboard session. 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.
enabling this option. If you are experiencing excessive Server loading, set the Enable Flow control option with IOCONTROL equal to 64. Disable Flow Control Option The Disable Flow Control option disables I/O Flow Control for your Client regardless of the Dashboard Server IOCONTROL settings. HP recommends this option only for advanced users. Its purpose is to disable flow control for this Client when the Dashboard Server might be initiating flow control on behalf of other Clients.
6 Using Entity Screen Information This section describes the active Dashboard entity screens and their attributes.
Figure 6-1 CPU Entity Screen CPU Entity Attributes Table 6-1 describes the attributes displayed on the CPU entity screen. Table 6-1 CPU Entity Attributes 86 Attribute Description Busy% Percentage of the processing Yes node that is busy 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 No the processing node.
Table 6-1 CPU Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Queue Queue length of processes waiting to execute. Yes Yes Status Operational status of the Yes processing node. A green Up icon signifies the processing node is up with thresholds. A red Down icon signifies the processing node is down. Yes Swap Memory manager page Yes fault rate in page faults per second. Yes Time Time of statistics.
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 88 Attribute Description Busy% Percentage of time a disk is Yes busy reading, writing, and seeking. Yes Chit Total cache hits per second Yes for all block sizes. Yes DiskName Logical disk volume name. No Yes Fragment Size of the largest fragment No on the disk volume, in megabytes. Yes Full% Percentage of disk space currently used.
Table 6-2 Disk Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? M Mirror disk path in use, where the value is P (Primary) or B (Backup). No Yes Segment Name Name of the Neoview segment. No Yes OutKb Output in kilobytes per second. No Yes P Primary disk path in use, where the value is P (Primary) or B (Backup). No Yes Qlen Disk process receive queue Yes length integrated over the sample interval.
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 90 Attribute Description Ancestor Name Name of the process that No started the busy process. This name consists of the segment name, followed by either a process name, like $ZAAM, or pair of identifying numbers like 1,177. If the ancestor name is unavailable, the displayed value is N/A.
Table 6-3 ProcessBusy Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Group Process security group accessor ID. No Yes Name Process logical name. No Yes Segment Name Name of Neoview segment. No Yes Pages Number of memory No manager pages allocated to and consumed by the process. Yes Pin Process identification number. No Yes Pri Process execution priority. No Yes Program File Name Program object filename on No the disk.
Figure 6-4 Query Entity Screen 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 92 Attribute Description AppID The name of the application No as supplied by Neoview SQL.
Table 6-4 Query Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? BusyESPs Total number of ESP processes that are as busy as or busier than BusyVal. Yes Yes BusyESPSeg Segment of the busiest ESP. No No BusyVal BusyVal parameter, which is always the same. No No ClientID Name of the client. No Yes Con% Processor utilization for the Yes Neoview SQL connection server during the last interval. Yes DataSource Data set name.
Table 6-4 Query Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Sys% System utilization Yes percentage for all query processes during the last interval. Sys% only includes processes for which Busy is greater than the value of BusyVal. Yes Time Time of statistics. No Yes TotCon% Cumulative system utilization percentage for the connection server .
The connection server currently executes one query at a time and provides a level of uniqueness suited for naming queries. Showing Removed Queries The Query entity continues to display removed queries for a specified amount of time after they stop running (the default is 15 minutes.) The time value is displayed and set from the Delete Removed list to the right of the Show Removed Objects checkbox on the General tab in the Dashboard Properties window.
Figure 6-5 TMF Entity Screen TMF Entity Attributes Table 6-5 describes the attributes displayed on the TMF entity screen. Table 6-5 TMF Entity Attributes 96 Attribute Description Active “Yes” means an audit dump No is currently dumping. Yes BeginTr Begin transaction status (enabled or not enabled). Yes Yes Catalog Catalog status. No Yes Duration Elapsed time of the No longest-running transaction, in seconds. Yes Hold “Yes” means no audit because there is no audit-trail space.
Table 6-5 TMF Entity Attributes (continued) Attribute Description Default Attribute for Graph? Default Attribute for Grid? Hung Number of hung Yes transactions. “Yes” means that at least one transaction is hung. Yes Segment Name Name of the Neoview segment. No Yes Ovflw “Yes” means overflow space Yes is in use. Yes Status Operational status of Yes Neoview transaction services. A green Up icon signifies that transaction services are available.
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, Suspend, or Resume. 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: • • 100 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.
• • 6. Click Yes to accept the Manage action on a single selected query or for one query at a time. Click Yes to All to accept the Manage action on all selected queries. 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.
Table 7-1 describes the information provided in the Operations Status window. Table 7-1 Operations Status Window Information Column Provides This Information... ID The number of the operation from the Command and Control session. Type The action that was attempted. Valid actions are Suspend, Resume, and Kill. Query The full domain name of the target query. The value should match the value displayed for that query in the Domain column of the Query entity. Status The outcome of the action.
As Figure 7-1 shows, you select and execute one of the Clear options by right-clicking the selected query operation from the Operations Status window. Select and clear multiple operation by shift-clicking them. Clear the Operations Status log by clicking within the window and selecting the desired Clear action. The GUI prompts you for confirmation with a message. Only completed operations can be cleared. Pending or in-progress operations remain in the Operations Status log.
8 Switching Between Neoview Platforms To change the current Dashboard host session from the current Neoview platform to another Neoview platform: 105
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. 106 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. 108 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. 110 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 Graph, 67 OEM, 69 OIL, 70 OSC, 73 SSG, 79 A Attribute property sheet , 59 B Browse window , 28 C Client features, 20 GUI components, 21 installing, 23 overview, 19 starting, 25 CPU entity , 85 CSG starting and configuring, 25 Q Query entity , 91 R Report window , 53 S Session window , 55 SSG property sheet , 79 Starting and configuring the CSG, 25 Starting the Client, 25 D T Disk entity , 87 Documents, related information, 15 TMF entity , 95 E Entities CPU, 85 Disk, 87 ProcessBusy, 89 Query
