Hp Neoview Release 2.4 Software Manuale Utente

HP Database Manager (HPDM) User GuideHP Part Number: 597527-001Published: March 2010Edition: HP Neoview Release 2.4 Service Pack 2

Neoview Customer LibraryThe manuals in the Neoview customer library are listed here for your convenience. Customerlibrary manuals are available on the

See the Parts of the System OffenderRelated Topics“Understand System Offender Privileges” (page 100)“Find Offending Processes and Queries” (page 100)U

NOTE: Click once; you do not need to double-click.For exampleClick any CPU bar or header forthese performance metrics . . .or...–CPU Busy–Disk I/O–Cac

3. In the System Offender data grid, see a list of processes:4. Right-click a process that you want to learn more about, and select a command from the

data gridoffending processGet Process Detail InformationNOTE: Diagnostic information displayed by the Process Detail and Parent Process Detaildialog b

Get Pstate InformationNOTE: Diagnostic information displayed by the Pstate and Parent Pstate dialog boxes isintended for use by HP support. This infor

Use the Children Processes Dialog BoxTo display the Children Processes dialog box, see “Get Children Process Information” (page 104).This table descri

NOTE: Diagnostic information displayed by the System Offender tab is intended for use byHP support. If you have questions about an offending process,

DescriptionFieldThe name of the client workstation and application that generated the query.QUERY NAMEA preview of the actual query text (up to 254 ch

NOTE: Diagnostic information displayed by the Workload Detail dialog box is intended foruse by HP support. If you have questions about query diagnosti

NOTE: You can also cancel a query from the SQL Whiteboard. See “Cancel a Query From theSQL Whiteboard” (page 119).Related Topics“Get Query Workload In

Instructions for starting, using, customizing, and troubleshooting the NeoviewSystem Monitor.Neoview System Monitor QuickStartInformation about the lo

Related Topics“Alter System Offender Parameters” (page 109)Control the Refresh of System OffenderThe System Offender data grid is refreshed automatica

2. Click the [ Set Refresh Time ] button:3. Select a refresh interval. The timer status bar counts down the new refresh interval in seconds.Suppose th

To erase the history, click [ Clear ].To update the history, click [ Refresh ].112 Find Offending Processes and Queries

9 Work With Data GridsAbout Data GridsThe Alerts tab, System Offender tab, SQL Whiteboard Statement Details pane, and someSpace Management panels, suc

The Row Details dialog box displays all possible column information, whereas the data gridshows only the grid columns that are currently configured us

• To copy the data in noncontiguous cells, hold down the Control key, and select the cells youwant to copy. Then right-click, and select Copy:The cell

Customize the Data GridThe columns in data grids are fully customizable:Do thisTo1. Right-click a column heading in any data grid, and select Show/Hid

10 Use the SQL WhiteboardAbout the SQL WhiteboardThe SQL Whiteboard allows you to enter and execute SQL statements from within HPDM andprovides execut

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

Understand Parameter PromptsSQL statements can be parameterized by embedding parameter names surrounded by $$ (doubledollar signs). When the statement

Include the document title and part number shown below:Document Title: HP Database Manager (HPDM) User GuidePart Number: 597527-00112

DescriptionTabIs present if the statement has parameters and shows the values chosen for the current orearlier execution.Execution P arametersDisplays

To explicitly persist the layout, use the File > Save Persistence command. The layout is persistedautomatically when the SQL Whiteboard exits. The

122

11 Launch the Neoview Command Interface (NCI)Learn About NCIThe Neoview platform supports a client-based utility, Neoview Command Interface (NCI), whi

124

12 Manage Disk SpaceAbout Space ManagementSpace Management is a new area within HPDM that enables the monitoring and display of SQLspace-related data

4. In the right pane, click the Monitoring tab.After successful logon to a Neoview system:• Space references are verified.• Last inventory information

are reported on, and then selectively view each in the graph. Space Management employs a colorscheme to display each metric and its performance.Each p

DescriptionPanelBar graph view of the partition distribution across all disks in the system in megabytes (MB).PartitionDistribution AcrossDisksTimelin

View the Over Threshold SummaryThe Over Threshold Summary bar instantly allows you to identify if any disks, tables, orpartitions are reaching a speci

1 Install and Start HPDMWhat is the HP Database Manager?The HP Database Manager (HPDM) is an integrated graphical client that allows you to connectto

DescriptionFieldDisplays the disk name, table name, or partition name.Object NameFetches details from a Neoview Repository view:NEO.HP_METRICS.DISK_ST

FunctionButtonOpens the Excel application and displays the data. See “Export Data” (page 36).[ Data to Spreadsheet ]Exports the data to a file in CSV

In the System Overall panel, these fields can be selected in the drop-down box:DescriptionField or OptionSelect the type of information to be retrieve

To activate the System Detail panel, you can either:1. Select a row in the data grid and click [ Refresh ] to refresh the panel by re-fetching thespac

To change the sort order of a displayed column:• Click the title of the column that you want to sort in ascending or descending order. See“Sort and Mo

FunctionButtonOpens the Excel application and displays the data. See “Export Data” (page 36).[ Data to Spreadsheet ]Exports the data to a file in CSV

NOTE: The name and size of the object appears whenever you place your cursor on a bar inthe graph.In the SQL Objects panel, these fields can be select

This figure shows a view of the SQL Objects Detail panel:If you click the Filter Settings bar, you can:• Select the columns to be displayed in the dat

To change the sort order of a displayed column:• Click the title of the column that you want to sort in ascending or descending order. See“Sort and Mo

DescriptionField or OptionNumber of rows from the histogram (accuracy depends on when statistics was lastupdated).Stats Row Count:Indicates the full s

— Launches the Neoview Command Interface (NCI)— Supports character sets for ISO, SJIS, or Unicode based on a single-client locale (onlyone character s

In the Partition Distribution Across Disks panel, you can:1. Select a value for Count in the drop-down box.2. Select a value for Delta from AVG in the

3. To activate the Table Growth panel, you can either:• Double-click a bar in the graph of the SQL Objects panel• Double-click a row in the SQL Object

1. Select a date range for the graph using the drop-down boxes. By default, the By Table datagrid fetches table details for the last quarter. You can

Top Fastest Growing Tables TabThe Top Fastest Growing Tables tab allows you to view the top fastest growing tables (in bytesper second) and specify a

DescriptionField or OptionSpecifies the object name space as:• CN—Constraint• IX—Index• LK—Lock• TA—Table value object (table, view, stored procedure,

About the General TabThe General tab includes group:• “Inventory Control ” (page 145)• “Inventory Process Detail Status” (page 147)Inventory ControlTh

DescriptionField or OptionResumes the inventory.[ Resume ]Stops the inventory.[ Stop ]Obtains status and displays the progress at the bottom of the sc

The references are verified upon startup after initial logon and also verified each time you switchto another already connected system. If any of the

Inventory OptionsIn the Inventory Options group, these options can be selected in the drop-down box:DescriptionField or OptionNumber of parallel proce

About Space Management Tracing OptionsThe Space Management Options dialog box shows tracing controls for Space Management.These tracing controls are f

• From the Start menu, select Start > All Programs > HP Database Manager > HP DatabaseManager.NOTE: Most HPDM features require you to connect

150

Glossaryactive command A command used by the System Offender to query the database (for example, STATUS CPUPROCESS ALL) for offending processes. The a

My OtherSystemsThe group of Neoview platforms that are defined but not currently connected. For moreinformation, see “Understand My Other Systems ” (p

IndexSymbols100% settings, 8321034, event message, 4021035, event message, 41AAbout box, 33, 128ACKNOWLEDGED value, alerts, 95Active commanddefined, 1

reusing, 120Connectivity icon, 81Console history, clearing, 97Console tabdescription of, 97showing and hiding, 97Copy command, 114CPU, 106CPU Busy, 78

IImport Persistence command, 15Information, new and changed, 9Installationdownloading installer, 14instructions, 14requirements, 14IR_DELIVERED_LCT_TS

OODBC connection, testing, 23ODBC driver requirement, 14Offending processesabout, 99defined, 152Online help build date, 9OS requirement, 14PParameters

Schema, defaultAdd System dialog box, 21Edit System dialog box, 18Schemasattributes tab, 48DDL tab, 49displaying, 47materialized view groups tab, 48ma

active command, 110altering parameters for, 109context menu, 102controlling refresh of, 110data grid, example, 101data grid, searching, 116defined, 15

159

16

2 Connect and DisconnectConnect to a SystemIf this is the first time you are attempting to connect to a system, you must create a systemdefinition. Se

DescriptionFieldsYour user name.User NameYour Neoview password.PasswordThe DNS name or IP address for the target Neoview platform.HostThe NDCS server

TermsdisconnectSystems ToolLog On and OffYou log on to HPDM as part of connecting to a system. See “Connect to a System” (page 17). Toconnect to a sys

© Copyright 2010 Hewlett-Packard Development Company, L.P.Legal NoticeConfidential computer software. Valid license from HP required for possession, u

The button options for the Systems Tool are:FunctionButtonTests a selected system and displays the results in the Connection Test Resultdialog box. [

3. Click one of these buttons:NOTE: Once a system is added, the system definition persists from session to session unlessit is removed.DescriptionButt

In the Add System dialog box, these buttons allow you to add a new system, add and connectto a new system, or cancel the operation.DescriptionButtonCr

Add a System Like...To add a system by modifying a copy of another system definition:1. Use either of these methods to open the Add System Like dialog

1. Connect to the system as described in “Connect to a System” (page 17).2. In the My Active Systems folder, right-click the system, and select Test S

3 Navigate HPDMSee the Parts of the HPDM InterfaceRelated Topics“Use the Navigation Tree Pane” (page 27)“Use the Right Pane” (page 29)“Use the My Favo

Areas are broad categories of features that you can monitor or manage using HPDM. Thesupported areas are:DescriptionAreaProvides information about SQL

To hide an area:1. Deselect the option for the area in the Show/Hide Area Options group box.2. Click [ OK ].To show an area that is hidden:1. Select t

To display the My Active Systems folder options, right-click the My Active Systems heading.The options are:DescriptionMenu ItemOpens the New Favorite

To display the My Other Systems folder options, right-click the My Other Systems folder andthe options are:DescriptionMenu ItemOpens the New Favorite

Table of ContentsLearn About This Document...9Publishing H

When My Active Systems or My Other Systems are selected, the buttons that are displayedin the bottom right pane are:FunctionButtonTests a selected sys

Create a FavoriteTo create a favorite, use either of these methods:• Drag and drop an object into the My Favorites pane:1. Optional: If you want the f

1. If necessary, create the folder. See “Create a Folder to Store Favorites” (page 31).2. Create a favorite in the desired folder by performing the st

To open the Windows Manager, select Windows > Windows Manager from the menu bar. TheWindows Manager buttons are:DescriptionButtonMoves the selected

34

4 Perform Basic HPDM OperationsSort and Move Data ColumnsYou might want to see rows in an HPDM display (for example, a list of schemas) grouped by asp

2. Repeat as necessary until the columns are arranged the way you want them.Clone a TabHPDM allows you to clone some tabs in a new window. This featur

Save Data to a Spreadsheet[ Data to Spreadsheet ] transparently saves the table data to a temporary local file in standardHTML table format and then e

Navigate the System Message TabThe navigation of the System Message tab contains a tree of active and other systems. The rightpane displays the system

Clone the System Message TabIf you double-click on the System Message tab, the control is cloned into a new window. Whenthe contents of the system mes

Customize HPDM Windows...32Manage Windows

persistence filesystem definitionSystems ToolView Event MessagesView Dial Out and Database EventsYou can view dial out and database events with any ar

AttributeParameterMessages too large for one message template are divided into smaller messages. Sequencenumber indicates which part of the message yo

Session Statistics: Connection InformationSession statistics are written to the alternate EMS collector at the time the connection is made(listed in t

DescriptionStatisticTotal number of SQL SELECT statements sent by the HP ODBC driver to the NDCSSQL server; does not include internally generated SQL

DescriptionStatisticExecute error code, if any. A zero (0) indicates that the execute was successful.ErrorCodeCumulative number of rows accessed.RowsA

Statement Statistics: SQLPrepareSQLPrepare statistics are written to the alternate EMS collector at the time a PREPARE statementis received (listed in

46

5 Manage Database ObjectsThis section describes how to display schemas, tables, table indexes, views, materialized views,materialized view indexes, ma

Attributes TabTo display the schema attributes and values that belong to the schema:1. Navigate to the Schema folder and click the name of the schema

Views TabTo display the views that belong to the schema:1. Select aSchema in the navigation tree.2. Click the Views tab in the right pane, or open the

Usage Tab...53DD

Privileges TabTo display the privilege information for the schema:1. Select a Schema in the navigation tree.2. Click the Privileges tab in the right p

In the right pane, these tabs appear:• Columns tab• Primary Key tab• Hash Key tab• Unique Constraints tab• Foreign Keys tab• Attributes tab• Partition

Primary Key: Specifies the icon or special symbol to indicate column is part of theprimary key.•• Column Name: Name of the column (string).• Data Type

1. Select a Schema in the navigation tree and click the table name in the right pane, or openthe Tables folder and select a table name in the tree.2.

1. Select a Schema in the navigation tree and click the table name in the right pane, or openthe Tables folder and select a table name in the tree.2.

• Grant Level: The level at which the permissions are visible. The values displayed in thiscolumn are: Schema, Object, or Column.— Schema indicates pe

In the right pane, these tabs appear:• Columns tab• Attributes tab• DDL tab• Partitions tabColumns TabTo display the table index columns:1. Select a S

• Populated: Specifies if the index has been populated, the value is “Yes” or “No.”• Creation Time: Time and date when the table index was created. Ti

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

• 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

See the Parts of the System Monitor...77Understand t

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

• DDL tab• Privileges tabAttributes TabTo display the materialized view attributes:1. Navigate to the Schema in the navigation tree2. Click the Materi

• Creation Time: Time and date when the materialized view was created. Timestamp isin the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).• Redefinitio

For more information about displaying DDL, see “Display Schema DDL and Their Properties”(page 73).Privileges TabTo display the privileges for the mate

4. Select a Schema in the navigation tree.5. Open the Materialized Views folder, select and open a Materialized View.6. Open the Indexes folder and se

For more information about displaying DDL, see “Display Schema DDL and Their Properties”(page 73).Partitions TabTo display partition information for a

In the right pane, these tabs appear:• Attributes tab• Members tab• DDL tabAttributes TabTo display the materialized view groups attributes:1. Select

1. Select a Schema in the navigation tree.2. Click the Materialized View Groups tab in the right pane, or open the Materialized ViewGroups folder and

In the right pane, these tabs appear:• Attributes tab• Parameters tab• Privileges tabAttributes TabTo display the procedure names and attributes:1. Se

Parameters TabTo display the procedure parameter information:1. Select a Schema in the navigation tree.2. Click the Procedures tab in the right pane a

10 Use the SQL Whiteboard...117About the SQL Whiteboard...

4. Select a Schema in the navigation tree.5. Click the Synonyms tab in the right pane and select a synonym name, or open the Synonymsfolder and select

1. Select a Schema in the navigation tree.2. Click the Synonyms tab in the right pane and select a synonym name, or open the Synonymsfolder and select

In the right pane, these tabs appear:• Attributes tab• Usage tab• DDL tabAttributes TabTo display the trigger attributes:1. Select a Schema in the nav

Usage TabTo display the trigger usage information:1. Select a Schema in the navigation tree and click the table name in the right pane, or openthe Tab

The external format of the Show DDL output is displayed. For more information on the formatof the Show DDL command, see the Neoview SQL Reference Manu

• 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:Description

3. Select a Schema in the navigation tree.4. Click the Statistics tab in the right pane.The Statistics tab displays the histogram statistics for the t

6 Use the System MonitorDisplay the System MonitorThe system monitor is a tool within HPDM that displays status and performance data for theNeoview pl

Related Topics“Configure System Monitor Options” (page 82)“Understand the Performance Metrics” (page 78)“Understand the System Status Icons” (page 80)

“Use Tooltips to Show the Value of a Performance Metric” (page 79)Use Tooltips to Show the Value of a Performance MetricWhen the system monitor bar gr

Index...1538 Table of Cont

About the Hybrid TabThe Hybrid tab shows a bar graph and a set of timelines side by side:Related Topics“About the Timeline Tab” (page 79)“Configure Sy

This table describes the icons:DescriptionIconIcon for the association servers. Indicates if $MXOAS and $MXAS2 are running.$MXOAS is the component of

For more information about the Alerts icon, see “Get Information About Alerts” (page 89).Related Topics“Understand the System Status Icons” (page 80)“

This table describes the system monitor options and settings:DescriptionOption or SettingThis option shows the Port Number for connecting to the Neovi

DescriptionOption or SettingOptions that control the bar color for the mouse-over, threshold-exceeded, andCPU-down conditions. See “Change a Color Opt

“Configure System Monitor Options” (page 82)TermssegmentChange a Color OptionColor options appear as bar/line-color buttons in the system monitor opti

86

7 Respond to AlertsDisplay the Alerts TabNOTE: Diagnostic information displayed by the Alerts tab is intended for use by HP support.This information i

Understand AlertsNOTE: Diagnostic information displayed by the Alerts tab is intended for use by HP support.This information is not documented for cus

If the current user has update privileges, the ALARM_STATUS column in the Alerts data griddisplays a menu with selectable update states (ACKNOWLEDGED

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

DescriptionAlerts Icon ColorAt least one OPEN or ACKNOWLEDGED alert is present and has a WARN alert level.YellowNo ERROR or WARN alerts are present, b

DescriptionFieldThe delivery status of an incident report (IR). Possible values are:CREATED, DELIVERED, FAILED DELIVERY, and UNKNOWN. Thiscolumn indic

TermsalertsegmentUse the Alerts Options Dialog BoxTo display the Alerts Options dialog box:1. Display the Alerts tab, as described in “Display the Ale

DescriptionOption or ControlSpecifies the interval for which data is fetched in the server-side local civil time(LCT). By default, the Alerts data gri

To do thisClick this button . . .Stop the refresh.Stop Data ProviderRefresh the Alerts data grid at any time.Refresh DataPause the refresh.Pause Timer

2. In the Alerts data grid, right-click any alert (or multiple alerts), and select Update Alert(s).The Update Alert dialog box appears.This table desc

2. Click the [ Apply ] button at the bottom of the Alerts tab:• Use the steps for updating multiple alerts, but select only one row to update.Related

4. Click the [ Apply ] button at the bottom of the Alerts tab to send the changes to the server.Related Topics“Update an Alert” (page 95)About the Con

98

8 Find Offending Processes and QueriesAbout System OffenderSystem Offender is a tool that allows you to monitor system resources and detect processes