Hp Neoview Release 2.4 Software Uživatelský manuál Strana 1

HP Database Manager (HPDM) User GuideHP Part Number: 546008-001Published: April 2009Edition: HP Neoview Release 2.4

Installation RequirementsDescriptionRequirementWindows compatible PC workstationComputer1024 x 768 pixelsMonitor screen resolutionRecommended minimum

NOTE: All of the current settings are replaced by the settings in the file being imported.Customizing HPDM WindowsHPDM allows you to customize and res

12

2 The Systems ToolSystems ToolThe Systems Tool contains the components used to define, add, edit, remove, duplicate, test,and open existing systems on

NOTE: Once a system is added, the system definition persists from session to session unless itis removed.In the Add System window, these fields define

Edit SystemNOTE: The Systems Tool window shows the active system definitions. Editing an active systemdefinition causes all previously configured syst

Add System Like ThisTo add a system like the selected system’s current settings:• Select the system definition you want to duplicate in the Systems To

3 Navigating HPDMNavigation Tree PaneThe navigation tree pane in HPDM displays a tree of the database objects in hierarchical form.The navigation tree

To display the My Other Systems folder options, right-click on the My Other Systems folderand the options are:• Add to Favorites creates a shortcut fo

• [Data to Spreadsheet] opens the Excel application and displays the data.• [Data to File] exports the data to a file in CSV format.Right Pane 19

© Copyright 2009 Hewlett-Packard Development Company, L.P.

20

4 Managing Database ObjectsThis section describes how to display schemas, tables, table indexes, views, materialized views,materialized view indexes,

Displaying Schemas and Their ObjectsTo display the schema names and attributes for the schema:1. Start the HP Database Manager and log on using any us

Name: Name of the schema.•• Owner: The owner of the schema.• Version: Specfies the version of the schema.Tables TabTo display the table names that bel

Name: Name of the view. Each view is hyperlinked and detailed information about theview is displayed.•• Creation Time: Time and date when the view was

• Grantee: The name of a user whose privilege is being described.• Grantor: The name of the user who granted the privileges and the special SQL user n

Displaying Tables and Their PropertiesTo display the table columns, primary key information, attributes, and usage information:1. Start the HP Databas

Columns TabTo display the table columns:1. Select a Schema and table and click the table name in the right pane, or open the Tablesfolder and select a

Constraint Name: Name of the unique constraint.•• Columns: The name of the columns that are constrained.Foreign Keys TabTo display the foreign keys in

Usage TabTo display usage information defined on the table:1. Select a Schema in the navigation tree and click the table name in the right pane, or op

Table of ContentsAbout This Document...7Intended

• With Grant: Specifies an ‘X’ to indicate if the user has grant privileges.• Grant Level: The level at which the permissions are visible. The values

Displaying Table Indexes and Their PropertiesTo display the indexes for tables, columns, and attributes:1. Start the HP Database Manager and log on us

Attributes TabTo display the table index attributes:1. Select a Schema in the navigation tree.2. Click the Tables folder and open the Indexes folder a

• Total Current Size: The total current size of the index (in bytes).• Percent Allocated: The percent full of the index.The detailed summary is a snap

Displaying Views and Their PropertiesTo display the view information:1. Start the HP Database Manager and log on using any user ID.2. Click the Databa

• Data Type: SQL datatype of the column.• Nullable: If column is NOT NULL NOT DROPPABLE, the value displayed is “NotNullable.” If the column is NOT NU

Schema indicates permissions have been applied to the schema.—— Object indicates permissions were applied directly to the object whose permissions are

Displaying Materialized Views and Their PropertiesTo display the materialized view information:1. Start the HP Database Manager and log on using any u

Name: External name of the materialized view.•• Refresh Type: Refresh policy displayed is (Recompute | On Refresh | On Statement).— RecomputeDerives t

Partition Number: The index number of the partition.•• Percent Allocated: The percentage full of the partition.• Row Count: The current total number o

Primary Key Tab...27Hash Ke

• With Grant: Specifies an ‘X’ to indicate if the user has grant privileges.• Grant Level: The level at which the permissions are visible. The values

Displaying Materialized View Indexes and Their PropertiesTo display the materialized view index information:1. Start the HP Database Manager and log o

Attributes TabTo display the materialized view attributes:1. Select a Schema in the navigation tree.2. Open the Materialized Views folder, select and

Displaying Materialized View Indexes SummaryTo display a detailed summary of the materialized views:1. Select a Schema and right-click on the Material

Displaying Materialized View Groups and Their PropertiesWhen you create a materialized view, a materialized view group is created automatically. It ha

Name: Name of the materialized view group.•• Creation Time: Time and date when the materialized view group was created.Timestamp is in the format (yyy

Displaying Procedures and Their PropertiesTo display the procedures names in the schema:1. Start the HP Database Manager and log on using any user ID.

• SQL Access: Specifies the way this procedure interacts with SQL Database. The valuesdisplayed are: CONTAINS SQL | MODIFIES SQL DATA | READS SQL DATA

1. Select a Schema in the navigation tree.2. Click on the Procedures tab in the right pane and select a procedure name, or open theProcedures folder a

Displaying Synonyms and Their PropertiesTo display the synonym names in the schema:1. Start the HP Database Manager and log on using any user ID.2. Cl

Displaying Table Statistics and Their Properties...56Displaying Table C

Usage TabTo display the synonym usage information:1. Select a Schema in the navigation tree.2. Click on the Synonyms tab in the right pane and select

Displaying Triggers and Their PropertiesA trigger is a mechanism that resides in the database and specifies that when a particularaction—an insert, de

• Activation Time: Specifies when the trigger is activated. Used in combination with anoperation. The value is “Before” or “After.”• Operation: Specif

Displaying Schema DDL and Their PropertiesTo display schema DDL information, a DDL tab appears in the right pane when these objectsare selected in the

• In the Show DDL dialog box, the Select Objects pane displays a “Selection Tree” thatdisplays a navigation tree. The “Selection Tree” has check boxes

• The DDL Output pane has a text box with scroll bars and the DDL output is displayed inthe text box.• The Show DDL dialog box options are:— [Load] lo

Displaying Table Statistics and Their PropertiesHPDM allows you to display table profile or statistics information. The table profile or statisticsinf

The bottom pane displays the histogram intervals for the column data boundaries. For eachboundary it displays the data from the stats table and the re

58

5 Using the SQL WhiteboardThe SQL Whiteboard allows you to enter and execute SQL statements from within HPDM andprovides execution information for eac

6

Statement List PaneThe Statement List pane provides a list of SQL statements that you added in a current sessionor earlier sessions of the SQL Whitebo

all parameters in that statement and allows you to easily re-use recent values for those parameters.The feature is compatible with Neoview Reports.Cut

a single session using the same connection. A good example is when you are using volatile tables.You create the volatile table first and then run quer

6 Launching the Neoview Command Interface (NCI)The Neoview platform supports a client-based utility, Neoview Command Interface (NCI), whichenables you

64

7 Performing HPDM OperationsThe HPDM application allows you to perform various database operations:• “Exporting Data” (page 65)• “Communicating System

Communicating System MessagesIf you are an administrator for a Neoview platform, you may need communicate information tousers of HPDM (for example, cu

CloningIf you double-click on the System Message tab, the control is cloned into a new window. Whenthe contents of the system message is modified in a

68

8 GlossaryGlossaryClear Password Since connections are transient, there is no concept of logging on or logging off. The analog of logon ismaking a sys

About This DocumentThis guide describes how to use the HP Database Manager (HPDM) to connect and manage aNeoview Data Warehousing Platform for Busines

Context-sensitive help topics that describe how to use the NeoviewManagement Dashboard Client.Neoview Management DashboardOnline HelpContext-sensitive

1 Introduction to the HP Database ManagerHP Database ManagerThe HP Database Manager (HPDM) is an integrated graphical client that allows you to connec