HP Database Manager (HPDM) User Guide (R2.4 SP1)

Customize HPDM Windows................................................................................................................32
Manage Windows.................................................................................................................................32
Get Version and Build Information......................................................................................................32
4 Perform Basic HPDM Operations...............................................................................35
Sort and Move Data Columns...............................................................................................................35
Clone a Tab............................................................................................................................................36
Export Data...........................................................................................................................................37
Export Data to the Clipboard..........................................................................................................37
Export Data to a File........................................................................................................................37
Save Data in CSV Format...........................................................................................................37
Save Data in HTML Format.......................................................................................................37
Save Data to a Spreadsheet..............................................................................................................37
Export Data to a Browser.................................................................................................................37
Communicate System Messages to Users.............................................................................................38
Learn About the Monitoring Area...................................................................................................38
Use the System Message Tab...........................................................................................................38
Navigate the System Message Tab..................................................................................................39
Create a System Message.................................................................................................................39
Clone the System Message Tab........................................................................................................39
Save and Import System Definitions....................................................................................................39
View Event Messages............................................................................................................................40
View Dial Out and Database Events...............................................................................................40
See the Trace Event Message Format...............................................................................................41
Resource Statistics Event Message Format......................................................................................42
Session Statistics: Connection Information.....................................................................................42
Session Statistics: Session Summary Information...........................................................................43
Statement Statistics: SQL Statement................................................................................................44
Statement Statistics: SQLExecute.....................................................................................................44
Statement Statistics: SQLExecDirect................................................................................................45
Statement Statistics: SQLPrepare.....................................................................................................45
Statement Statistics: SQLFetch........................................................................................................46
5 Manage Database Objects........................................................................................47
Display Schemas and Their Objects......................................................................................................47
Attributes Tab..................................................................................................................................48
Tables Tab........................................................................................................................................48
Materialized Views Tab...................................................................................................................48
Materialized View Groups Tab........................................................................................................48
Views Tab.........................................................................................................................................49
Procedures Tab................................................................................................................................49
Synonyms Tab..................................................................................................................................49
DDL Tab...........................................................................................................................................49
Privileges Tab...................................................................................................................................50
Schema Size.....................................................................................................................................50
Display Tables and Their Properties.....................................................................................................50
Columns Tab....................................................................................................................................51
Primary Key Tab..............................................................................................................................52
Hash Key Tab...................................................................................................................................52
Unique Constraints Tab...................................................................................................................52
Foreign Keys Tab.............................................................................................................................52
Attributes Tab..................................................................................................................................53
Partitions Tab...................................................................................................................................53
4 Table of Contents