HP Neoview Release 2.5 Software - Manual (Page 19)

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). You can open an NCI window from within HPDM. See
“Launch NCI” (page 239) .
HPDM requires the HP ODBC 2.0 client driver for Windows to connect to an HP Neoview
platform. Download the HP ODBC 2.0 client driver from the HP Software Depot download site
and install it prior to running the HP Database Manager. See
“Resources on the Web” (page 17) .
Related Topics
“What Are the HPDM Features?” (page 19)
What Are the HPDM Features?
HPDM provides these features:
• Platform Monitoring
— Provides performance monitoring capabilities
— Provides the ability to monitor alerts and alarms.
— Enables the monitoring of offending workloads.
• Database-Object Browsing
— Provides database-object browsing capabilities
— Displays partition information for individual Neoview SQL objects
— Displays a partition summary for groups of objects (for example, all tables in a schema)
— Displays schema size information
— Displays sequence numbers in table columns
— Provides a DDL tool to generate and save the DDL script for a group of Neoview SQL
objects
— Displays table profile and statistics information
— Generates and displays system status messages
• Space Management
— Allows you to monitor and display SQL space-related data
— Displays six panes of detailed SQL-space usage statistics
— Presents SQL space by user, by schema, by table, and by partition
— Helps you identify and react to fast-growing tables by looking at historical trends
• SQL Whiteboard
— Executes DDL/DML statements
— Persists queries across sessions for reuse
— Exports query results to a spreadsheet
— Allows a portion of an SQL statement to be highlighted and executed (syntax
highlighting)
— Cancels an executing query
— Opens/saves query text to a file
What Is HPDM? 19