HP Database Manager (HPDM) User Guide HP Part Number: 584024-001 Published: October 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 Learn About This Document...............................................................................................9 Publishing History..................................................................................................................................9 New and Changed Information..............................................................................................................9 Intended Audience..................................................................
Customize HPDM Windows................................................................................................................32 Manage Windows.................................................................................................................................32 Get Version and Build Information......................................................................................................32 4 Perform Basic HPDM Operations...........................................................
Usage Tab.........................................................................................................................................53 DDL Tab...........................................................................................................................................54 Statistics Tab....................................................................................................................................54 Privileges Tab...................................................
See the Parts of the System Monitor.....................................................................................................77 Understand the Performance Metrics...................................................................................................78 Use Tooltips to Show the Value of a Performance Metric....................................................................79 About the Timeline Tab..........................................................................................
10 Use the SQL Whiteboard.......................................................................................117 About the SQL Whiteboard................................................................................................................117 Access the SQL Whiteboard................................................................................................................117 Learn About the SQL Whiteboard Panes...............................................................................
Learn About This Document This guide describes how to use the HP Database Manager (HPDM) to monitor and manage a Neoview Data Warehousing Platform for Business Intelligence. Publishing History This guide supports HP Neoview Release 2.4 Service Pack 1 and all subsequent Release 2.4 product versions until otherwise indicated by its replacement publication.
Related Documentation This manual is part of the HP Neoview customer library. Neoview Customer Library The manuals in the Neoview customer library are listed here for your convenience. Customer library manuals are available on the customer documentation Web site. “Resources on the Web” (page 11).
Neoview Repository User Guide Information about using the Repository, including descriptions of Repository views and guidelines for writing Neoview SQL queries against the views. Neoview System Monitor Quick Start Instructions for starting, using, customizing, and troubleshooting the Neoview System Monitor. Neoview User Management Information Information about the logging of user-management actions on the Neoview platform and the facilities available for monitoring such actions.
Send Feedback to HP 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 and part number shown below, and any comment, error found, or suggestion for improvement you have concerning this document.
1 Install and Start HPDM What is the HP Database Manager? The HP Database Manager (HPDM) is an integrated graphical client that allows you to connect to and manage multiple HP Neoview platforms. HPDM provides database-object browsing and monitoring capabilities that are superior to the current Neoview DB Admin product. HPDM requires the HP ODBC 2.0 client driver for Windows to connect to an HP Neoview platform. Download the HP ODBC 2.
Install the HP Database Manager The HP Database Manager is installed with a Windows installer. You can find the installer by searching for “HP Database Manager” on the HP Software Depot web site. Instructions for installing the software are contained in the README for the HP Database Manager (HPDM). See “Resources on the Web” (page 11).
NOTE: Most HPDM features require you to connect to the Neoview data warehousing platform through the ODBC client driver. For more information, see the README for the HP Database Manager (HPDM). To access the README, see “Resources on the Web” (page 11). Use Menu Bar Commands The menu bar is the list of commands at the top of the HPDM main window. The menu bar commands are: File, Edit, Tools, Windows, and Help.
2 Connect and Disconnect Connect to a System If this is the first time you are attempting to connect to a system, you must create a system definition. See “Add a System” (page 20). If a system definition is already created, use these steps to connect: 1. Enter the Connect command by using either of these methods: • In the My Other Systems folder, right-click the system name, and select Connect. The Connect / Edit System dialog box appears.
Fields Description Password Neoview password. Host The DNS name or IP address for the target Neoview platform. Port Number The NDCS server port number. Default Schema The default schema to use if composing a query. For the current release, if this field is left blank, the default schema is typically the schema matching your user name with any lowercase characters upshifted. Driver The installed Neoview ODBC driver to be used with this Neoview platform.
Log On and Off You log on to HPDM as part of connecting to a system. See “Connect to a System” (page 17). To connect to a system, you must create a system definition. The system definition is saved and can be reused over and over again. After a system definition is created, you need only specify a password to connect to a system. The tool you use to work with system definitions is the Systems Tool. See “Use the Systems Tool” (page 19).
The button options for the Systems Tool are: Button Function [ Test ] Tests a selected system and displays the results in the Connection Test Result dialog box. [ Test ] is enabled if one or more systems are selected. [ Edit ] Launches the Connect / Edit System dialog box with the selected systems’ current settings. [ Edit ] is enabled if one or more systems are selected. [ Add ] Launches the Add System dialog box with blank settings, except for the port number (which defaults to 18650).
3. Click one of these buttons: NOTE: Once a system is added, the system definition persists from session to session unless it is removed. Button Description [ Add] Creates the new system definition, but does not attempt to connect to the system. [ Connect ] Attempts to create the new system using the entries specified in the Add System dialog box: • If the connection is successful, the entry for the system is created and appears in the Systems Tool window.
In the Add System dialog box, these buttons allow you to add a new system, add and connect to a new system, or cancel the operation. Button Description [ Add ] Creates the new system definition, but does not attempt to connect to the system. [ Connect ] Attempts to create the new system using the entries specified in the Add System dialog box: • If the connection is successful, the entry for the system is created and appears in the Systems Tool window.
1. Use either of these methods to open the Add System Like dialog box: • In the navigation tree pane, right-click any system name, and select Add System Like This. The Add System Like dialog box is displayed. • Display the Systems Tool by selecting Tools > Systems Tool from the menu bar. Select the system definition that you want to copy. Then click [ Add Like ]. The Add System Like dialog box is displayed. 2. In the Add System Like dialog box: a. Specify a new name in the Your name for system field. b.
1. 2. 3. 4. Connect to the system as described in “Connect to a System” (page 17). Display the Systems Tool by selecting Tools > Systems Tool from the menu bar. Select the connected system that you want to test. Click [ Test ]. Selecting the Test System or [ Test ] command: • • Causes an attempt to make a connection to the Neoview platform specified in the selected system definition.
3 Navigate HPDM See the Parts of the HPDM Interface Related Topics “Use the Navigation Tree Pane” (page 27) “Use the Right Pane” (page 29) “Use the My Favorites Pane” (page 30) “Use Menu Bar Commands” (page 15) Select an Area To select an area, click one of the blue bars below the navigation tree pane: See the Parts of the HPDM Interface 25
Areas are broad categories of features that you can monitor or manage using HPDM. The supported areas are: Area Description Monitoring Provides alert and alarm information for the system. Provides the system message, as well as any other system-wide information that might be informative to an administrator or user. Each aspect of the system that is displayed in the Monitoring area is contained within its own tab. Database Provides information about the database objects.
To hide an area: 1. 2. Deselect the option for the area in the Show/Hide Area Options group box. Click [ OK ]. To show an area that is hidden: 1. 2. Select the option for the area in the Show/Hide Area Options group box. Click [ OK ]. Related Topics “Select an Area” (page 25) Terms area Use the Navigation Tree Pane The navigation tree pane is the left pane of HPDM below the My Favorites pane. “See the Parts of the HPDM Interface” (page 25).
To display options for an active system in the My Active Systems folder, right-click a system definition and the options are: Menu Item Description Add to Favorites Creates a shortcut for the object under “My Favorites.” The New Favorite dialog box is launched to provide an alias for the object. See “Use the My Favorites Pane” (page 30). Refresh Refreshes the object and all children for the object in the navigation tree. Disconnect Closes all ODBC communication with the system.
Menu Item Description Connect Uses the values defined in the system definition to establish an ODBC connection with the system. See “Connect to a System” (page 17). Edit Edits an active system. See “Edit a System” (page 22). Add System Like This Adds a system like the selected system’s current settings. See “Add a System Like...” (page 22). Remove System Removes a selected system. See “Remove a System” (page 23).
If tabular data is displayed in the right pane, the buttons available in the bottom right pane are: Button Function [ Data to Clipboard ] Copies the table data to the Windows clipboard. See “Export Data” (page 37). [ Data to Browser ] Opens a browser to display the data in a tabular format. See “Export Data” (page 37). [ Data to Spreadsheet ] Opens the Excel application and displays the data. See “Export Data” (page 37). [ Data to File ] Exports the data to a file in CSV format.
4. Type a name for the favorite (names must be less than 256 characters), and click [ OK ]. If you selected a folder in the first step, the favorite is added to the folder. If not, the favorite is added to the “My Favorites” top-level hierarchy. Use a Favorite To use a favorite, click the favorite in the My Favorites pane. Information about the favorite is displayed in the right pane.
The header displays: • • • • The name of the system definition Host and port information for the current connection User name The selected area or information about the database object currently selected in the navigation tree pane Customize HPDM Windows HPDM allows you to customize and resize areas that are displayed. HPDM scrolls continuously in any direction, when the appropriate scroll arrow is clicked and held.
The About dialog box also displays information about the installed components: • Installed Components displays the components currently installed in this HPDM product version. • Description describes the components. Click the installed component to view a brief description of the component.
4 Perform Basic HPDM Operations Sort and Move Data Columns You might want to see rows in an HPDM display (for example, a list of schemas) grouped by a specific type of information. You can sort the displayed data based on column values. You can also change the order of the columns by dragging a column heading to the left or right.
To change the sort order of a displayed column: • Click the title of the column that you want to sort. A triangle appears to the right of the heading to indicate ascending or descending order: Click the heading again to reverse the sort order. To sort on multiple columns: • Click a column heading. Hold down the Ctrl key and click another column heading. Continue holding down the Ctrl key and clicking additional column headings until you have selected all of the desired columns for the multicolumn sort.
To clone a tab, double-click the tab name, or right-click a tab name and select Clone in Window. NOTE: Cloning is not currently supported for these tabs: • Bar Graph • Timeline • Hybrid • System Offender • Privileges Export Data Export Data to the Clipboard [ Data to Clipboard ] saves the data to the clipboard. Each value is a double-quoted string. The clipboard can then be pasted to any Windows document (for example, Excel, Notepad, or Word).
NOTE: The Export buttons are disabled if the table has no data. Communicate System Messages to Users If you are an administrator for a Neoview platform, you may need to communicate information to users of HPDM. For example, this information might include current software configuration or maintenance notifications.
Navigate the System Message Tab The navigation of the System Message tab contains a tree of active and other systems. The right pane displays the system message for the selected active system. If an “other” system is selected, the system’s definition is displayed. Otherwise, selecting the My Active Systems or the My Other Systems folders displays a table displaying information about the systems under the folder. Create a System Message To create a system message: 1. 2. 3. 4.
System definitions are saved in a persistence file. The persistence file is a binary file that contains state and user preference information. This information includes: • • • • • System definitions User-specified options Favorites Statements executed from the SQL Whiteboard SQL Whiteboard layout information The persistence file typically is located in the default directory for your Windows user name.
• • • super.super super.services Any user having administrative privileges NOTE: Event-message diagnostic information is primarily for use by HP support. If you have questions about event messages, contact your HP support representative. To view dial out or database events: 1. 2. 3. 4. Under My Active Systems, right-click the Neoview platform for which you want to view events, and select Dial Out Events or Database Events. A browser window appears. Enable the browser window to run JavaScript.
Recovery Informational message only; no corrective action is needed.
Statistic Description NodeName Name of the Neoview platform used by the data source. CpuPin Operating system CPU number in which the NDCS server is running, followed by the process ID of the server.
Statement Statistics: SQL Statement Statement statistics are written to the alternate EMS collector at the time a PREPARE statement is received (listed in the order written in the event message): Statistic Description Session ID Unique session ID generated by the NDCS SQL server at the time the connection is established. Message Attribute STATEMENT:SQLStatement (the statistics option that was selected). Sequence Number Message sequence number generated by NDCS.
Statement Statistics: SQLExecDirect SQLExecDirect statistics are written to the alternate EMS collector at the time an EXECUTE statement is received (listed in the order written in the event message): Statistic Description Session ID Unique session ID generated by the NDCS SQL server at the time the connection is established. Message Attribute STATEMENT:SQLExecDirect (Statistics option that was selected.) Sequence Number Message sequence number generated by NDCS.
Statement Statistics: SQLFetch SQLFetch statistics are written to the alternate EMS collector at the time a statement is closed (listed in the order written in the event message): 46 Statistic Description Session ID Unique session ID generated by the NDCS SQL server at the time the connection is established. Message Attribute STATEMENT:SQLFetch/SQLClose (Statistics option that was selected.
5 Manage Database Objects This section describes how to display schemas, tables, table indexes, views, materialized views, materialized view indexes, materialized view groups, procedures, synonyms, and triggers in HPDM. Display Schemas and Their Objects To display the schema names and attributes for the schema: 1. 2. 3. 4. Start the HP Database Manager and log on using any user ID. Click the Database area. HPDM displays a list of existing schemas and their owners.
Attributes Tab To display the schema attributes and values that belong to the schema: 1. 2. Navigate to the Schema folder and click the name of the schema to see information about the schema and its objects. Click the Attributes tab in the right pane. In the right pane, these attributes are displayed: • Name: Name of the schema. • Owner: The owner of the schema. • Version: Specfies the version of the schema. Tables Tab To display the table names that belong to the schema: 1. 2.
Views Tab To display the views that belong to the schema: 1. 2. Select aSchema in the navigation tree. Click the Views tab in the right pane, or open the Views folder. In the right pane, these attributes are displayed: • Name: Name of the view. Each view is hyperlinked and detailed information about the view is displayed. • Creation Time: Time and date when the view was created. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Privileges Tab To display the privilege information for the schema: 1. 2. Select a Schema in the navigation tree. Click the Privileges tab in the right pane. The Privileges tab displays a table showing the access privileges: • • • • • Grantee: The name of a user or role whose privilege is being described. Grantor: The name of the user or role who granted the privileges and the special SQL user names “PUBLIC” and “SYSTEM.” With Grant: Specifies an ‘X’ to indicate if the user or role has grant privileges.
In the right pane, these tabs appear: • Columns tab • Primary Key tab • Hash Key tab • Unique Constraints tab • Foreign Keys tab • Attributes tab • Partitions tab • Usage tab • DDL tab • Statistics tab • Privileges tab You can also expand Tables to display a table list in the left pane. Each table in the navigation tree contains a folder called Indexes and a folder called Triggers. The Indexes folder expands to show the indexes of a specified table.
• • • • • Primary Key: Specifies the icon or special symbol to indicate column is part of the primary key. Column Name: Name of the column (string). Data Type: SQL datatype of the column. Nullable: If a column is NOT NULLABLE NOT DROPPABLE, the value displayed is “Not Nullable.” If the column is NOT NULL, the value displayed is “Not Nullable.” If the column is NULL, the value is blank. Default: For schema version 2300 or earlier, the default value displayed is “GENERATED BY DEFAULT AS IDENTITY”.
1. 2. Select a Schema in the navigation tree and click the table name in the right pane, or open the Tables folder and select a table name in the tree. Click the Foreign Key tab in the right pane. In the right pane, these attributes are displayed: • Name: Name of the foreign key constraint. • Foreign Table: Name of the foreign table. • Local Column: Name of the local column of the foreign key. • Foreign Column: Name of the foreign column of the foreign key.
1. 2. Select a Schema in the navigation tree and click the table name in the right pane, or open the Tables folder and select a table name in the tree. Click the Usage tab in the right pane. The Usage tab displays the usage relationships of the table with other objects, if any. The attributes displayed are : • Relationship: Specifies the relationship of the table with the object specified. The values are: “Uses”, “Used By”, “Has.” • Related Object Type: Specifies the object type of the related object.
• Grant Level: The level at which the permissions are visible. The values displayed in this column are: Schema, Object, or Column. — Schema indicates permissions have been applied to the schema. — Object indicates permissions were applied directly to the object whose permissions are being displayed. — Column indicates the permissions applied to the column.
In the right pane, these tabs appear: • • • • Columns tab Attributes tab DDL tab Partitions tab Columns Tab To display the table index columns: 1. 2. 3. Select a Schema in the navigation tree. Click the Tables folder and open the Indexes folder and select an index name. Click the Columns tab in the right pane. In the right pane, these attributes are displayed: • Column Name: Name of the column (string). • Sort Order: Specifies the order as “Ascending” or “Descending.
• • • Populated: Specifies if the index has been populated, the value is “Yes” or “No.” Creation Time: Time and date when the table index was created. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). Redefinition Time: Time and date when the table index was last redefined. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). DDL Tab To display the DDL output for table indexes: 1. 2. 3. Select a Schema in the navigation tree.
Display Views and Their Properties To display the view information: 1. 2. 3. 4. 5. Start the HP Database Manager and log on using any user ID. Click the Database area. Select a system in My Active Systems in the navigation tree. Select a Schema in the navigation tree. Select the Views tab in the right pane, or open the Views folder and select a view. HPDM displays the views in this schema.
• • • Data Type: SQL datatype of the column. Nullable: If column is NOT NULL NOT DROPPABLE, the value displayed is “Not Nullable.” If the column is NOT NULL, the displayed value is “Not Nullable.” If the column is NULL, the value is blank. Default: The default of the column. Usage Tab To display the usage information for a view: 1. 2. 3. Select a Schema in the navigation tree. Click the Views tab, or open the Views folder and select a view. Click the Usage tab in the right pane.
— — — • Schema indicates permissions have been applied to the schema. Object indicates permissions were applied directly to the object whose permissions are being displayed. Column indicates the permissions applied to the column. When an object level privilege applies to all columns, the individual column privileges are not displayed, otherwise the individual column level permissions are listed. Privileges: Describes the privilege of the user or role.
• • DDL tab Privileges tab Attributes Tab To display the materialized view attributes: 1. 2. 3. Navigate to the Schema in the navigation tree Click the Materialized Views tab in the right pane and select a materialized view name, or open the Materialized Views folder and select a materialized view name in the tree. Click the Attributes tab in the right pane. In the right pane, these attributes are displayed: • Name: External name of the materialized view.
• • Creation Time: Time and date when the materialized view was created. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). Redefinition Time: Time and date when the materialized view was last redefined. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). Partitions Tab To display the materialized view partitions: 1. 2. 3.
For more information about displaying DDL, see “Display Schema DDL and Their Properties” (page 73). Privileges Tab To display the privileges for the materialized view: 1. 2. 3. Select a Schema in the navigation tree. Click the Materialized Views tab in the right pane and select a materialized view name, or open the Materialized Views folder and select a materialized view name in the tree. Click the Privileges tab in the right pane. The Privileges tab displays a table showing the access privileges.
4. 5. 6. Select a Schema in the navigation tree. Open the Materialized Views folder, select and open a Materialized View. Open the Indexes folder and select a materialized view index in the tree. In the right pane, these tabs appear: • • • • Columns tab (user only) Attributes tab DDL tab Partitions tab Columns Tab To display the materialized view index columns: 1. 2. 3. 4. Select a Schema in the navigation tree. Open the Materialized Views folder, select and open a materialized view.
For more information about displaying DDL, see “Display Schema DDL and Their Properties” (page 73). Partitions Tab To display partition information for a materialized view index: 1. 2. 3. 4. Select a Schema in the navigation tree Open the Materialized Views folder, select and open a Materialized View. Open the Indexes folder and select a materialized view index in the tree. Click the Partitions tab in the right pane.
In the right pane, these tabs appear: • • • Attributes tab Members tab DDL tab Attributes Tab To display the materialized view groups attributes: 1. 2. 3. Select a Schema in the navigation tree. Click the Materialized View Groups tab in the right pane, or open the Materialized View Groups folder and select a materialized view group name in the tree. Click the Attributes tab in the right pane. In the right pane, these attributes are displayed: • Name: Name of the materialized view group.
1. 2. 3. Select a Schema in the navigation tree. Click the Materialized View Groups tab in the right pane, or open the Materialized View Groups folder and select a materialized view group name in the tree. Click the Members tab in the right pane. In the right pane, the members are displayed in a table with the following attributes: • Name: Name of the materialized view group member. The object names are 2–part ANSI names. • Creation Time: Time and date when the materialized view group member was created.
In the right pane, these tabs appear: • • • Attributes tab Parameters tab Privileges tab Attributes Tab To display the procedure names and attributes: 1. 2. 3. Select a Schema in the navigation tree. Click the Procedures tab in the right pane and select a synonym name, or open the Procedures folder and select a procedure name in the tree. Click the Attributes tab in the right pane. In the right pane, these attributes are displayed: • Name: The name of the procedure.
Parameters Tab To display the procedure parameter information: 1. 2. 3. Select a Schema in the navigation tree. Click the Procedures tab in the right pane and select a procedure name, or open the Procedures folder and select a procedure name in the tree. Click the Parameters tab in the right pane. In the right pane, these attributes are displayed: • Name: Name of the parameter. • Direction: The values displayed are: IN | OUT | INOUT. IN passes data to the procedure. OUT accepts data from the procedure.
4. 5. Select a Schema in the navigation tree. Click the Synonyms tab in the right pane and select a synonym name, or open the Synonyms folder and select a synonym name in the tree. In the right pane, these tabs appear: • • • Attributes tab Usage tab DDL tab Attributes Tab To display the synonym names and attributes: 1. 2. 3. Select a Schema in the navigation tree. Click the Synonyms tab in the right pane and select a synonym name, or open the Synonyms folder and select a synonym name in the tree.
1. 2. 3. Select a Schema in the navigation tree. Click the Synonyms tab in the right pane and select a synonym name, or open the Synonyms folder and select a synonym name in the tree. Click the Usage tab in the right pane. The Usage tab displays the usage relationships of the synonym with other objects, if any. These attributes displayed are: • Relationship: Specifies the relationship of the synonym with the object specified. The value is “References.
In the right pane, these tabs appear: • • • Attributes tab Usage tab DDL tab Attributes Tab To display the trigger attributes: 1. 2. 3. Select a Schema in the navigation tree. Click the table name in the right pane, or open the Tables folder and then open the Triggers folder and select a trigger in the tree. Click the Attributes tab in the right pane. In the right pane, these attributes are displayed: • Name: Name of the trigger. • Is Enabled: Specifies if the trigger is enabled.
Usage Tab To display the trigger usage information: 1. 2. Select a Schema in the navigation tree and click the table name in the right pane, or open the Tables folder and then open the Triggers folder and select a trigger in the tree. Click the Usage tab in the right pane. In the right pane, these attributes are displayed: • Relationship: Specifies the relationship between this trigger and the object. • Related Object Type: Specifies the object type of the object.
The external format of the Show DDL output is displayed. For more information on the format of the Show DDL command, see the Neoview SQL Reference Manual. Show DDL Show DDL allows you to select objects for which you want DDL output fetched and displayed. NOTE: Opening up Show DDL to the system-level allowing you to select different catalogs and schemas and their objects may cause performance issues. To avoid performance issues, Show DDL limits the selection to a specific schema.
• • The DDL Output pane has a text box with scroll bars and the DDL output is displayed in the text box. The Show DDL dialog box options are: Button Description [ Load ] Loads the Show DDL output of the selected objects (with check boxes selected) and replaces the contents in the DDL Output pane. [ Append ] Appends the selected objects to the existing contents in the DDL Output pane. [ Clear All ] Clears selected objects (with check boxes selected) in the Selected Objects pane.
3. 4. Select a Schema in the navigation tree. Click the Statistics tab in the right pane. The Statistics tab displays the histogram statistics for the table. For each column in the table, the data is fetched from the HISTOGRAMS UMD table. The right pane displays these attributes: • Name: Name of the column. • Datatype: Specifies the column datatype. • # Nulls: The number of null values for the column. An interval (bucket) with "(NULL)” as the boundary value from the histogram_intervals table.
6 Use the System Monitor Display the System Monitor The system monitor is a tool within HPDM that displays status and performance data for the Neoview platform. The displayed status and performance data includes seven performance metrics and four system status icons. NOTE: The system monitor is visible for both connected and disconnected systems. The system monitor uses TCP/IP UDP datagrams to communicate with a server component on the Neoview platform.
Related Topics “Configure System Monitor Options” (page 82) “Understand the Performance Metrics” (page 78) “Understand the System Status Icons” (page 80) Terms segment Understand the Performance Metrics The system monitor shows seven performance metrics: Metric Description CPU Busy The average busy value of the specified processing node (CPU) over the last refresh interval. Disk I/O The average number of disk I/O operations over the last refresh interval.
“Use Tooltips to Show the Value of a Performance Metric” (page 79) Use Tooltips to Show the Value of a Performance Metric When the system monitor bar graph (Bar Graph tab) is displayed, you can quickly obtain the current value of a metric for a given segment and CPU. To obtain the current value, hold the cursor over the bar for the CPU.
About the Hybrid Tab The Hybrid tab shows a bar graph and a set of timelines side by side: Related Topics “About the Timeline Tab” (page 79) “Configure System Monitor Options” (page 82) Understand the System Status Icons The four system status icons (Connectivity, Disks, Transactions, and Alerts) provide an at-a-glance summary of the up or down state of various subsystems and tell you if any alerts are present: 80 Use the System Monitor
This table describes the icons: Icon Description Connectivity Icon for the association servers. Indicates if $MXOAS and $MXAS2 are running. $MXOAS is the component of the Neoview Database Connectivity Service (NDCS) that receives client connection requests for database access and associates the requestor with a server to execute the requested access.
For more information about the Alerts icon, see “Get Information About Alerts” (page 89). Related Topics “Understand the System Status Icons” (page 80) “Get Information About Alerts” (page 89) Configure System Monitor Options The system monitor options pane allows you to control the display of performance metrics, including the bar colors, the refresh rate, and other parameters. To display the system monitor options pane: 1.
Option or Setting Description Metric and 100% Settings Control the bar/line color, show/hide option, and 100% setting for performance metrics. For example: • The bar/line color is the color of the specified bar in the bar graph or the line in the timeline. See “Change a Color Option” (page 84). • The show/hide option controls whether or not the metric is displayed. When a show/hide options is selected, the performance metric is displayed. When the option is deselected, the metric is hidden.
Use the System Monitor With Segment Aggregation If segment aggregation is selected in the system monitor options pane, the display changes to show only one bar per segment. For example, if your system has four segments, the system monitor shows four colored bars for each metric. Each bar represents the average (arithmetic mean) value for that segment. Clicking any of the segment bars in the bar graph area of the Bar Graph tab or Hybrid tab changes the display to “drill down” on that segment.
3. 4. 5. Select a color from the color palette. Click [ OK ]. Click [ Apply ].
7 Respond to Alerts Display the Alerts Tab NOTE: Diagnostic information displayed by the Alerts tab is intended for use by HP support. This information is not documented for customer use. If you have questions about an alert condition, contact your HP support representative. Special privileges are required to display the Alerts tab. See “Understand Privileges for Viewing and Updating Alerts” (page 88). To display the Alerts tab: 1. 2. 3.
Understand Alerts NOTE: Diagnostic information displayed by the Alerts tab is intended for use by HP support. This information is not documented for customer use. If you have questions about an alert condition, contact your HP support representative. Alerts are alarms or incident reports generated by internal subsystems. The system monitor provides a system status icon to summarize the alert condition, and the Alerts tab provides detailed information about specific alerts.
If the current user has update privileges, the ALARM_STATUS column in the Alerts data grid displays a menu with selectable update states (ACKNOWLEDGED and USERCLOSED): In addition, the ALARM_NOTES column provides a [ ... ] button that opens the Alert Notes Editor dialog box: If the current user does not have update privileges, the menu and notes button are not displayed.
Alerts Icon Color Description Yellow At least one OPEN or ACKNOWLEDGED alert is present and has a WARN alert level. Green No ERROR or WARN alerts are present, but informational (INFO) alerts might be present. Related Topics “Understand Row Detail Information for Alerts” (page 90) “Understand the System Status Icons” (page 80) Understand Row Detail Information for Alerts This table describes the row detail information for the Alerts data grid.
Field Description IR_STATUS The delivery status of an incident report (IR). Possible values are: CREATED, DELIVERED, FAILED DELIVERY, and UNKNOWN. This column indicates that a dial-out was generated by the Neoview platform, but not necessarily that the dial-out was successfully received by HP support. ALARM_CREATE_UTC_TS* The ANSI timestamp in universal coordinated time (UTC) when the alarm was created.
Terms alert segment Use the Alerts Options Dialog Box To display the Alerts Options dialog box: 1. 2. Display the Alerts tab, as described in “Display the Alerts Tab” (page 87). Click the [ Alter Alerts Configuration ] button: The Alerts Options dialog box appears. This table describes the alerts options and controls: Option or Control Description Open Alerts Only Causes the Alerts data grid to display only the open and acknowledged alerts.
Option or Control Description Time Range (server side LCT) Specifies the interval for which data is fetched in the server-side local civil time (LCT). By default, the Alerts data grid fetches alert details for the last 30 days.
Click this button . . . To do this Stop Data Provider Stop the refresh. Refresh Data Refresh the Alerts data grid at any time. Pause Timer Pause the refresh. Resume Timer Restart the refresh after pausing. Set Refresh Time Change the refresh interval. See the steps for doing this later in this topic. Alter Alerts Configuration Control the display of alerts. See “Use the Alerts Options Dialog Box” (page 92). To change the refresh interval: 1. 2.
2. In the Alerts data grid, right-click any alert (or multiple alerts), and select Update Alert(s). The Update Alert dialog box appears. This table describes the options and fields in the Update Alert dialog box: Option or Field Description Status Allows you to choose between the ACKNOWLEDGED and USERCLOSED statuses. Select a predefined note or enter your own Allows you to select from these options: • Alert resolved flags the alert as resolved. • False alert flags the alert as a false alarm.
NOTE: You must have the necessary privileges before you can update alerts. See “Understand Privileges for Viewing and Updating Alerts” (page 88). To multiple update alert(s): 1. 2. 3. 4. 5. Display the Alerts tab, as described in “Display the Alerts Tab” (page 87). Select cells in multiple rows corresponding to the alerts that you want to update. Right-click and select Update Alert(s). The Update Alert dialog box appears.
To clear the console history, click the Clear Console History icon. To show or hide the Console tab, click the Fetch Status Bar.
8 Find Offending Processes and Queries About System Offender System Offender is a tool that allows you to monitor system resources and detect processes and queries that use excessive CPU resources or memory. These are referred to as “offending” processes and queries. System Offender is a tab within the Monitoring area of HPDM. System Offender shows real-time data about processes and queries. The data is presented in a data grid.
See the Parts of the System Offender Related Topics “Understand System Offender Privileges” (page 100) “Find Offending Processes and Queries” (page 100) Understand System Offender Privileges Administrator users (ROLE.DBA, super.services, and super.super by default) can use all System Offender features. Only administrator users can alter System Offender server parameters, use the Pstate command, and cancel queries.
NOTE: Click once; you do not need to double-click. Click For example Click any CPU bar or header for these performance metrics: –CPU Busy –Disk I/O –Cache Hits –Dispatch –Queue Length or... Click any CPU bar or header for these performance metrics: –Free Memory –Swap or... The System Offender tab displays a list of processes for the specified CPU (or all CPUs). The area you click in the System Monitor determines the System Offender active command. For example: When you click . . .
3. In the System Offender data grid, see a list of processes: 4. Right-click a process that you want to learn more about, and select a command from the context menu: NOTE: The Workload Detail command is active only if a query is associated with the selected process. The context menu commands provide detailed process information. For more information, see these topics.
data grid offending process Get Process Detail Information NOTE: Diagnostic information displayed by the Process Detail and Parent Process Detail dialog boxes is intended for use by HP support. This information is not documented for customer use. If you have questions about process detail information, contact your HP support representative.
Get Pstate Information NOTE: Diagnostic information displayed by the Pstate and Parent Pstate dialog boxes is intended for use by HP support. This information is not documented for customer use. If you have questions about Pstate information, contact your HP support representative.
Use the Children Processes Dialog Box To display the Children Processes dialog box, see “Get Children Process Information” (page 104). This table describes the dialog box fields: Field or Option Description Query ID The query identification number. Query Text The text of the Neoview SQL statement. Parent Process The process that spawned the children processes described in the Detailed tab. Filter CPU Value Controls which processes are displayed in the Detailed tab based on CPU utilization.
NOTE: Diagnostic information displayed by the System Offender tab is intended for use by HP support. If you have questions about an offending process, contact your HP support representative. Field Description SEGMENT The segment number. A Neoview platform consists of up to 16 segments with each segment containing up to 16 processing nodes. CPU The processing node. PIN The process identification number (PIN). The PIN is an unsigned integer that identifies a process in a processing node.
Field Description QUERY NAME The name of the client workstation and application that generated the query. QUERY TEXT A preview of the actual query text (up to 254 characters). ROLE NAME* The role of the user who initiated the query. USER NAME* The user who initiated the query. DATASOURCE The data source. *This field is not displayed by default on the data grid. To display this field, use the Show/Hide Grid Columns command available from the System Offender context menu.
NOTE: Diagnostic information displayed by the Workload Detail dialog box is intended for use by HP support. If you have questions about query diagnostic information, contact your HP support representative. The Workload Detail dialog box is mostly informational. If a query has a rule or service level associated with it, the Warn Level indicator indicates if the rule has been violated.
“Get Query Workload Information” (page 107) “Use the Workload Detail Dialog Box” (page 107) Terms administrator Alter System Offender Parameters To display the Alter Offender Parameters dialog box and alter the parameters: 1. 2. Display the System Offender tab, as described in “Display the System Offender Tab” (page 99). In the toolbar, click the [ Alter Offender Parameters ] button: The Alter Offender Parameters dialog box is displayed. 3. 4.
Control the Refresh of System Offender The System Offender data grid is refreshed automatically every 60 seconds. During a refresh, System Offender fetches new information from the server using the current active command. The active command appears under the System Offender tab. For example: A refresh timer controls the refresh interval. When an update is in progress, the refresh timer is paused. If the update completes successfully, the refresh timer is restarted.
3. Select a refresh interval. The timer status bar counts down the new refresh interval in seconds. Suppose the refresh timer is set to a low value (for example, 30 seconds). If you are investigating an offending process, you might want to pause the timer so that a refresh doesn't change the data displayed in the data grid. To pause the refresh: 1. 2. 3. Display the System Offender tab, as described in “Display the System Offender Tab” (page 99). Click the [ Pause Timer ] button.
9 Work With Data Grids About Data Grids The Alerts tab, System Offender tab, and SQL Whiteboard Statement Details pane display information in a data grid. The data grid is a simple table with columns and some special features for displaying and manipulating data. Data grids allow you to: • • • • • • • Get details about a specific cell or row. Issue commands by right-clicking to display a context menu Sort data within a column. Rearrange columns. Copy cell or row information.
The Row Details dialog box displays all possible column information, whereas the data grid shows only the grid columns that are currently configured using the Show/Hide Grid Columns command.
• To copy the data in noncontiguous cells, hold down the Control key, and select the cells you want to copy. Then right-click, and select Copy: The cell values are loaded into the Windows clipboard, from which you can paste them into other Windows applications.
Customize the Data Grid The columns in data grids are fully customizable: To Do this Show or hide columns 1. Right-click a column heading in any data grid, and select Show/Hide Grid Columns. The Show/Hide Grid Columns dialog box appears. 2. Select the columns that you want to display, and click [ OK ]. NOTE: Change the order of displayed columns Click [ Defaults ] at any time to restore the default column selections.
10 Use the SQL Whiteboard About the SQL Whiteboard The SQL Whiteboard allows you to enter and execute SQL statements from within HPDM and provides execution information for each of the SQL statements. The list of SQL statements is persisted between HPDM sessions the same way that system configuration and favorites are persisted in HPDM. Currently, HPDM supports only one instance of the SQL Whiteboard. SQL statements can be parameterized by embedding parameter names surrounded by double dollar signs ($$).
Learn About the Statement List Pane The Statement List pane provides a list of SQL statements that you added in a current session or earlier sessions of the SQL Whiteboard tool. The list of SQL statements is persisted between HPDM sessions the same way that connection information and favorites are persisted. From the Statement List pane, you can: • • • View the name and statement that was previously added in the Statement pane.
all parameters in that statement and easily allows you to re-use recent values for those parameters. The feature is compatible with Neoview Reports. Cut, Copy, Paste, Undo, and Redo In the Statement pane, if you right-click the text box, these options are displayed: cut, copy, paste, undo, redo, and select all. Execute Highlighted Text If you highlight text, you can execute part of a statement. Cancel a Query From the SQL Whiteboard There may be times when you want to cancel a running SQL query.
NOTE: The Execution Results tab employs a data grid that provides special features for displaying and manipulating tabular information. See “Work With Data Grids” (page 113). Related Topics “Export Data” (page 37) Reuse a Connection The reuse connection feature is enabled by default in the SQL Whiteboard. This means any query executed for the selected system, uses the same connection, unless explicitly closed. Use [ Close ] to explicitly close the connection.
11 Launch the Neoview Command Interface (NCI) Learn About NCI The Neoview platform supports a client-based utility, Neoview Command Interface (NCI), which enables you to enter SQL statements interactively or from script files in its command-line interface. You can also pass an SQL statement to NCI from a Perl or Python command line or from a Perl or Python program. For more information about using NCI, see the Neoview Command Interface (NCI) Guide, or use the command-line help within NCI.
Glossary Admin_Load_ DataSource One of two default data sources for the Neoview platform. Admin_Load_DataSource is the default data source used by the Neoview Transporter. You cannot start, stop, or delete the Admin_Load_DataSource. This data source is always started so that HPDM can continue managing connectivity when all other data sources are stopped. Contrast with TDM_Default_DataSource. administrator A user with administrative privileges. By default, these user IDs are administrators: • super.
Neoview platform A data warehousing platform that includes processors, storage, relational database software, data services software, and professional services dedicated to supporting business intelligence (BI) solutions. offending process A process that consumes an excessive amount of CPU or memory resources. The System Offender tab displays the processes that consume the most CPU and memory resources.
Index defined, 123 selecting, 25 showing and hiding, 26 Symbols 100% settings, 83 21034, event message, 41 21035, event message, 42 B A Build information HPDM client, 32 About box, 32 Active command, 110 Active system status alerts, 82 Add System dialog box, 21 Admin_Load_DataSource defined, 123 Administrator user, defined, 123 Aggregation options, 83 ALARM_CLOSED_LCT_TS, 91 ALARM_CLOSED_UTC_TS, 91 ALARM_COUNTER, 90 ALARM_CREATE_LCT_TS, 90 ALARM_CREATE_UTC_TS, 91 ALARM_EVENT_NUMBER, 91 ALARM_IR_CREATED
DATASOURCE, 107 DDL tab, 73 Detailed tab, 105 Dial out events, 40 Disconnect defined, 123 function, 18 Disk space requirement, 14 Disks icon, 81 display column statistics, 76 Documentation library, 10 Web sites, 11 Documents, related information, 10 features, 13 framework, 13 installing, 14 parts of, 25 SQL Whiteboard, 13 starting, 14 uninstalling, 14 HPDM graphical user interface (GUI), 25 Hybrid tab, 80 I Editing a system, 22 ELAPSED TIME, 106 Events, viewing, 40 Exiting HPDM, 15 Export Persistence com
members tab, 66 Materialized view indexes attributes tab, 64 columns tab, 64 display summary, 65 displaying, 63 partitions tab, 65 Materialized views attributes tab, 61 DDL tab, 62, 64 display summary, 63 displaying, 60 privileges tab, 63 usage tab, 62 Max Range value, 83 Memory requirement, 14 MEMORY USAGE MB, 106 Menu bar commands, 15 defined, 123 Metric settings, 83 Microsoft .
canceling from Whiteboard, 119 canceling from Workload Detail, 108 defined, 124 finding an offending, 100 workload information, 107 QUERY ID, 106 QUERY NAME, 107 QUERY TEXT, 107 R README for HPDM, 14 Red CPU numbers, 105 Refresh changing the interval, 94, 110 pausing, 94, 111 Refresh rate, 82 Release 2.3 compatibility, 20 Release 2.
defined, 124 defining, 20 disconnecting from, 18 editing, 22 removing, 23 testing, 23 System definition defined, 124 header display of, 31 saving or importing, 39 System Messages, 38 cloning, 39 communicating, 38 creating, 39 Monitoring area, 38 navigation, 39 right pane, 39 system message tab, 38 System monitor changing color options, 84 configuring options for, 82 definition, 124 description of, 77 displaying, 77 parts of, 77 performance metrics, 78 tooltips, 79 using with segment aggregation, 84 System O
Web sites, 11 Windows cloning, 36 managing in HPDM, 32 Windows Manager, 32 Workload Detail dialog box displaying, 107 using, 107 130 Index
