Document Outline

• HP Database Manager (HPDM) User Guide
• Table of Contents
• About This Guide
  • Publishing History
  • New and Changed Information
  • Intended Audience
  • Related Documentation
    • Neoview Customer Library
  • Resources on the Web
  • Send Feedback to HP
• 1 About HPDM
  • What Is HPDM?
  • What Are the HPDM Features?
  • Which Servers Are Compatible With the HPDM Client?
• 2 Install and Start HPDM
  • Install the HP Database Manager
  • Uninstall the HP Database Manager
  • Start the HP Database Manager
  • Exit the HP Database Manager
• 3 Connect and Disconnect
  • Connect to a System
  • Use the Connect / Edit System Dialog Box
  • Password Considerations
  • Disconnect From a System
  • Log On and Off
  • Use the Systems Tool
  • Add a System
  • Use the Add System Dialog Box
  • Edit a System
  • Add a System Like...
  • Remove a System
  • Test a System
  • Set the Connection Timeout
• 4 Navigate HPDM
  • See the Parts of the HPDM Interface
  • Select an Area
  • Control the Display of an Area
  • Use the Navigation Tree Pane
  • Use the Right Pane
  • Use the My Favorites Pane
    • Create a Favorite
    • Use a Favorite
    • View a List of Favorites
    • Create a Folder to Store Favorites
    • Add a Favorite to a Folder
    • Share Your Favorites With Others
    • Remove a Favorite
    • Remove a Favorites Folder
  • See the HPDM Banner
  • Use Menu Bar Commands
    • Use the File Menu Options
    • Use the Edit Menu Options
    • Use the Tools Menu Options
    • Use the Windows Menu Options
    • Use the Help Menu Options
  • Use the HPDM Toolbar
  • Work With Windows, Tabs, and Panes
    • Manage Multiple Open Windows
    • Clone Tabs
    • Expand and Collapse Panes
• 5 Perform Basic HPDM Operations
  • Get Version and Build Information
  • Resolve Errors and Error Messages
  • Sort and Move Data Columns
  • Work With Data Grids
    • About Data Grids
    • Get Row Details for a Data Grid
    • Copy Data-Grid Information
    • Customize the Data Grid
    • Search the Data Grid
  • Export Data
    • Export Data to the Clipboard
    • Export Data to a File
      • Save Data in CSV Format
      • Save Data in HTML Format
    • Save Data to a Spreadsheet
    • Export Data to a Browser
  • Communicate System Messages to Users
    • Use the System Message Tab
    • Create a System Message
    • Clone the System Message Tab
  • Save and Import System Definitions
  • View Event Messages
    • View Dial Out and Database Events
    • See the Trace Event Message Format
    • Resource Statistics Event Message Format
    • Session Statistics: Connection Information
    • Session Statistics: Session Summary Information
    • Statement Statistics: SQL Statement
    • Statement Statistics: SQLExecute
    • Statement Statistics: SQLExecDirect
    • Statement Statistics: SQLPrepare
    • Statement Statistics: SQLFetch
• 6 Display Database Objects
  • Display Schemas and Their Objects
    • Attributes Tab
    • Tables Tab
    • Materialized Views Tab
    • Materialized View Groups Tab
    • Views Tab
    • Procedures Tab
    • Synonyms Tab
    • DDL Tab
    • Privileges Tab
    • Schema Size
  • Display Tables and Their Properties
    • 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
    • Tables Summary
  • Display Table Indexes and Their Properties
    • Columns Tab
    • Attributes Tab
    • DDL Tab
    • Partitions Tab
    • Table Indexes Summary
  • Display Views and Their Properties
    • Columns Tab
    • Usage Tab
    • DDL Tab
    • Privileges Tab
  • Display Materialized Views and Their Properties
    • Attributes Tab
    • Partitions Tab
    • Usage Tab
    • DDL Tab
    • Privileges Tab
    • Materialized Views Summary
  • Display Materialized View Indexes and Their Properties
    • Columns Tab
    • Attributes Tab
    • DDL Tab
    • Partitions Tab
    • Materialized View Indexes Summary
  • Display Materialized View Groups and Their Properties
    • Attributes Tab
    • Members Tab
    • DDL Tab
  • Display Procedures and Their Properties
    • Attributes Tab
    • Parameters Tab
    • Usage Tab
    • Privileges Tab
  • Display Synonyms and Their Properties
    • Attributes Tab
    • Usage Tab
    • DDL Tab
  • Display Triggers and Their Properties
    • Attributes Tab
    • Usage Tab
    • DDL Tab
  • Display Schema DDL and Their Properties
    • DDL Tab
    • Show DDL
  • Display Table Statistics and Their Properties
    • Display Table Column Statistics
    • Viewing Sampled Statistics
• 7 Manage Roles
  • About Roles
  • Display All Roles
  • Display the Users Who Belong to a Role
  • Display All the Roles for a User
  • Display the SQL Privileges for a Role
  • Add a Role
  • Delete a Role
  • Grant a Role to a User
  • Use the Grant Role Dialog Box
  • Revoke a Role From a User
  • Change the Password or Expiration for a Role
  • Use the Change Role Password Dialog Box
• 8 Manage Users and Passwords
  • About Users
  • Database Users
    • Display All Database Users
    • Add a Database User
    • Use the Add Database User Dialog Box
    • Use the Select User Role Dialog Box
    • Add Multiple Database Users
    • Use the Add Multiple Database Users Dialog Box
    • Copy a Database User
    • Control the Display of the Add Database User Dialog Box
    • Change Role or Password Information for a Database User
    • Use the Edit User Dialog Box
    • Delete One or More Database Users
    • Change Your Own Default Role
  • Platform Users
    • Display All Platform Users
    • Add a Platform User
    • Copy a Platform User
    • Use the Add Platform User (or Edit User) Dialog Box
    • Edit a Platform User
    • Delete One or More Platform Users
  • Passwords for Users
    • Change Your Own Password at Logon
    • Change Your Own Password After Logon
    • Use the Change Password Dialog Box
    • Change a Password or Password Expiration Settings by Editing a User
• 9 Manage Security Policies
  • About Security Policies
  • Display Security Policies
  • Change a Security Policy
  • Use the Certificate & Connection Tab for Security Policies
  • Use the Password Tab for Security Policies
  • Use the Logging Tab for Security Policies
  • Use the Power Role Management Tab for Security Policies
• 10 Manage Certificates
  • About Certificates
  • Specify a Certificate File at Connect Time
  • Generate a Self-Signed Certificate
  • Use the Self-Signed Certificate Tab
  • Obtain and Install a CA Certificate and Private Key
  • Generate a Certificate Signing Request (CSR)
  • Use the Generate CSR Tab
  • Install Root and Intermediate Certificates on the Neoview Platform
  • Use the Deploy CA Signed Certificate Tab
  • About the Auto Download Certificate Option
• 11 Manage Directory Servers
  • About Directory Servers
  • Display the Configured Directory Servers
  • Add a Directory Server
  • Use the Add Directory Server Dialog Box
  • Understand Configuration Parameters
  • Considerations for Adding Directory Servers
  • Example: LDAP Server
  • Example: Active Directory Server
  • Edit a Directory Server
  • Use the Edit Directory Server Dialog Box
  • Copy a Configured Directory Server
  • Delete a Directory Server
• 12 Manage Data Sources
  • Display Data Sources
  • Create a Data Source
    • Use the General Properties Tab
    • Understand Processing-Node Numbering
    • Add or Modify Resource Management Policy
    • Use the DEFINEs and SETs Tab
    • Use the Control Query Defaults Tab
    • Use the Controlled Tables Tab
      • If-Locked Option of Controlled Tables Tab
      • MDAM Option of Controlled Tables Tab
      • Priority Option of Controlled Tables Tab
      • Similarity Check Option of Controlled Tables Tab
      • Table Lock Option of Controlled Tables Tab
      • Timeout Option of Controlled Tables Tab
  • Copy a Data Source
  • Start a Data Source
  • Stop a Data Source
  • Update a Data Source
  • Delete a Data Source
• 13 Manage Connectivity
  • Display NDCS Servers
  • Learn About the Association Servers
  • Stop an NDCS Server
  • Display NDCS Services
  • Start an NDCS Service
  • Stop an NDCS Service
  • Start and Stop Server Traces
  • Learn About Server Traces
• 14 Manage NDCS Privileges
  • Display NDCS Privileges
  • Grant NDCS Privileges
  • Revoke NDCS Privileges
• 15 Manage Procedures
  • Display Procedures
  • Upload a JAR File
  • Download a JAR File
  • Rename a JAR File
  • Delete a JAR File
  • Create a Procedure
  • Use the Create Procedure Dialog Box
  • Use a Method in a Procedure
  • Drop a Procedure
• 16 Use the System Monitor
  • Display the System Monitor
  • See the Parts of the System Monitor
  • Understand the Performance Metrics
  • Use Tooltips to Show the Value of a Performance Metric
  • About the Timeline Tab
  • About the Hybrid Tab
  • Understand the System Status Icons
  • Get Details About System Status Icons
  • Configure System Monitor Options
  • Use the System Monitor With Segment Aggregation
  • Change a Color Option
• 17 Respond to Alerts
  • Display the Alerts Tab
  • See the Parts of the Alerts Tab
  • Understand Alerts
  • Understand Privileges for Viewing and Updating Alerts
  • Get Information About Alerts
  • Understand Row Detail Information for Alerts
  • Use the Alerts Options Dialog Box
  • Control the Refresh of Alerts
  • Use the Update Alert Dialog Box
  • Update an Alert
  • Update Multiple Alerts
  • Make Notes About an Alert
  • About the Console Tab
• 18 Find Offending Processes and Queries
  • About System Offender
  • Display the System Offender Tab
  • See the Parts of the System Offender
  • Understand System Offender Privileges
  • Find Offending Processes and Queries
  • Get Process Detail Information
  • Get Pstate Information
  • Get Children Process Information
  • Use the Children Processes Dialog Box
  • Understand Row Details for System Offender
  • Get Query Workload Information
  • Use the Workload Detail Dialog Box
    • Query Information
    • Understand the Warning Information
    • Compiler Statistics
    • Runtime Statistics
  • Cancel a Query From System Offender
  • Alter System Offender Parameters
  • Use the Alter Offender Parameters Dialog Box
  • Control the Refresh of System Offender
  • Use the System Offender History
• 19 Use the SQL Whiteboard
  • About the SQL Whiteboard
  • Display the SQL Whiteboard
  • Learn About the SQL Whiteboard Panes
  • Learn About the Statement List Pane
  • Learn About the Statement Pane
    • Understand Parameter Prompts
    • Understand Page Mode
    • Cut, Copy, Paste, Undo, and Redo
    • Execute Highlighted Text
    • Cancel a Query From the SQL Whiteboard
  • Learn About the Statement Details Pane
  • Reuse a Connection
  • Load and Save SQL Statements to a File
  • Highlight SQL Syntax
  • Manage the Layout of Panes
• 20 Use Metric Miner
  • About Metric Miner
  • Compare Metric Miner, SQL Whiteboard, and Neoview Reports
  • Launch Metric Miner
  • See the Parts of Metric Miner
  • Use the Metric Miner Toolbar
  • Create Report Folders
    • Create a Report Folder
    • Delete a Report Folder
    • Refresh the Report Explorer
  • Run Statements
    • Run a SQL Statement Using Metric Miner
    • Use the SQL Designer
    • Add Parameters to Statements
    • Cancel a Query From Metric Miner
    • Resolve Out-of-Memory Errors
    • Export Metric Miner Data
    • Control the Refresh of Metric Miner Information
    • Use the Data Grid Features of the Report Results Pane
    • See a History of Your SQL Statements
  • Create and Manage Reports
    • Create a Report
    • Use the Report Configuration Dialog Box
    • Display and Run a Saved Report
    • Modify a Saved Report
    • Close a Report
    • Delete a Report
    • Rename a Report or Report Folder
    • Copy a Report
    • Share a Report With Another User
    • Use Preconfigured Reports Included With Metric Miner
    • Import Neoview Reports
  • Link and Drill Down
    • Link Reports in Metric Miner
    • Use the Select Report Dialog Box
    • Use the Link Reports Dialog Box
    • Drill Down Through Linked Reports in Metric Miner
• 21 Launch the Neoview Command Interface (NCI)
  • Learn About NCI
  • Locate the NCI Program
  • Launch NCI
  • Set Auto Logon Options
• 22 Manage Disk Space
  • About Space Management
  • Display the Space Management Area
  • See the Parts of Space Management
  • Understand Space Usage Statistics
  • About the Monitoring Tab
  • View the Over Threshold Summary
  • View the System Overall
  • View the System Detail
  • View SQL Objects
  • View the SQL Objects Detail
  • View Partition Distribution Across Disks
  • View Table Growth
    • By Table Tab
    • Top Fastest Growing Tables Tab
  • Understand Historical Space Data
  • About the Configuration Tab
    • About the General Tab
      • Inventory Control
        • Space Reference Settings
        • Inventory Process Detail Status
    • About the Advanced Tab
      • Inventory Options
      • Update Space Reference Tables
        • Snapshot Periods Table Tab
        • Classification Rule Table Tab
        • System Registry Table Tab
  • About Space Management Tracing Options
• Glossary
• Index