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
11 Launch the Neoview Command Interface (NCI)Learn About NCIThe Neoview platform supports a client-based utility, Neoview Command Interface (NCI), whi
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
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
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
Kommentare zu diesen Handbüchern