HP Database Manager (HPDM) User Guide HP Part Number: 613120-001 Published: July 2010 Edition: HP Neoview Release 2.
© Copyright 2010 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 Guide.............................................................................................................13 Publishing History................................................................................................................................13 New and Changed Information............................................................................................................13 Intended Audience..............................................................
Remove a Favorite...........................................................................................................................41 Remove a Favorites Folder..............................................................................................................41 See the HPDM Banner..........................................................................................................................41 Use Menu Bar Commands..................................................................
Materialized Views Tab...................................................................................................................64 Materialized View Groups Tab........................................................................................................64 Views Tab.........................................................................................................................................65 Procedures Tab..........................................................................
Attributes Tab..................................................................................................................................88 Usage Tab.........................................................................................................................................89 DDL Tab...........................................................................................................................................89 Display Triggers and Their Properties..............................
Use the Change Password Dialog Box...........................................................................................116 Change a Password or Password Expiration Settings by Editing a User......................................116 9 Manage Security Policies..........................................................................................117 About Security Policies.......................................................................................................................
Timeout Option of Controlled Tables Tab................................................................................150 Copy a Data Source.............................................................................................................................150 Start a Data Source..............................................................................................................................151 Stop a Data Source...........................................................................
Get Information About Alerts.............................................................................................................183 Understand Row Detail Information for Alerts..................................................................................184 Use the Alerts Options Dialog Box.....................................................................................................186 Control the Refresh of Alerts..........................................................................
Launch Metric Miner..........................................................................................................................220 See the Parts of Metric Miner..............................................................................................................220 Use the Metric Miner Toolbar.............................................................................................................222 Create Report Folders..............................................................
View Table Growth.............................................................................................................................257 By Table Tab...................................................................................................................................258 Top Fastest Growing Tables Tab....................................................................................................260 Understand Historical Space Data ....................................................
About This Guide This guide describes how to use the HP Database Manager (HPDM) to monitor and manage a Neoview Data Warehousing Platform for Business Intelligence. Related Topics “Publishing History” (page 13) “New and Changed Information” (page 13) “Intended Audience” (page 14) “Related Documentation” (page 15) “Resources on the Web” (page 17) “Send Feedback to HP” (page 17) Publishing History This guide supports HP Neoview Release 2.5 and all subsequent Release 2.
— — — — — — “Use the Windows Menu Options” (page 43) “Use the Help Menu Options” (page 43) “Use the HPDM Toolbar” (page 44) Updated the illustration in “Get Version and Build Information” (page 47). “Resolve Errors and Error Messages” (page 47) “Understand Page Mode” (page 214) • Made these miscellaneous changes: — Added role and default-schema information to “Use the Connect / Edit System Dialog Box” (page 26). — Added user role information to “Use the Systems Tool” (page 28).
Related Documentation This guide is part of the HP Neoview library, which includes: • “Neoview Customer Library” (page 15) 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 17).
Neoview Workload Management Information about using Neoview Workload Management Services (WMS) to Services Guide manage workload and resources on a Neoview data warehousing platform.
Resources on the Web Neoview Customer Documentation http://www.hp.com/go/neoviewdocs HP Software Depot http://www.software.hp.com/ Send Feedback to HP HP encourages your comments concerning this document or this product. We are committed to providing products and documentation that meet your needs. Send any errors found or suggestions for improvement to docsfeedback@hp.com.
1 About HPDM What Is HPDM? 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 Neoview DB Admin product. NOTE: While you can use HPDM to browse and monitor database objects, you cannot use HPDM to create such objects. To create objects such as tables, indexes, and views, you must use the Neoview Command Interface (NCI).
• HPDM Framework — Provides connection management for widgets — Supports persistence for widget and application data — Includes menu management — Implements area management (hide, show, and deploy) — Exports grid contents to a spreadsheet — Manages options for an HPDM application as a whole and for individual areas and widgets — Launches the Neoview Command Interface (NCI) — Supports character sets for ISO, SJIS, or Unicode based on a single-client locale (only one character set can be configured for e
• Support for stored procedures in Java (SPJs) — Display a list of jar files uploaded by users in your current role — Display a list of classes in a jar file — Display a list of methods in a class file — Download one or more jar files from the Neoview platform to the workstation — Upload jar files from a workstation to the Neoview platform — Rename or remove an uploaded jar file — Create an SPJ by using a jar file uploaded by you or another user in your current role — Delete an SPJ created by you or anothe
2 Install and Start HPDM Install the HP Database Manager The HP Database Manager is installed with a Windows installer. You can install the client by itself or as part of a bundle of Neoview clients provided by the Neoview Windows Client Package. Information about the installers can be found 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 17).
• From the Start menu, select Start > All Programs > HP Database Manager > HP Database Manager. NOTE: Most HPDM features require you to connect to the Neoview data warehousing platform through the ODBC client driver. For more information, see “Connect to a System” (page 25). Exit the HP Database Manager To exit HPDM, close the HP Database Manager main window by selecting File > Exit or clicking the Close button ( ) in the upper right corner of the main window.
3 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 29). If a system definition is already created, use these steps to connect: 1. Enter the Connect command by using one of these methods: • In the navigation tree pane, right-click the system icon, and select Connect. • In the navigation tree pane, click the icon for a disconnected system (see “Use the Navigation Tree Pane” (page 37)).
Use the Connect / Edit System Dialog Box This table shows reference information for the Connect / Edit System dialog box: Field Example Description Your Name for System Production Sys 1 A label to identify this Neoview platform. The name can be up to 32 characters in length and consist of letters, digits, and the underscore character. This is a required field. Data Source DSN_PROD1 Specifies the name of the client-side or server-side data source.
In the Connect / Edit System dialog box, these buttons allow you to add a new system definition, connect to a system, or close the system definition. Button Description [ Save ] 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 fields of the Connect / Edit System dialog box: • If the connection is successful, the entry for the system is created and appears in the Systems Tool window.
1. Enter the Disconnect command by using one of these methods: • In the navigation tree pane, right-click the icon for the connected system, and select Disconnect. • In the navigation tree pane, click the icon for a connected system (see “Use the Navigation • Tree Pane” (page 37)). Then click the Disconnect button ( ) on the HPDM toolbar. Display the Systems Tool by selecting Tools > Systems Tool from the menu bar. Select a system definition, then click [ Disconnect ]. The Confirm dialog box appears. 2.
The Systems Tool window displays these settings: Setting Description State The current state of the system definition (Connected or Disconnected). System Name The label that identifies this Neoview platform. The system name can be up to 32 characters in length, and can consist of letters, digits, and the underscore character. Data Source Specifies the name of the client-side or server-side data source.
NOTE: HPDM can connect to platforms running Neoview Release 2.3 and later. However, not all features available in the current release are available in down-rev releases. If a feature is not available, HPDM returns an error message. To create a new system definition: 1. Use either of these methods to open the Add System dialog box: • In the navigation tree pane, right-click the My Systems folder, and select Add System. • Display the Systems Tool by selecting Tools > Systems Tool from the menu bar.
Field Example Description Role Name ROLE.DBA Neoview role. Note these considerations: • If you are a platform user, leave this field blank. • If you are a database user and you leave this field blank, HPDM uses your default role. • For database users, if you specify a role and then need to log on using a different role, you must disconnect and specify the new role when you reconnect to the system.
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.
Add a System Like... To add a system by copying another system definition: 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.
2. • Right-click the system icon, and select Test System. Initiate a test from the Systems Tool: 1. Connect to the system as described in “Connect to a System” (page 25). 2. Display the Systems Tool by selecting Tools > Systems Tool from the menu bar. 3. Select the connected system that you want to test. 4. 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.
4 Navigate HPDM See the Parts of the HPDM Interface Related Topics “Use the HPDM Toolbar” (page 44) “See the HPDM Banner” (page 41) “Use the Navigation Tree Pane” (page 37) “Use the Right Pane” (page 39) “Use the My Favorites Pane” (page 40) “Use Menu Bar Commands” (page 42) Select an Area Areas are broad categories of features that you can monitor or manage using HPDM.
Area Description See for More Information Space Management Provides information about SQL-space usage on the system. “Manage Disk Space” (page 241) Security Provides tools to manage certificates, directory servers, security policies, users, and passwords. “Manage Certificates” (page 125) “Manage Directory Servers” (page 131) “Manage Security Policies” (page 117) “Manage Roles” (page 95) “Manage Users and Passwords” (page 103) Monitoring Provides alert and alarm information for the system.
Terms area Control the Display of an Area By default, HPDM displays all of the areas that the currently installed server software supports displaying. However, any user can show or hide an area by using the Options menu. To display the Options menu, click the Options button ( Tools > Options: ) on the HPDM toolbar, or select 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.
When the Database area is selected, the navigation tree pane allows you to expand a connected system, showing the database objects underneath it in hierarchical form. You can switch between different systems and manage multiple Neoview systems from one user interface. The right pane displays more detail about any object selected in the navigation tree pane. See “Use the Right Pane” (page 39). If no systems are defined, the right pane displays this message: In order to use a system you must have added it.
Option Description Edit Edits an active system. See “Edit a System” (page 32). Add System Like This Adds a system like the selected system’s current settings. See “Add a System Like...” (page 33). Remove System Removes a selected system. See “Remove a System” (page 33).
right pane navigation tree pane Use the My Favorites Pane A favorite is a shortcut to an object on the navigation tree pane. Favorites save you the trouble of having to scroll through and expand numerous parent objects. Favorites are displayed in the My Favorites pane. HPDM enables you to create favorites and organize them in folders.
Create a Folder to Store Favorites In the My Favorites pane, you can create folders at the top level or folders within folders: 1. In the My Favorites pane, right-click “My Favorites,” and select New Folder. NOTE: To create a folder within a previously configured folder, right-click the folder, and select New Folder. 2. Type a name for the folder, and click [ OK ].
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.
Menu Option Description Paste Insert the selected text at the cursor position. Select All Highlight all text. Related Topics “Use Menu Bar Commands” (page 42) Use the Tools Menu Options The Tools menu options are: Menu Option Description SQL Whiteboard Opens the SQL Whiteboard. See “Use the SQL Whiteboard” (page 211). Metric Miner Opens the Metric Miner. See “Use Metric Miner” (page 219). Neoview Command Interface Opens NCI. See “Launch the Neoview Command Interface (NCI)” (page 239).
Menu Option Description Search Opens the HPDM online help and displays the Search tab. About Displays the About dialog box. See “Get Version and Build Information” (page 47). Related Topics “Use Menu Bar Commands” (page 42) Use the HPDM Toolbar HPDM toolbar buttons quickly allow you to perform many common operations: 44 Button Function See for More Information Connect / Edit System Displays the Connect / Edit System dialog box, allowing you to make a connection to or modify a system definition.
Button Function See for More Information Metric Miner Displays the Metric Miner, allowing you “About Metric Miner” (page 219) to configure, execute, and organize reports. Neoview Command Interface Opens the Neoview Command Interface Neoview Command Interface (NCI) Guide or (NCI). “Launch NCI” (page 239) Options Displays the Options dialog box, allowing you to configure special options and views.
To open the Windows Manager, click the Windows Manager button ( ) on the HPDM toolbar, or select Windows > Windows Manager from the menu bar. The Windows Manager buttons are: Button Description [ Window(s) To Front ] Moves the selected windows to the front. [ Close Window(s) ] Closes the selected windows but leaves the main window open. [ Main Window To Front ] Displays the main window. [ OK ] Closes the Windows Manager. Clone Tabs HPDM allows you to clone some tabs in a new window.
5 Perform Basic HPDM Operations Get Version and Build Information Version and build information appears in the About HP Database Manager box. To access the About box, select the Help > About menu in HPDM . The About HP Database Manager dialog box displays the current build information about HPDM. The HPDM .exe version information and the version procedure (VPROC) information is displayed.
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: To sort on multiple columns: 1. 2. 3. 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.
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 do some or all of these tasks: • • • • • • • 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. Customize the display of information. Search for information in the grid.
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 Ctrl 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.
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). Export Data to a File [ Data to File ] (if enabled) displays a window to export the contents to a file.
Use the System Message Tab The System Message tab contains a system message control to convey information to users. The system message can be updated by a special role of user called a Publisher. The list of publishers is fixed and is comprised of: • • • SUPER.SERVICES ROLE.MGR ROLE.DBA Any user belonging to one of these roles can modify a system message. All other users can only view messages.
Clone the System Message Tab If you double-click the System Message tab, the control is cloned into a new window. When the contents of the system message are modified in any window (the main HPDM window or any cloned window), the change is immediately visible in all copies. Therefore, if the user types in one window, all of the other windows show the updated text. In addition, applying and refreshing any window affects the behavior in all other copies.
“Use Menu Bar Commands” (page 42) “Use the HPDM Toolbar” (page 44) Terms persistence file system definition Systems Tool View Event Messages View Dial Out and Database Events You can view dial out and database events with any area selected. Dial out events are system events that are dialed out to HP Support. Database events are events related to database activity, data loads, and queries. In the current release, only these users can view dial out and database events: • SUPER.SUPER • SUPER.
Message 21034 Parameter Attribute NDCS Trace Session ID: session-id Function: Enterfunction Sequence Number: sequence-number function-input-parameters or Session ID: session-id Function: Exitfunction Sequence Number: sequence-number function-exit-parameters session-id Unique session ID generated by the SQL server at the time the connection is established. function The SQL server function that is being traced.
21035 See above. Cause Effect A resource statistics informational message. None Recovery Informational message only; no corrective action is needed. Session Statistics: Connection Information Session statistics are written to the alternate EMS collector at the time the connection is made (listed in the order written in the event message): Statistic Description Session ID Unique session ID generated by the NDCS server at the time the connection is established.
Statistic Description TotalInsertStmtsExecuted Total number of SQL INSERT statements sent by the HP ODBC driver to the NDCS SQL server; does not include internally generated SQL statements. TotalDeleteStmtsExecuted Total number of SQL DELETE statements sent by the HP ODBC driver to the NDCS SQL server; does not include internally generated SQL statements.
Statistic Description ODBCElapsedTime Total NDCS SQL server real time, in microseconds, from the time the execute started to the time the results are sent back. ODBCExecutionTime Total NDCS SQL server CPU process time, in microseconds, from the time the execute started to the time the response is sent back to the client with the results error code. NumberOfRows (ins/upd/del) Number of rows that were inserted, updated, or deleted. ErrorCode Execute error code, if any.
Statement Statistics: SQLPrepare SQLPrepare 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:SQLPrepare (Statistics option that was selected.
6 Display 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.
• • DDL tab Privileges tab 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.
• • • Name: Name of the materialized view group. Each materialized view group is hyperlinked and detailed information about the materialized view group is displayed. Creation Time: Time and date when the materialized view group 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 group was last redefined. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
1. 2. Select a Schema in the navigation tree. Click the DDL tab in the right pane. The DDL tab displays DDL output from the SHOWDDL command in the right pane. You can highlight and copy contents, but you cannot edit the contents. For more information about the format of the SHOWDDL command, see the Neoview SQL Reference Manual. For more information about displaying DDL, see “Display Schema DDL and Their Properties” (page 91). Privileges Tab To display the privilege information for the schema: 1. 2.
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.
1. 2. Select a Schema and table and click the table name in the right pane, or open the Tables folder and select a table name in the tree. Click the Columns tab in the right pane. In the right pane, these attributes are displayed: • 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.
Foreign Keys Tab To display the foreign keys information on the table: 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.
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.
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 Attributes tab in the right pane. In the right pane, these attributes are displayed: • Name: Name of the index. • Unique: Specifies if the index is unique, the value is “Yes” or “No.” • 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.
The detailed summary is a snapshot of the indexes (tables indexes and materialized view indexes) in the schema at the timestamp shown at the top of the table display. If you select [ Refresh ] the summary is refreshed. A row is highlighted in red if the partition is equal to or greater than 80%. 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.
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 Columns tab in the right pane. The column information is displayed in each column. In the right pane, these usages are displayed: • Column Name: Name of the column (string). • Source Object: The name of the source object. If it is a computed object, this is blank. The name is hyperlinked to show that clicking on the source object name navigates you to the location of the object.
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 Privileges tab in the right pane. The Privileges tab displays a table showing the access privileges. • • • • • Grantee: The name of a role whose privilege is being described. Grantor: The name of the role that granted the privileges and the special SQL user names “PUBLIC” and “SYSTEM.” With Grant: Specifies an ‘X’ to indicate if the role has grant privileges.
In the right pane, these tabs appear: • • • • • Attributes tab Partitions tab Usage tab 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.
— Recompute Derives the materialized view from scratch. This is used on the initial refresh of the materialized view and also to re-derive the materialized view if it is in an inconsistent state (for example, if the previous refresh was aborted abnormally). — On Request Updates the materialized view at a time that you schedule. This allows for fast querying and a high update rate, but queries may read data that is not up-to-date with underlying tables.
• • Max Size: The maximum size in bytes of the partition. Current EOF: The current data size of the partition in bytes. Usage Tab To display materialized view usage information: 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 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 role.
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. Open the Indexes folder and select a materialized view index in the tree. Click the Columns tab in the right pane. In the right pane these attributes are displayed: • Column Name: Name of the column (string).
• • • • • Name: Name of the materialized view index. Unique: Specifies if the materialized view index is unique, the value is “Yes” or “No.” Populated: Specifies if the materialized view index has been populated, the value is “Yes” or “No.” Creation Time: Time and date when the materialized view index 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 index was last redefined.
The detailed summary is a snapshot of the materialized view in the schema at the timestamp shown at the top of the table display. If you select [ Refresh ] the summary is refreshed. A row is highlighted in red if the partition is equal to or greater than 80%. Display Materialized View Groups and Their Properties When you create a materialized view, a materialized view group is created automatically. It has the same name as the table that the materialized view references.
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. • Creation Time: Time and date when the materialized view was created.
In the right pane, these tabs appear: • • • • Attributes tab Parameters tab Usage 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 procedure 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.
• • Creation Time: Time and date when the procedure was created. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). Redefinition Time: Time and date when the procedure was last redefined. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). Parameters Tab To display the procedure parameter information: 1. 2. 3. Select a Schema in the navigation tree.
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 Privileges tab in the right pane. The Privileges tab displays a table showing the access privileges. • • • • • Grantee: The name of a role whose privilege is being described. Grantor: The name of the role that granted the privileges and the special SQL user names “PUBLIC” and “SYSTEM.
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. Click the Attributes tab in the right pane. In the right pane, these attributes are displayed: • Name: Name of the synonym.
Usage Tab To display the synonym usage information: 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, 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. • Metadata UID: Unique ID of the trigger (a long value).
• • Creation Time: Time and date when the trigger was created. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). Redefinition Time: Time and date when the trigger was last redefined. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time). 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, and then open the Triggers folder and select a trigger in the tree.
• • Synonym Trigger DDL Tab The DDL tab displays DDL output from the Show DDL command in the right pane. You can highlight and copy contents, but you cannot edit the contents. 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.
• • 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.
7 Manage Roles About Roles A role is a vehicle for assigning data-access privileges to user IDs. On the Neoview platform, data-access privileges are not granted to individual users. Users are granted a role, and roles are granted privileges on database objects. In this way, all the users who are granted a role are granted the privileges associated with the role. The Neoview platform can have a maximum of 255 roles. Many users can be assigned to the same Neoview role.
• • [ Data to Spreadsheet ] [ Data to File ] Related Topics “Display the Users Who Belong to a Role” (page 96) “Add a Role” (page 97) “Grant a Role to a User” (page 98) “Export Data” (page 53) Display the Users Who Belong to a Role Only a user belonging to the ROLE.MGR role can display the users who belong to a role. To display detailed information about a specific role or multiple roles, including all users associated with a role: 1. 2. 3. 4. 5. Log on as a user belonging to the ROLE.MGR role.
5. Click [ View SQL Privileges ]. The SQL Privileges dialog box appears, displaying the following privilege information for the selected role: • SCHEMA NAME • OBJECT NAME • OBJECT TYPE • GRANTED BY • PRIVILEGE TYPE • COLUMN NAME NOTE: The PRIVILEGE TYPE column indicates whether the privilege is a schema privilege or a column privilege. For a column privilege, the COLUMN NAME column displays Update or Reference as the privilege.
“Delete a Role” (page 98) Terms role power role Delete a Role Before deleting a role, review these considerations: • • • To delete a role, you must be a user in the ROLE.MGR role. Before deleting a role, you must revoke the role from any user who has it, and also revoke any database privileges that have been assigned to the role. To revoke a role from a user, see “Revoke a Role From a User” (page 99).
2. 3. 4. 5. 6. Select the Security area. For more information about areas, see “Select an Area” (page 35). In the navigation tree pane, select the Roles folder. The right pane shows the list of roles. Double-click the role that you want to grant to another user. Or right-click the role, and select View Role Details. HPDM displays the Role Details dialog box, including all users belonging to the role. Click [ Grant ].
1. 2. 3. 4. 5. 6. Log on as a user in the ROLE.MGR role. For more information about logging on, see “Connect to a System” (page 25). Select the Security area. For more information about areas, see “Select an Area” (page 35). In the navigation tree pane, select the Roles folder. The right pane shows the list of roles. Double-click the role that you want to revoke from one or more users. Or right-click the role, and select View Role Details.
NOTE: The [ Change Password ] button is active only if you have sufficient privileges to change the password for the selected role. 6. Fill in the fields in the dialog box, and click [ OK ]. For more information about the dialog box fields, see “Use the Change Role Password Dialog Box” (page 101).
8 Manage Users and Passwords About Users The Neoview platform has several different types of users: database user A person or application that can use a Neoview client, such as ODBC, NCI, or HDPM, to log on to the Neoview database and operate on database objects. A database user can have one or more database roles (each having a name of the form ROLE.name), which determine the objects to which the user has access and the privileges the user has in relation to those objects.
3. In the navigation tree pane, expand the folder for the logged on system, and select the Database Users folder. The right pane displays all database users, including this information about each user: • User name • Default role • Additional roles • Role that created the user • User type (locally authenticated or remotely authenticated) NOTE: You can sort the user information by clicking a column heading.
database user remotely authenticated database user Use the Add Database User Dialog Box This table describes the fields in the Add Database User dialog box: Group Box Field/Option Role Description User Name The name of a database user. This is the name that the user must enter when logging on to the Neoview platform. The name can consist of up to 128 characters, potentially including a domain name and a separator character (for example, elspeth.jordan@welt.com). Commas are not allowed.
“Use the Select User Role Dialog Box” (page 106) “Control the Display of the Add Database User Dialog Box” (page 108) Terms role locally authenticated database user Use the Select User Role Dialog Box The Select User Role dialog box helps you search for and specify a role (or multiple roles) when you add or edit users.
7. Click [ OK ]. Related Topics “About Users” (page 103) “Add a Database User” (page 104) “Use the Add Multiple Database Users Dialog Box” (page 107) Terms database user locally authenticated database user remotely authenticated database user Use the Add Multiple Database Users Dialog Box This table describes the fields in the Add Multiple Database Users dialog box: Group Box Role Field Description User Names The names of the database users that you want to add.
3. 4. 5. In the navigation tree pane, expand the folder for the logged on system, and select the Database Users folder. The right pane displays all database users. In the right pane, select a user. In the right pane, click [ Add Like ]. The Add Database User Like dialog box appears. NOTE: The Add Database User Like dialog box is similar to the Add Database User dialog box. 6. 7. Fill in the fields in the Add Database User Like dialog box.
remotely authenticated database user Change Role or Password Information for a Database User Editing a database user allows you to change the default role, add additional roles, change the password, or configure a different password expiration date for the selected user. You can edit only one user at a time. You must be a user in the role of ROLE.MGR or ROLE.SECMGR to edit a database user. Only a ROLE.SECMGR user can change the password of a user who has only the ROLE.SECMGR role.
NOTE: If the selected database user is remotely authenticated, a truncated version of the dialog box is displayed, showing only the User Name, Default Role, and Additional Roles fields. The password fields are not applicable to remotely authenticated database users. Group Box Field/Option Role Description User Name The name of the selected database user. The name cannot be edited.
Delete One or More Database Users You must be a user in the role of ROLE.MGR to delete a database user. Note that this action does not delete a remotely authenticated database user from an external directory server. To delete one or more database users: 1. 2. 3. 4. 5. 6. Log on as a user belonging to ROLE.MGR. Select the Security area. For information about how to select an area, “Select an Area” (page 35).
3. In the navigation tree pane, expand the folder for the logged on system, and select the Platform Users folder. The right pane displays all platform users, including this information about each user: • User name • Role • Role that created the user NOTE: You can sort the user information by clicking a column heading. For example, to display all the platform users by role, click the Role column heading.
1. 2. 3. 4. 5. 6. Log on as a user belonging to ROLE.SECMGR. Select the Security area. For information about how to select an area, “Select an Area” (page 35). In the navigation tree pane, expand the folder for the logged on system, and select the Platform Users folder. The right pane displays all platform users. In the right pane, select a user. In the right pane, click [ Add Like ]. The Add Platform User Like dialog box appears. Fill in the fields in the Add Platform User Like dialog box.
Group Box Field Description Expires Every n Days The interval that controls password expiration. This is the number of days, from the time the password is changed, after which it expires. Range: 0-365 Expiry Date date The default password expiration date, if no other date is specified when the user is created. To enable the date field, click the check box to the left of the date. Then specify a date. If you do not click the check box, the Expiry Date field is disabled.
5. 6. Fill in the fields of the Edit User dialog box. For more information about each field, see “Use the Add Platform User (or Edit User) Dialog Box” (page 113). Click [ OK ]. Related Topics “Use the Add Platform User (or Edit User) Dialog Box” (page 113) Terms platform user Delete One or More Platform Users Only a user belonging to the ROLE.SECMGR role can delete a platform user. You may not delete any of the predefined users: SUPERUSER, USERMGR, HPSUPPORT, SECURITYMGR or VTS.
Fill in the fields in the dialog box, as described in “Use the Change Password Dialog Box” (page 116). If your old password has expired and the security policy does not define a grace period for platform-user passwords, you can no longer change your own password, but a user in the role of ROLE.SECMGR can change your password.
9 Manage Security Policies About Security Policies Various behaviors related to user management and security depend on policies that the Security Administrator can configure.
4. In the right pane, select the desired tab for the policy you want to change. For more information about each policy, see these topics: • “Use the Certificate & Connection Tab for Security Policies” (page 119) • “Use the Password Tab for Security Policies” (page 120) • “Use the Logging Tab for Security Policies” (page 121) • “Use the Power Role Management Tab for Security Policies” (page 122) 5. Make changes as needed, then click [ Apply ] to save the changes.
This table describes the function of buttons that appear at the bottom of the policies tabs: Button Description [ Refresh ] Updates the display. [ Load Default ] Sets all fields to their factory-default settings. To enforce the new settings, you must click [ Apply ] and restart NDCS services as described in the steps preceding this table.
Option Description Allow Down-rev Drivers to Connect Specifies whether login requests are accepted from clients that do not provide password encryption. Clients earlier than Neoview Release 2.5 do not provide password encryption. CAUTION: The initial state of Allow Down-rev Drivers to Connect is deselected. Some installations will, however, choose to enable this option for a period during which workstations are being upgraded from older versions of clients to newer ones.
Policy Option Description Password Control Policy History Level Number of previous passwords retained to prevent a user from repeating a previous password (for example, a value of 10 means that a new password is not allowed to be the same as any of the user's previous 10 passwords). The range is 0 to 60.
This table shows reference information for the Logging tab for security policies: Option Description Log User Management Operations Specifies whether to log user management actions, such as adding or deleting a user or changing the attributes of a user's account. Log Change Passwords Specifies whether to log password changes. Passwords themselves are, of course, not logged.
Policy or User Type Option Description Database Users Power Database Users Are Required When selected, specifies that ROLE.SECMGR, ROLE.MGR, and ROLE.DBA users must provide an individual password and a role password. None Is Required When selected, specifies that an individual password is sufficient for any database user to log on.
10 Manage Certificates About Certificates The current release of the Neoview platform allows you to use either a self-signed certificate or a certificate signed by a Certificate Authority (CA) of your choice.
3. 4. 5. 6. 7. In the navigation tree pane, under the connected system, expand the Credentials folder, and click the Self-Signed Certificate folder. The Self-Signed Certificate tab appears in the right pane. Fill in the fields in the Self-Signed Certificate tab. For more information, see “Use the Self-Signed Certificate Tab” (page 126). Click [ Generate ]. The Save As dialog box appears. Select a folder and specify a file name to save the certificate. Click [ Save ].
NOTE: If possible, use facilities provided by the CA to specify Subject Alternate Names (SANs) for all segments, or at least for all secondary segments (for example, NEO0102 to NEO0116). This information will not be present in the original CSR but is required to enable use of the event viewer without displaying warnings. If your CA does not allow you to specify SANs, define a procedure for your users to follow if they encounter browser security messages.
“Display Security Policies” (page 117) Use the Generate CSR Tab This table shows reference information for the Generate CSR tab: Field Example Description Common Name HPQ0101 Identifies the Neoview platform on which you want to install the certificate. The name consists of the unqualified DNS name of the master segment. If the external network name is different from the internal name, use the internal name. Organization Hewlett-Packard The name of your company or business unit.
Related Topics “Use the Deploy CA Signed Certificate Tab” (page 129) “Display Security Policies” (page 117) “About the Auto Download Certificate Option” (page 129) Use the Deploy CA Signed Certificate Tab This table shows reference information for the Deploy CA Signed Certificate tab: Field Example Description System Name HPQ0101 Identifies the Neoview platform on which you want to install the certificate. This field is required. The name consists of the unqualified DNS name of the master segment.
11 Manage Directory Servers About Directory Servers You can configure the Neoview security infrastructure to communicate with external LDAP servers. The Neoview platform explicitly supports integration with openLDAP-compliant directory servers and Microsoft Active Directory. HPDM is the preferred interface for LDAP server configuration.
1. 2. 3. 4. • Log on as a user belonging to ROLE.SECMGR. For more information about logging on, see “Connect to a System” (page 25). Select the Security area. For more information about areas, see “Select an Area” (page 35). In the navigation tree pane, expand the system folder. Right-click the Directory Servers folder, and select Add Directory Server. Add the directory server from the Directory Servers display under the Security tab in the right pane: 1.
Field Range Description Host Name Maximum of 128 characters The host name or IP address of the LDAP server. This value is a text field with the following characteristics: • The field can contain a maximum of 128 characters. • The value that you specify must be a valid DNS name or IP address.
Field Range Description Common Parameters N/A Parameters that apply to all servers. To add a row in the Parameters grid, right-click and select Add Row. To delete a row, select the row. Then right-click and select Delete Row. For considerations, see “Understand Configuration Parameters” (page 134) and “Considerations for Adding Directory Servers” (page 135). For examples, see the Neoview User Management and Security Administration Guide. Parameters N/A Parameters that are server specific.
by default if no value is specified when an individual server is configured. Parameters are server-specific and can be different on different servers or in different domains. The following table shows you the parameters that can be used in Common Parameters and Parameters fields for LDAP server configuration. Note that common parameters are evaluated at runtime. NOTE: If you use NCI for LDAP server configuration, you must create a default configuration description file.
• • • LDAP directory server Global Catalog for an Active Directory server Domain Controller for an Active Directory server Consideration Adding an LDAP Directory Server Server Type Specify LDAP. The server type Specify Active Directory. is inserted into the configuration description (ConfigText) file as an additional parameter. Internally, HPDM uses the server type to differentiate the types of directory servers.
Adding an LDAP Directory Server Adding a Global Catalog for an Adding a Domain Controller for Active Directory Server an Active Directory Server Inherited and Supported Common Parameters • • • • • • • • • • • • Configuration Parameters The only values that you can enter as configuration parameters specific to this LDAP server are Comment, DirectoryBase, and UniqueIdentifier. The drop-down list in the Parameters box lets you select only one of these three options.
Field Example Value Encryption Option TLS Certificate c:\ldap\hpca2ss Related Topics “Add a Directory Server” (page 131) “Use the Add Directory Server Dialog Box” (page 132) Example: Active Directory Server This table shows values specified in the Add Directory Server dialog box to create a Global Catalog server for an active directory.
Field First Domain Controller Second Domain Controller Domain Name DOMAINA DOMAINB Host Name dc01.domaina.cup.hp.com dc02.domainb.cup.hp.
Copy a Configured Directory Server To use the attributes of a currently configured directory server to create a new directory server configuration: 1. 2. 3. 4. Display the directory server list as described in “Display the Configured Directory Servers” (page 131). Select the directory server whose configuration you want to copy. Click [ Add Like ]. The Add Directory Server dialog box appears, populated with the attributes for the selected directory server. Fill in the fields.
12 Manage Data Sources Display Data Sources Any user can display all data sources. To display all data sources: 1. 2. Under the navigation tree pane, click the Connectivity area. (For more information, see “Select an Area” (page 35).) In the navigation tree pane, find the system that contains the data sources that you want to display. Expand the system and click the Data Sources folder: The right pane displays the Data Sources tab, showing a list of all data sources.
3. In the navigation tree pane, click a named data source. Detailed information about the data source appears in the right pane. This table describes the fields in the Data Source Status tab in the right pane: Field Description Data Source Name User-created name for the data source. Service Name NDCS service to which the process belongs. State Current state of the data source. Tracing Current state of server tracing. This field is visible only to roles that have OPERATOR privileges.
NOTE: Some tabs provide tooltips that describe the use of an option or the range of values supported for a field. For example: 5. 6. 7. When you are finished, click [ Create ]. If the new data source is not immediately visible, click the Data Sources folder in the navigation tree pane, and select Refresh. To start the data source, see “Start a Data Source” (page 151).
Group Box Option or Check Box Description Connection Idle Timeout The number of minutes that a client-server connection remains idle before the NDCS server terminates the connection. The system default is 10 minutes. Enter an integer from 1 to 2,147,483,647. This value does not apply to servers that are included in the available count. Session Statistics Connection Information Select this option to collect statistics about the connection and the session.
Group Box Option or Check Box Description Statement Statistics SQL Statement Resource Management Statistics about individual SQL statements. For more information, see “Statement Statistics: SQL Statement” (page 59).
Understand Processing-Node Numbering This table shows the processing-node numbers for each segment in a Neoview platform. For an 8-segment Neoview platform, processing nodes are numbered sequentially from 0 to 127. For example, segment 1 contains processing nodes 0 through 15. Segment 2 contains processing nodes 16 through 31, and so on.
NOTE: You can enter only one resource management policy for each attribute name. Clicking [ Add ] or [ Modify ] displays a dialog box with these fields: Field Description Attribute The name of a resource management policy attribute that limits the execution of user queries from a client application, based on cost. Action The action to be taken by NDCS when the limit is exceeded. In all cases, an event message is sent to the event log. Valid values are: LOG — The user query continues execution.
SET variables are stored as part of the configuration data for the data source. They are retrieved by the association server when it reads the startup values for the data source and then set by the data source server when a connection is established. Button Functions on the SETs Tab Button Function [ Add ] Displays the Add SET dialog box. [ Modify ] Displays the Edit SET dialog box. [ Remove ] Removes the selected SET. Note that some SET commands require you to specify a value in single quotes.
3. 4. 5. 6. Click the Control Query Defaults tab. Click [ Add ] or [ Modify ]. In the CQD Name field, enter a new name or change the existing name. In the Value field, enter a new CQD value, or change the current value. NOTE: The names and values entered manually cannot be checked for validity at the time of entry. They are validated at execution time only.
Priority Option of Controlled Tables Tab Possible values are 1 through 9. Specify a higher priority for short-duration OLTP-type requests running with concurrent long-duration query requests. NOTE: Using the highest possible value (9) can interfere with Neoview SQL system-level activity. Similarity Check Option of Controlled Tables Tab Value Description The value used is the system default setting that exists at execution time.
4. Modify the information in these tabs, as necessary: • “Use the General Properties Tab” (page 143). NOTE: You must change the data source name. If you do not change the name, HPDM returns an error message indicating that the data source already exists.
2. 3. 4. 5. 6. 7. In the navigation tree pane, find the system that contains the data source(s) that you want to stop. Expand the system to display the list of data sources below it, and click a data source to select it. In the right pane, click the Data Source Status tab. Select all of the services in which the data source is configured. Normally, a data source is configured either on MXOAS or on MXAS2. See “Learn About the Association Servers” (page 156). Click [ Stop ].
NOTE: You cannot delete the two default data sources (TDM_Default_DataSource and Admin_Load_DataSource). A data source must be stopped before you can delete it. To delete a data source: 1. 2. 3. Stop the data source by performing the steps in “Stop a Data Source” (page 151). In the navigation tree pane, right-click the data source, and select Delete. A dialog box asks you to confirm the data source deletion. Click [ Yes ].
13 Manage Connectivity Display NDCS Servers Any user can display NDCS servers. To display all NDCS servers for a system: 1. 2. 3. Under the navigation tree pane, click the Connectivity area. (For more information, see “Select an Area” (page 35).) In the navigation tree pane, under the desired system, click NDCS Services. In the right pane, click the NDCS Server Status tab. The list of NDCS servers and data source names appears.
Field Description Process Name Operating system process name of the server. This field is visible only to roles that have OPERATOR privileges. Service Name NDCS service to which the process belongs. Data Source Name Operating system process name of the server. State Current state of the server PID Client Process ID of the client connected to the server (or blank if there is no connection).
Stop an NDCS Server Requirement: Only roles that have OPERATOR privileges can perform management tasks. To stop an NDCS server: 1. 2. 3. 4. 5. 6. 7. Under the navigation tree pane, click the Connectivity area. (For more information, see “Select an Area” (page 35).) In the navigation tree pane, find the system that contains the NDCS server(s) that you want to stop. Expand the system, and click NDCS Services. In the right pane, click the NDCS Server Status tab to display the list of NDCS servers.
4. In the right pane, click the NDCS Services tab to display detailed information about the association and configuration servers: This table describes the fields in the NDCS Services tab: Field Description Service Name The NDCS service to which the process belongs. Service Type Association server or configuration server. Process Name Internal operating system process name of the system in which the NDCS service is running. This field is visible only to roles that have OPERATOR privileges.
• • • Association server Configuration server Data sources configured with the automatic startup option If the NDCS service state does not change to the Available state, contact HP support. Related Topics “Learn About the Association Servers” (page 156) Terms operator privilege Association server Configuration server Data sources NDCS service Stop an NDCS Service Requirement: Only roles that have OPERATOR privileges can perform management tasks.
Start and Stop Server Traces Requirement: Only roles that have OPERATOR privileges can perform management tasks. To start tracing for a data source: 1. 2. 3. 4. 5. 6. Under the navigation tree pane, click the Connectivity area. In the navigation tree pane, find the system that contains the data source(s) that you want to trace. Expand the system, and click NDCS Services. In the right pane, click the Data Source Status tab to display the list of services.
14 Manage NDCS Privileges Display NDCS Privileges NDCS privileges define the type of access that the members of a role have to data source configurations and other connectivity information on the Neoview platform. Only a member of a role having OPERATOR privileges can display NDCS privileges. Initially, only users belonging to the following roles have OPERATOR privileges: • • • • SUPER.SUPER SUPER.SERVICES ROLE.DBA ROLE.
1. 2. 3. 4. 5. 6. Under My Systems, select the system having the role for which you want to grant privileges. In HPDM, select the Connectivity area. For more information, see “Select an Area” (page 35). In the right pane, click the NDCS Privileges tab. Click [ Grant ]. The Grant Operator Privilege dialog box appears. In the Grantee Role Name field, specify the user role. Click [ Grant ].
15 Manage Procedures Display Procedures See “Display Procedures and Their Properties” (page 84). Upload a JAR File This procedure uploads an SPJ JAR file (or multiple JAR files) from a client workstation to the Neoview platform. When you upload a JAR file to the Neoview platform, the Procedure Code File Tool copies the JAR file(s) to one of two folders that you select: • • A folder corresponding to your user role on the Neoview platform. For example, if your role is ROLE.
Download a JAR File This procedure downloads one or more SPJ JAR files from the Neoview platform to a client workstation. When you download a JAR file to a client workstation, the original JAR file is retained on the Neoview platform. Use this procedure to download one or more JAR files: 1. 2. 3. In HPDM, select the Database area. For more information, see “Select an Area” (page 35). In the navigation tree pane, right-click a schema name, and select Procedure Code File Tool.
NOTE: You can rename only one JAR file at a time. TIP: To select a row, click the File Size value rather than the File Name. If you click the File Name, HPDM changes the display to provide detailed information about the selected JAR file. 5. 6. 7. Click Rename. A Confirm dialog box asks you to confirm the Rename operation. Click Yes to continue. Otherwise, click No to end the operation.
• • You must be the owner of the schema or have SUPER.SUPER or SUPER.SERVICES privileges, and have read access to the .jar file that contains the SPJ Java method. The catalog and schema of the SPJ must already exist. To create a procedure: 1. 2. 3. 4. 5. In HPDM, select the Database area. For more information, see “Select an Area” (page 35). Expand the navigation tree pane so that you can see the name of the schema in which you want to create the procedure and the Procedures folder under the schema.
is 1 to 255 inclusive. The actual number of result sets returned by the SPJ method can be less than or equal to this number. NOTE: The Number of dynamic result sets control is enabled only if the method signature contains a java.sql.ResultSet[] object. 8. If your SPJ method performs any SQL operations, select the Accesses Database option. NOTE: If you do not select the Accesses Database option and your SPJ method performs SQL operations, Neoview SQL returns an error when trying to execute the procedure.
Group Box Control or Field Attributes Number of dynamic Controls the maximum number of result sets the procedure can return. This result sets control is enabled only if the method signature contains a java.sql.ResultSet[] object. If the method contains a result set object, the valid range is 1 to 255. This value is automatically set to zero if the selected Java method does not have a java.sql.ResultSet[] object. Accesses Database Action If selected, the procedure performs SQL operations.
Parameter Type or Class Type primitive “short” “short[]” “int” “int[]” “long” “long[]” “float” “float[]” “double” “double[]” result sets “java.sql.ResultSet[]” For more information, see the Neoview Guide to Stored Procedures in Java. Drop a Procedure To drop a procedure, you must own the procedure, have SUPER.SUPER privileges, or have the necessary DDL privileges to drop the procedure. The schema owner can grant such privileges to other users or roles.
16 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 176) “Understand the Performance Metrics” (page 172) “Understand the System Status Icons” (page 174) 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 173) 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 173) “Configure System Monitor Options” (page 176) 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: 174 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 183). Related Topics “Understand the System Status Icons” (page 174) “Get Information About Alerts” (page 183) 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. Under the My Systems folder, select the system that you want to monitor.
This table describes the system monitor options and settings: Option or Setting Description Port This option shows the Port Number for connecting to the Neoview platform. The default number is 4746, which should satisfy most installations. If the system monitor fails to return data and you suspect that a different port was assigned, contact your HP support representative. The Fixed Incoming option is provided for troubleshooting at sites where the client workstation is behind a firewall.
Option or Setting Description Additional Color Options Options that control the bar color for the mouse-over, threshold-exceeded, and CPU-down conditions. See “Change a Color Option” (page 179). Aggregation Options Options that control the way data collected (aggregated) for each bar in the bar graph (Bar Graph tab): • No Aggregation displays one bar per CPU (16 bars per segment). For example, the client shows 64 bars (16 CPUs per segment) for a four-segment platform.
“Configure System Monitor Options” (page 176) Terms segment Change a Color Option Color options appear as bar/line-color buttons in the system monitor options pane. To change a color option: 1. 2. 3. 4. 5. Display the system monitor options pane, as described in “Configure System Monitor Options” (page 176). Click the bar/line-color button for the metric or background whose color you want to change. The color palette dialog box appears. Select a color from the color palette. Click [ OK ].
17 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 182). 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.
are not found, HPDM checks to see if the user has update privileges on the ALARM_STATUS column. 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.
Unlike the Connectivity, Disks, and Transactions icons, the Alerts icon requires an ODBC connection to fetch the alerts status. This table describes how to interpret the alert state based on the color of the Alerts icon: Alerts Icon Color Description Gray A gray icon signals one of these conditions: • The system is not connected. • The logged on user does not have the required privileges to view alerts. • The repository view for alerts does not exist.
Field Description ALARM_NOTES Notes about the alarm that can only be added manually by an HPDM operator. ALARM_PROBABLE_CAUSE The likely cause of the alarm. ALARM_COUNTER The number of internal events generated for the alarm. IR_ID The segment-local identification number associated with the incident report (IR). The ID is incremented for every new incident report. IR_SEVERITY CRITICAL, FATAL, INDETERMINATE, INFORMATION, MAJOR, MINOR, OTHER, or WARNING.
Field Description IR_LAST_UPDATE_LCT_TS* The timestamp in local civil time (LCT) when the incident report was last updated. IR_NOTES* Always blank (for future use). *This field is not displayed by default. Use the Show/Hide Grid Columns command to control the display of this field. See “Customize the Data Grid” (page 52).
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 System Offender 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 186). 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.
2. • Click the [ Apply ] button at the bottom of the Alerts tab: Use the steps for updating multiple alerts, but select only one row to update. Related Topics “Update Multiple Alerts” (page 190) “Make Notes About an Alert” (page 190) Update Multiple Alerts You can update multiple alerts in the same operation. NOTE: You must have the necessary privileges before you can update alerts. See “Understand Privileges for Viewing and Updating Alerts” (page 182). To multiple update alert(s): 1. 2. 3. 4. 5.
4. Click the [ Apply ] button at the bottom of the Alerts tab to send the changes to the server. Related Topics “Update an Alert” (page 189) About the Console Tab When either the Alerts tab or the System Offender tab is selected in the right pane, the Console tab is visible underneath it (unless the Console tab is hidden). The Console tab shows the queries that are used to gather data-grid information from the server. You can select and copy this information directly from the tab.
18 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 194) “Find Offending Processes and Queries” (page 194) 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 any CPU bar or header for these performance metrics . . . For example –CPU Busy –Disk I/O –Cache Hits –Dispatch –Queue Length or... –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.
that spawned another process (a parent process). These commands are available only to administrator users. To obtain Pstate information: 1. 2. Display the System Offender tab, as described in “Display the System Offender Tab” (page 193). Right-click a process in the data grid, and select Pstate or Parent Pstate.
Field or Option Description Parent Process The process that spawned the children processes described in the Detail tab. Filter CPU Value Controls which processes are displayed in the Detail tab based on CPU utilization. Set this value to the lowest CPU utilization that you want the dialog box to display. For example, if you set the CPU Value to 0, the tabs display all children processes in all CPUs.
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 typically 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.
Group Box Warn Level Field Description Total Query Time The total time that the query ran or is running (that is, the elapsed time), plus any time that the query spent in the waiting, holding, or suspended state. The display format is hhh:mm:ss for hours, minutes, and seconds. Warn Level Warning level that is set for the query: NOWARN (green) LOW (yellow) MEDIUM (orange) HIGH (red) Click View for more details. See “Understand the Warning Information” (page 203).
Group Box Other Field Description CPU Estimated total amount of processor (CPU) time I/O Estimated total amount of I/O time Message Estimated total amount of messaging time Idle Estimated idle time Total Time Estimated total time Cardinality Estimated number of rows returned by the query Total Memory Estimated total amount of memory Res.
Runtime Statistics Group Box Field Description Info Statement Type Type of SQL statement Statement ID Statement identifier of the query, which is part of the query ID Exec State Execution state of the query SQL Code Top-level error code returned by the query, indicating whether the query completed successfully or with warnings or errors. A positive number indicates a warning. A negative number indicates an error.
Group Box Usage Memory (KB) Derived Time 206 Field Description First Row Returned Timestamp when the first row was returned from the root operator of the master executor process. A value of -1 means that the first row has not yet been returned.
Group Box Other Field Description Last Interval Processor Total amount of processor (CPU) time used by the query in the previous refresh interval. The display format is hh:mm:ss.sss for hours, minutes, and seconds.
Alter System Offender Parameters To display the Alter Offender Parameters dialog box and alter the parameters: 1. Display the System Offender tab, as described in “Display the System Offender Tab” (page 193). 2. In the toolbar, click the Alter Offender Parameters button ( ). The Alter Offender Parameters dialog box is displayed. Configure the server and/or client parameters as described in “Use the Alter Offender Parameters Dialog Box” (page 208). Click OK. 3. 4.
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. If, for any reason, one or more updates fail, the refresh timer remains paused so that you can resolve the issue without losing configured information. You control the refresh interval and other refresh attributes by using the toolbar buttons at the top of the System Offender tab: Click this button . . .
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 193). Click the [ Pause Timer ] button.
19 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 ($$).
Related Topics “Learn About the Statement List Pane” (page 212) “Learn About the Statement Pane” (page 213) “Learn About the Statement Details Pane” (page 215) 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.
The buttons across the top of the Statement List pane allow you to select individual statements or select all statements to be executed: Button Function [ All ] Selects all statements in the Statement List. [ None ] Deselects all statements in the Statement List. [ Discard ] Removes selected statements (marked checked boxes) or the statement results, or both, depending on the option you select in the dialog box. NOTE: You cannot discard a statement or results while the statement is executing.
page mode Understand Parameter Prompts SQL statements can be parameterized by embedding parameter names surrounded by $$ (double dollar signs). When the statement is executed, the SQL Whiteboard prompts you for values for all parameters in that statement and easily allows you to reuse recent values for those parameters. Understand Page Mode When you execute a statement in the SQL Whiteboard, HPDM caches the results in virtual memory for display purposes.
• • • • Regardless of whether the number of rows in the result set exceeds the Rows/Page threshold, if the available virtual memory falls below the internal threshold, the statement execution goes into page mode and displays the results that have been fetched so far. In this situation, the grid might display fewer rows than the Rows/Page threshold. This situation continues until garbage collection kicks in and frees up the memory occupied by the pages that have been disposed.
are shown only for statements that are loaded from the Statement pane. The values in the Statement Details pane are: The Execution Results tab displays the completion of SELECT statements: Field or Button Function Last Evaluated Shows when the statement was last evaluated. Time Elapsed Specifies the elapsed time in seconds. Status Displays the executed statement status. The Execution Results indicate the progress of the statement execution and the number of rows fetched so far.
a specified text file. To import or export SQL statements, use these commands from the File menu: Command Description Load SQL Statement Reads the text of an SQL statement from an ASCII file into the Statement text box. Save SQL Statement Saves the current SQL statement text from the Statement text box to an ASCII file. Only the statement text is saved, not the statement results. To save the results, use the Data to Clipboard or Data To Spreadsheet options.
20 Use Metric Miner About Metric Miner Metric Miner is an HPDM utility that allows you to: • Execute a SQL statement or query and view the results within HPDM. • Save the statement or query as a report that includes descriptive information, statement parameters, and version information. • Run multiple reports at the same time (subject to workstation memory limitations). Each report is self-contained and displayed in its own tab. • Reuse, share, and link reports.
Related Topics “About Metric Miner” (page 219) “About the SQL Whiteboard” (page 211) Terms Metric Miner Launch Metric Miner Any user can launch Metric Miner. To launch Metric Miner: 1. 2. Start HPDM and log on using any user ID. For more information, see “Connect to a System” (page 25). Use one of these methods to display the Metric Miner window: • • Click the Metric Miner button ( ) on the HPDM toolbar. For more information about the HPDM toolbar, see “Use the HPDM Toolbar” (page 44).
The user input fields, including the SQL Input Area and the Report Results Area occupy the middle panes of the Metric Miner window: The Status, Description, and Row Details tabs occupy the right pane in the Metric Miner window: See the Parts of Metric Miner 221
Related Topics “Use the Metric Miner Toolbar” (page 222) “Learn About the SQL Whiteboard Panes” (page 211) Use the Metric Miner Toolbar Metric Miner toolbar buttons provide shortcuts to common operations: 222 Use Metric Miner
Button Function See for More Information Stop data provider Stop the refresh (cancel the query). “Cancel a Query From Metric Miner” (page 227) Refresh data Re-execute the SQL statement “Control the Refresh of Metric Miner Information” using any input parameters (page 228) provided during the last statement execution. Set refresh time Configure a refresh interval. Run the SQL statement Executes the statement in the SQL “Run a SQL Statement Using Metric Miner” (page 225) input area.
Create Report Folders Create a Report Folder Before you start using Metric Miner, create a report folder. A report folder is any folder that contains reports. Reports are not visible to the Report Explorer until you create a report folder. The report folder can be located on your local workstation, or it can be a shared folder on a server to which you have access. You can create as many report folders as you want. However, Metric Miner allows you to create logical folders within each report folder.
Run Statements Run a SQL Statement Using Metric Miner Using Metric Miner, you can run SQL statements in much the same way that you can run them by using the SQL Whiteboard. Saving the statement information as a report is optional. To run a SQL statement using Metric Miner: 1. 2. Launch Metric Miner, as described in “Launch Metric Miner” (page 220). In the SQL input area of the Ad-Hoc Report tab, type the SQL statement.
1. 2. At the top of the dialog box, select a schema from the Schema drop-down menu. The SQL Designer populates the Tables/Views field based on the schema that you select. At the bottom of the dialog box, double-click any of the following individual elements in addition to using the keyboard to add text in the Query box in the middle of the dialog box: • SQL Statements • Tables/Views • Columns • Functions NOTE: The SQL Statements and Functions menus are drop-down menus.
User_name as User_Name, query_start_datetime as Start_time, query_end_datetime as end_time, Datasource as datasource, start_priority as Pri, rows_accessed, rows_retrieved, num_rows_iud as Row_IUD, error_code, statement_state, process_name as Mstr_Exec, sequence_size as SQL_TXT_Size, sql_text as First_3k_text FROM ODBC_QUERY_STATS_V2 WHERE (QUERY_START_DATETIME) >= TIMESTAMP '$$__FROM_TIME$$' AND (QUERY_START_DATETIME) < TIMESTAMP '$$__TO_TIME$$' and STATEMENT_STATE <> 'MULTIROW' and statement_state = 'COMPL
“Use the Metric Miner Toolbar” (page 222) “Resolve Out-of-Memory Errors” (page 228) Resolve Out-of-Memory Errors Metric Miner allows you to submit queries to the Neoview platform that can return large amounts of data. Metric Miner also allows you to run multiple SQL statements at the same time. These activities can potentially consume most or all of the memory on a workstation. When memory is completely consumed, it is possible to receive an out-of-memory exception error.
To set the refresh interval, click the Set Refresh Time button ( ), and select a refresh interval. NOTE: Once you select a refresh interval, the statement is always configured to refresh. You cannot undo the refresh setting, but you can pause the refresh. Also, when a refresh interval is selected, the Metric Miner toolbar shows an extra button. This button serves as the Pause or Resume Timer button, depending on the state of the refresh. To stop the refresh, click the Pause button ( ).
Create and Manage Reports Create a Report Reports that you create and store on a workstation: • Are available to all users of the same workstation. • Can be run against any Neoview platform to which the workstation can connect. To create a report: 1. 2. If a report folder isn't present in the Report Explorer pane, create one. See “Create a Report Folder” (page 224). Run the SQL statement that you want to save as a report. See “Run a SQL Statement Using Metric Miner” (page 225).
Use the Report Configuration Dialog Box This table describes the fields in the Report Configuration dialog box: Tab Group General Report Attributes Configuration Field Description Name Specify the name of the report that you want to appear in the Report Explorer and in the tab title. You can also use this field to create logical folders. A logical folder is a subdivision of a report folder. To save the report to a logical folder within the report folder, append the @ character to the name.
Related Topics “Create a Report” (page 230) “Create a Report Folder” (page 224) Display and Run a Saved Report When you display a saved report, Metric Miner displays the statement and the report description, which can include the statement name, author, version and column information. The report results are not displayed because Metric Miner does not save the results. It would require too much memory to save the results. However, results can be exported, if necessary.
Close a Report To close the currently active report, click the button to close a report ( To close all report tabs, click the button to close all reports ( NOTE: tab. The button to close all reports ( ). ). ) is located above the Report Explorer Related Topics “See the Parts of Metric Miner” (page 220) “Display and Run a Saved Report” (page 232) Delete a Report When you delete a report, Metric Miner deletes the .widget file contained in the Reports folder.
“Use the Metric Miner Toolbar” (page 222) “Create a Report” (page 230) Share a Report With Another User All reports residing on a workstation are available to all users of the same workstation. To share a report with a user on a different workstation, make a copy of the .widget file for the report, and send it to the other user. The .widget file can be found in the report folder, the location of which is shown in the Report Explorer. The user receiving the .
Link and Drill Down Link Reports in Metric Miner Suppose you have a series of reports, and some of them require input parameters. And suppose various column values from one report can serve as the input parameters for another report. Using Metric Miner, you can link the reports. Linking makes it possible to double-click a row (or right-click a row and select Drill Down) in one report and pass one or more values from selected columns in that row to another report.
Use the Select Report Dialog Box This table describes the fields in the Select Report dialog box: Field Description Linked Reports Lists the reports that are linked to the calling report. Link Reason (Describes the Text entered by the report author to document the mapped columns between reports. association between the reports) Passed Values Shows the parameter values that will be passed to the called report selected in the Linked Reports list.
1. 2. 3. 4. Display (open the tab for) the calling report. This is the report whose result data will be passed to the called report. For more information about displaying a report, see “Display and Run a Saved Report” (page 232). Refresh or execute the report so that results are loaded into the Report Results pane. For more information, see “Run a SQL Statement Using Metric Miner” (page 225). In the Report Results pane, double-click a result row, or right-click anywhere in the row and select Drill Down.
21 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 located on the customer documentation Web site.
Set Auto Logon Options To set the NCI auto logon features, click the Options button ( ) on the HPDM toolbar, or select Tools > Options from the HPDM menu. Select “Neoview Command Interface” in the left pane of the Options window. The Options window displays a dialog box where auto logon features can be set for NCI. Auto logon can be disabled or enabled. The NCI prompt can be set to prompt specific options.
22 Manage Disk Space About Space Management Space Management is a new area within HPDM that enables the monitoring and display of SQL space-related data for the Neoview platform. The displayed space data includes six panes of detailed SQL-space usage statistics. Space Management allows you to display SQL space by user, by schema, by table, and by partition. It also helps you identify and react to fast-growing tables by looking at historical trends.
4. In the right pane, click the Monitoring tab. After successful logon to a Neoview system: • • • • • • Space references are verified. Last inventory information is retrieved. The Over Threshold Summary is fetched. The System Overall and System Detail panes are automatically populated. The SQL Objects and SQL Objects Detail panes are populated when you double-click an area of the pie chart or select a row in the System Detail pane.
See the Parts of Space Management Space Management shows SQL space usage statistics for a Neoview system, including SQL objects, partition distribution across disks, and table growth. You can monitor and display space usage as a pie chart, bar graph, data grid, timeline, or a combination. Space Management presents information in a graphic and row format. Space Management reports on a Neoview system and plots multiple metrics on different graphs.
Manage Disk Space
Related Topics “About the Monitoring Tab” (page 246) Understand Space Usage Statistics Space Management shows six panes of detailed SQL space usage statistics: Pane Description System Overall Pie chart view of the amount of space used on the Neoview by Category, Schema, Table, or by User. System Detail Detailed grid view of the total SQL space size per schema. SQL Objects Bar graph view of the SQL objects within the schema (including base tables, materialized views, and indexes).
Pane Description SQL Objects Detail Detailed grid view of the SQL objects within the schema. Partition Distribution Across Disks Bar graph view of the partition distribution across all disks in the system in megabytes (MB). Table Growth Timeline view of the object sizes by table and the top fastest growing tables in the system. Related Topics “About the Monitoring Tab” (page 246) About the Monitoring Tab The Monitoring tab provides an SQL space snapshot of a selected Neoview system.
To display the Over Threshold Summary, display the Monitoring tab, and click the double arrows at the top of the Logical Space tab: The Over Threshold Summary bar allows you to configure these fields: Field or Option Description %Full You can enter a percentage value and only those disks, tables, and partitions exceeding the value are displayed. Max Rows for Each Type Shows the maximum number of rows for disks, table, and partitions. The default value is 10 (displays a maximum of 30 rows).
Use [ Refresh ] to refresh the Over Threshold Summary data grid. To change the sort order of a displayed column: • Click the title of the column that you want to sort in ascending or descending order. See “Sort and Move Data Columns” (page 47). • For more information about customizing the data grid, see “Customize the Data Grid” (page 52).
This figure shows a snapshot of the System Overall pane and the free space available: In the System Overall pane, you can: 1. 2. 3. 4. Select a value for Type in the drop-down box. Select a value for Count in the drop-down box. Optionally, select the check boxes Others or Free. Click [ Refresh ] to refresh the pane by re-fetching the space information for the specified type.
From the Space Management area: 1. Select a system you wish to view details about. 2. Click the Monitoring tab. 3. View the System Detail pane. Click the box icon on the right of the heading to enlarge the view of the System Detail pane. When the display is focused on one area, you can no longer view information from the other areas. To return to the full system view, click on the box icon again. This figure shows a snapshot of the System Detail pane: To activate the System Detail pane, you can either: 1.
To change the sort order of a displayed column: • Click the title of the column that you want to sort in ascending or descending order. See “Sort and Move Data Columns” (page 47). • For more information on customizing the data grid, see “Customize the Data Grid” (page 52). In the System Detail pane, these fields are displayed: Field or Option Description Date Time The last time space data was captured. Catalog Displays the catalog name of the schema. Schema Displays the SQL schema name.
Button Function [ Data to Spreadsheet ] Opens the Excel application and displays the data. See “Export Data” (page 53). [ Data to File ] Exports the data to a file in CSV format. See “Export Data” (page 53). View SQL Objects The SQL Objects pane is a bar graph view of the SQL objects in the schema. The SQL objects are viewed largest to smallest. Objects limited in size are not represented in the bar graph. The title of the bar graph represents the name of the schema. From the Space Management area: 1.
NOTE: The name and size of the object appears whenever you place your cursor on a bar in the graph. In the SQL Objects pane, these fields can be selected in the drop-down box: Field or Option Description Type Specifies type as: base table (BT), materialized view (MV), index (IX), or ALL. The ALL option displays all objects. Count Specifies the number of objects to be displayed. View the SQL Objects Detail The SQL Objects Detail pane is a data grid of the SQL objects within a schema.
This figure shows a view of the SQL Objects Detail pane: If you click the Filter Settings bar, you can: • Select the columns to be displayed in the data grid. • Enter the maximum number of rows to be viewed, default is 100000. NOTE: In the filter options, the object name is required.
To change the sort order of a displayed column: • Click the title of the column that you want to sort in ascending or descending order. See “Sort and Move Data Columns” (page 47). • For more information on customizing the data grid, see “Customize the Data Grid” (page 52). In the SQL Objects Detail pane, these fields are displayed: Field or Option Description Date Time The last time space data was captured. Catalog Specifies the SQL catalog name. Schema Displays the SQL schema name.
Field or Option Description Stats Row Count: Number of rows from the histogram (accuracy depends on when statistics was last updated). %Full Indicates the full size of the object. The buttons across the bottom of the SQL Objects Detail pane allow you to export data. Button Function [ Data to Clipboard ] Copies the table data to the Windows clipboard. See “Export Data” (page 53). [ Data to Browser ] Opens a browser to display the data in a tabular format. See “Export Data” (page 53).
In the Partition Distribution Across Disks pane, you can: 1. 2. 3. Select a value for Count in the drop-down box. Select a value for Delta from AVG in the drop-down box. Click [ Refresh ] to refresh the pane by re-fetching the partition distribution. In the Partition Distribution Across Disks pane, these fields can be selected in the drop-down box: Field or Option Description Count Specifies the maximum number of partitions displayed.
3. To activate the Table Growth pane, you can either: • Double-click a bar in the graph of the SQL Objects pane • Double-click a row in the SQL Objects Detail pane 4. To enlarge the view of the Table Growth pane, click the box icon on the right of the heading. When the display is focused on one pane, you can no longer view information from the other panes. To return to the full system view, click on the box icon again.
1. Select a date range for the graph using the drop-down boxes. By default, the By Table data grid fetches table details for the last quarter. You can also select other time range options: • Custom Range • Last day • Last week • Last month • Last quarter • Last year 2. Click [ Refresh ] to refresh the pane by re-fetching table growth information. The bar graph color communicates table growth: Color Description Red Indicates the minimum and maximum table growth.
Top Fastest Growing Tables Tab The Top Fastest Growing Tables tab allows you to view the top fastest growing tables (in bytes per second) and specify a date interval for which data is fetched. This figure shows a snapshot of the Top Fastest Growing Tables tab which displays the object sizes for a table named T100K during a custom selected time range: 1. Select a date range for the graph using the drop-down boxes.
Field or Option Description Object Name Space Specifies the object name space as: • CN—Constraint • IX—Index • LK—Lock • TA—Table value object (table, view, stored procedure, SQL/MP alias) • TR—Trigger • TT—Trigger temp table Object Name Specifies the SQL object name. Start Size The object size corresponds to the start time (or close to the start time), in megabytes (MB). End Size The object size corresponds to the endme (or close to the end time), in megabytes (MB).
About the General Tab The General tab includes these groups: • “Inventory Control ” (page 262) • “Inventory Process Detail Status” (page 264) Inventory Control The Inventory Control group allows you to define the inventory criteria to be displayed: Field or Option Description EXCLUDE Use the EXCLUDE check box to exclude full inventory of a catalog, schema, or object in the inventory criteria. Deselecting the EXCLUDE check box allows full inventory of that object to be displayed.
Field or Option Description [ Resume ] Resumes the inventory. [ Stop ] Stops the inventory. [ Status ] Obtains status and displays the progress at the bottom of the screen. In the Others area, you can configure these settings: Field or Option Description Space Reference Settings Displays a window that specifies the locations of the space references. These references are verified at startup after log on.
The references are verified upon startup after initial logon and also verified each time you switch to another already connected system. If any of the references specified cannot be found, a dialog box displays a warning, but the Space Management client continues to run. If tables are missing, you run into multiple SQL errors upon refresh of the schema.
Inventory Options In the Inventory Options group, these options can be selected in the drop-down box: Field or Option Description Process Count Number of parallel processes used for inventory. Config Rate An internal pacing value keeping inventory from using too many system resources. Update Space Reference Tables In the Update Space Reference Tables group, these tabs can be selected: Tab Description Snapshot Periods Table Exposes the table that controls space data aging and aggregation.
System Registry Table Tab This figure displays the System Registry Table tab: About Space Management Tracing Options The Space Management Options dialog box shows tracing controls for Space Management. These tracing controls are for HP support use only.
Glossary active command A command used by the System Offender to query the database (for example, STATUS CPU PROCESS ALL) for offending processes. The active command appears underneath the System Offender tab. The active command changes depending on the area you click in the System Monitor. For more information, see “Find Offending Processes and Queries” (page 194) and “Control the Refresh of System Offender” (page 208).
disconnect Since connections are transient, there is no concept of logging on or logging off. The HPDM equivalent of logon is making a system usable by entering the correct settings. The HPDM equivalent of logoff is making a system unusable by disconnecting (or invalidating any of its other settings). Use the Disconnect function when you want the client application to continue running, but you want to deny continued access to a system without having to remove the system definition.
operator privilege An NDCS privilege that allows a user to perform administrative tasks, such as managing data source configurations, NDCS services, data sources, and servers, by making changes to status and configuration. For more information, see “Display NDCS Privileges” (page 161) or “Grant NDCS Privileges” (page 161). page mode A SQL Whiteboard feature that breaks large result sets into pages and fetches one page at a time.
schema, and ODBC driver version. The banner displays the system definition. See “See the HPDM Banner” (page 41). 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. See “Display the System Monitor” (page 171).
Index Symbols 100% settings, 177 21034, event message, 56 21035, event message, 57 A Abort Change Password if Logging Fails option, 122 Abort Database Login if Logging Fails option, 122 Abort User Management Operation if Logging Fails option, 122 About box, HPDM, 47 command, Help menu, 44 Accessed Rows, Workload Detail dialog box, 206 Accesses Database, 167 ACKNOWLEDGED value, alerts, 189 Active command defined, 267 System Monitor effect on, 195 where displayed, 208 Active directory servers, 131 Active sys
Association servers comparing MXOAS and MXAS2, 156 defined, 267 Attributes tab materialized view groups, 84 materialized view indexes, 81 materialized views, 77 procedures, 85 schemas, 64 synonyms, 88 table indexes, 72 tables, 69 triggers, 90 Auto Download Certificate option, 119, 129 Auto Refresh option, 202 Available Data Source Status, 142 Data Sources, 141 B Banner example, 41 location, 35 Build information HPDM client, 47 online help, 13 By Table tab, 258 C CA certificate, 126 Cache Hits, 172 Cancel
Create time (role), 95 Created by (role), 95 Cut command Edit menu, 42 SQL Whiteboard, 215 System Message, 54 toolbar button, 44 D Data columns, sorting and moving, 47 Data grid Copy command, 50 customizing, 52 defined, 267 description of, 48 row details, 49 searching, 52 Data Source Add System dialog box, 30 Connect/Edit System dialog box, 26 copying, 150 creating, 142 defined, 267 deleting, 152 displaying, 141 name, 143 performance, 143 starting, 151 Status tab, 141 stopping, 151 updating, 152 Data Sourc
Edit menu options, 42 Edit Platform User dialog box, 113 Edit SET dialog box, 148 Edit User dialog box, 109 Editing a system, 32 EID Heap Alloc, Workload Detail dialog box, 206 EID Heap Used, Workload Detail dialog box, 206 EID Max Buffer, Workload Detail dialog box, 204 EID Rows Accessed, Workload Detail dialog box, 204 EID Rows Used, Workload Detail dialog box, 204 EID Space Alloc, Workload Detail dialog box, 206 EID Space Used, Workload Detail dialog box, 206 ELAPSED TIME, 200 Elapsed, Workload Detail di
IR_DETECTED_UTC_TS, 185 IR_ID, 185 IR_LAST_UPDATE_LCT_TS, 186 IR_LAST_UPDATE_UTC_TS, 185 IR_NOTES, 186 IR_SEGMENT, 185 IR_SEVERITY, 185 IR_STATUS, 185 J JAR file deleting, 165 downloading, 164 renaming, 164 uploading, 163 L Last Interval Processor, Workload Detail dialog box, 207 Last State Changed, Data Source Status, 142 Last Updated Time NDCS Server, 156 NDCS Services, 158 LDAP defined, 268 directory servers, 131 Version field, 133 Length, Workload Detail dialog box, 207 LEVEL, 184 Link Reports dialog
Space Management, 246 System Monitor, 171 Mouse-over color, 178 Multicolumn sorting, 48 MXAS2 defined, 268 function of, 156 MXOAS defined, 268 function of, 156 My Favorites pane, 40 My Other Systems folder, 20 My Systems, 268 navigration tree pane folder, 37 result of connecting, 25 right-clicking, 29 N Name, SQL Whiteboard, 213 Navigation Tree Pane defined, 268 overview, 37 NCI (see also Neoview Command Interface (NCI)), 239 NDCS privileges displaying, 161 granting, 161 revoking, 162 NDCS server defined,
Parent Pstate dialog box, 197 Parent QID, Workload Detail dialog box, 205 PARENT SEGMENT, 200 Partitions tab materialized view indexes, 82 materialized views, 78 table indexes, 73 tables, 69 Password Add Directory Server dialog box, 133 Add System dialog box, 31 changing after logon, 116 changing at logon, 115 changing by editing user, 116 Connect/Edit System dialog box, 26 considerations, 27 Control, 121 expired, 115 field, 31 not specified, 29 quality policy, 120 tab, 120 Paste command Edit menu, 43 SQL W
defined, 269 finding an offending, 194 runaway, 194 workload information, 201 QUERY ID, 200 Query ID, Workload Detail dialog box, 203 QUERY NAME, 201 QUERY TEXT, 201 Query Text (Preview), Workload Detail dialog box, 207 Query, Workload Detail dialog box, 203 Queue Length, 172 R README for HPDM, 23 Reason, Workload Detail dialog box, 203 Red CPU numbers, 199 Redo command Edit menu, 42 SQL Whiteboard, 215 System Message, 54 Refresh button, security policies, 119 button, Workload Detail, 202 changing the inte
Schema, default Add System dialog box, 31 Connect / Edit System dialog box, 26 SQL Whiteboard, 213 Schemas attributes tab, 64 DDL tab, 65 displaying, 63 materialized view groups tab, 64 materialized views tab, 64 privileges tab, 66 procedures tab, 65 size information, 66 synonyms tab, 65 tables tab, 64 view tab, 65 Search command, Help menu, 44 Search DN, 133 Searching, alerts, 52 Security policies about, 117 changing, 117 displaying, 117 managing, 117 Security tab, 117 SEGMENT, 200 Segment aggregation, 178
data source configuration, 145 understanding, 61 SQLPrepare statistics data source configuration, 145 understanding, 61 Start Ahead Data Source Status, 142 Data Sources, 141 Start Mode, 143 Start, Workload Detail dialog box, 203 State Data Source Status, 142 NDCS Server, 156 NDCS Services, 158 Workload Detail dialog box, 202 Statement Details pane, SQL Whiteboard, 215 Statement ID, Workload Detail dialog box, 205 Statement List pane, 212 Statement pane, 213 Statement statistics, 145 Statement Type, Workload
privileges tab, 70 size, displaying, 71 statistics tab, 70 summary information for, 71 tab, 64 unique constraints tab, 68 usage tab, 69 Tabs cloning, 46 working with, 45 TCP PORT, 200 TCP STATE, 200 TDM_Default_DataSource defined, 270 deleting, 152 Test command, 33 Threshold exceeded color, 178 Time Range option, 186 Timeline options, 178 Timeline tab, 173 Timeout color, 178 setting the connection, 34 Timer status bar, 191 Toolbar alerts, 187 HPDM, 44 Metric Miner, 222 Tools menu options, 43 Tooltips, 143 T
Windows cloning, 46 managing in HPDM, 45 menu options, 43 working with, 45 Windows Manager menu option, 43 toolbar button, 44 using, 45 Word Wrap command, 215 Workload Detail dialog box displaying, 201 using, 201 Y Your Name for System Add System dialog box, 30 Connect/Edit System dialog box, 26 282 Index
