Document Outline

• HP Database Manager (HPDM) User Guide
• Table of Contents
• Learn About This Document
  • Publishing History
  • New and Changed Information
  • Intended Audience
  • Related Documentation
    • Neoview Customer Library
  • Resources on the Web
  • Send Feedback to HP
• 1 Install and Start HPDM
  • What is the HP Database Manager?
  • Install the HP Database Manager
  • Uninstall the HP Database Manager
  • Start the HP Database Manager
  • Use Menu Bar Commands
  • Exit the HP Database Manager
• 2 Connect and Disconnect
  • Connect to a System
  • Use the Connect / Edit System Dialog Box
  • 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
• 3 Navigate HPDM
  • See the Parts of the HPDM Interface
  • Select an Area
  • Control the Display of an Area
  • Use the Navigation Tree Pane
    • Understand My Active Systems
    • Understand My Other Systems
  • 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 Header
  • Customize HPDM Windows
  • Manage Windows
  • Get Version and Build Information
• 4 Perform Basic HPDM Operations
  • Sort and Move Data Columns
  • Clone a Tab
  • 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
    • Learn About the Monitoring Area
    • Use the System Message Tab
    • Navigate 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
• 5 Manage 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
    • 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
• 6 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
• 7 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
• 8 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
  • 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
• 9 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
• 10 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
    • 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
• 11 Launch the Neoview Command Interface (NCI)
  • Learn About NCI
  • Locate the NCI Program
  • Launch NCI
  • Set Auto Logon Options
• 12 Manage Disk Space
  • About Space Management
  • Display the Space Management Area
  • See the Parts of Space Management
  • Understand Space Usage Statistics
  • Get Version and Build Information for Space Management
  • 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
  • About Space Management Tracing Options
• Glossary
• Index