Hp Neoview Release 2.5 Software Manual de usuario Pagina 1

HP Database Manager (HPDM) User GuideHP Part Number: 613120-001Published: July 2010Edition: HP Neoview Release 2.5

Launch Metric Miner...220See th

1. Log on as a user in the ROLE.MGR role. For more information about logging on, see “Connectto a System” (page 25).2. Select the Security area. For m

NOTE: The [ Change Password ] button is active only if you have sufficient privileges tochange the password for the selected role.6. Fill in the field

102

8 Manage Users and PasswordsAbout UsersThe Neoview platform has several different types of users:A person or application that can use a Neoview client

3. In the navigation tree pane, expand the folder for the logged on system, and select theDatabase User s folder. The right pane displays all database

database userremotely authenticated database userUse the Add Database User Dialog BoxThis table describes the fields in the Add Database User dialog b

“Use the Select User Role Dialog Box” (page 106)“Control the Display of the Add Database User Dialog Box” (page 108)Termsrolelocally authenticated dat

7. Click [ OK ].Related Topics“About Users” (page 103)“Add a Database User” (page 104)“Use the Add Multiple Database Users Dialog Box” (page 107)Terms

3. In the navigation tree pane, expand the folder for the logged on system, and select theDatabase Users folder. The right pane displays all database

remotely authenticated database userChange Role or Password Information for a Database UserEditing a database user allows you to change the default ro

View Table Growth...257By Ta

NOTE: If the selected database user is remotely authenticated, a truncated version of the dialogbox is displayed, showing only the User Name, Default

Delete One or More Database UsersYou must be a user in the role of ROLE.MGR to delete a database user. Note that this action doesnot delete a remotely

3. In the navigation tree pane, expand the folder for the logged on system, and select thePlatform Users folder. The right pane displays all platform

1. Log on as a user belonging to ROLE.SECMGR.2. Select the Security area. For information about how to select an area, “Select an Area”(page 35).3. In

DescriptionFieldGroup BoxThe interval that controls password expiration. This is thenumber of days, from the time the password is changed,after which

5. Fill in the fields of the Edit User dialog box. For more information about each field, see “Usethe Add Platform User (or Edit User) Dialog Box” (pa

Fill in the fields in the dialog box, as described in “Use the Change Password Dialog Box”(page 116).If your old password has expired and the security

9 Manage Security PoliciesAbout Security PoliciesVarious behaviors related to user management and security depend on policies that the SecurityAdminis

4. In the right pane, select the desired tab for the policy you want to change. For moreinformation about each policy, see these topics:• “Use the Cer

This table describes the function of buttons that appear at the bottom of the policies tabs:DescriptionButtonUpdates the display.[ Refresh ]Sets all f

12

DescriptionOptionSpecifies whether login requests are accepted from clients that do not provide passwordencryption. Clients earlier than Neoview Relea

DescriptionOptionPolicyNumber of previous passwords retained to prevent a user fromrepeating a previous password (for example, a value of 10 meansthat

This table shows reference information for the Logging tab for security policies:DescriptionOptionSpecifies whether to log user management actions, su

DescriptionOptionPolicy or User TypeWhen selected, specifies that ROLE.SECMGR, ROLE.MGR, andROLE.DBA users must provide an individual password and aro

124

10 Manage CertificatesAbout CertificatesThe current release of the Neoview platform allows you to use either a self-signed certificate ora certificate

3. In the navigation tree pane, under the connected system, expand the Credentials folder,and click the Self-Signed Certificate folder. The Self-Signe

NOTE: If possible, use facilities provided by the CA to specify Subject Alternate Names(SANs) for all segments, or at least for all secondary segments

“Display Security Policies” (page 117)Use the Generate CSR TabThis table shows reference information for the Generate CSR tab:DescriptionExampleFieldI

Related Topics“Use the Deploy CA Signed Certificate Tab” (page 129)“Display Security Policies” (page 117)“About the Auto Download Certificate Option”

About This GuideThis guide describes how to use the HP Database Manager (HPDM) to monitor and manage aNeoview Data Warehousing Platform for Business I

130

11 Manage Directory ServersAbout Directory ServersYou can configure the Neoview security infrastructure to communicate with external LDAPservers. The

1. Log on as a user belonging to ROLE.SECMGR. For more information about logging on,see “Connect to a System” (page 25).2. Select the Security area. F

DescriptionRangeFieldThe host name or IP address of the LDAP server. This value is atext field with the following characteristics:• The field can cont

DescriptionRangeFieldParameters that apply to all servers. To add a row in theParameters grid, right-click and select Add Row. To delete a row,select

by default if no value is specified when an individual server is configured. Parameters areserver-specific and can be different on different servers o

• LDAP directory server• Global Catalog for an Active Directory server• Domain Controller for an Active Directory serverAdding a Domain Controller for

Adding a Domain Controller foran Active Directory ServerAdding a Global Catalog for anActive Directory ServerAdding an LDAP DirectoryServerConsiderati

Example ValueFieldTLSEncryption Optionc:\ldap\hpca2ssCertificateRelated Topics“Add a Directory Server” (page 131)“Use the Add Directory Server Dialog

Second Domain ControllerFirst Domain ControllerFieldDOMAINBDOMAINADomain Namedc02.domainb.cup.hp.comdc01.domaina.cup.hp.comHost Name389389Host Port Nu

— “Use the Windows Menu Options” (page 43)— “Use the Help Menu Options” (page 43)— “Use the HPDM Toolbar” (page 44)— Updated the illustration in “Get

Copy a Configured Directory ServerTo use the attributes of a currently configured directory server to create a new directory serverconfiguration:1. Di

12 Manage Data SourcesDisplay Data SourcesAny user can display all data sources. To display all data sources:1. Under the navigation tree pane, click

3. In the navigation tree pane, click a named data source. Detailed information about the datasource appears in the right pane. This table describes t

NOTE:Some tabs provide tooltips that describe the use of an option or the range of values supportedfor a field. For example:5. When you are finished,

DescriptionOption or Check BoxGroup BoxThe number of minutes that a client-server connection remains idle beforethe NDCS server terminates the connect

DescriptionOption or Check BoxGroup BoxStatistics about individual SQL statements. For more information, see“Statement Statistics: SQL Statement” (pag

Understand Processing-Node NumberingThis table shows the processing-node numbers for each segment in a Neoview platform. For an8-segment Neoview platf

NOTE: You can enter only one resource management policy for each attribute name.Clicking [ Add ] or [ Modify ] displays a dialog box with these fields

SET variables are stored as part of the configuration data for the data source. They are retrievedby the association server when it reads the startup

3. Click the Control Query Defaults tab.4. Click [ Add ] or [ Modify ].5. In the CQD Name field, enter a new name or change the existing name.6. In th

Related DocumentationThis guide is part of the HP Neoview library, which includes:• “Neoview Customer Library” (page 15)Neoview Customer LibraryThe ma

Priority Option of Controlled Tables TabPossible values are 1 through 9. Specify a higher priority for short-duration OLTP-type requestsrunning with c

4. Modify the information in these tabs, as necessary:• “Use the General Properties Tab” (page 143).NOTE: You must change the data source name. If you

2. In the navigation tree pane, find the system that contains the data source(s) that you wantto stop. Expand the system to display the list of data s

NOTE: You cannot delete the two default data sources (TDM_Default_DataSource andAdmin_Load_DataSource).A data source must be stopped before you can de

154

13 Manage ConnectivityDisplay NDCS ServersAny user can display NDCS servers. To display all NDCS servers for a system:1. Under the navigation tree pan

DescriptionFieldOperating system process name of the server. This field is visible only to roles thathave OPERATOR privileges.Process NameNDCS service

Stop an NDCS ServerRequirement: Only roles that have OPERATOR privileges can perform management tasks.To stop an NDCS server:1. Under the navigation t

4. In the right pane, click the NDCS Services tab to display detailed information about theassociation and configuration servers:This table describes

• Association server• Configuration server• Data sources configured with the automatic startup optionIf the NDCS service state does not change to the

Information about using Neoview Workload Management Services (WMS) tomanage workload and resources on a Neoview data warehousing platform.Neoview Work

Start and Stop Server TracesRequirement: Only roles that have OPERATOR privileges can perform management tasks.To start tracing for a data source:1. U

14 Manage NDCS PrivilegesDisplay NDCS PrivilegesNDCS privileges define the type of access that the members of a role have to data sourceconfigurations

1. Under My Systems, select the system having the role for which you want to grant privileges.2. In HPDM, select the Connectivity area. For more infor

15 Manage ProceduresDisplay ProceduresSee “Display Procedures and Their Properties” (page 84).Upload a JAR FileThis procedure uploads an SPJ JAR file

Download a JAR FileThis procedure downloads one or more SPJ JAR files from the Neoview platform to a clientworkstation. When you download a JAR file t

NOTE: You can rename only one JAR file at a time.TIP: To select a row, click the File Size value rather than the File Name. If you click theFile Name,

• You must be the owner of the schema or have SUPER.SUPER or SUPER.SERVICES privileges,and have read access to the .jar file that contains the SPJ Jav

is 1 to 255 inclusive. The actual number of result sets returned by the SPJ method can be lessthan or equal to this number.NOTE: The Number of dynamic

ActionControl or FieldGroup BoxControls the maximum number of result sets the procedure can return. Thiscontrol is enabled only if the method signatur

TypeParameter Typeor Class“short”primitive“short[]”“int”“int[]”“long”“long[]”“float”“float[]”“double”“double[]”“java.sql.ResultSet[]”result setsFor mo

Resources on the WebNeoview Customer Documentationhttp://www.hp.com/go/neoviewdocsHP Software Depothttp://www.software.hp.com/Send Feedback to HPHP en

170

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

Related Topics“Configure System Monitor Options” (page 176)“Understand the Performance Metrics” (page 172)“Understand the System Status Icons” (page 1

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

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 173)“Configure S

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 183).Related Topics“Understand the System Status Icons” (page 174

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 176)TermssegmentChange a Color OptionColor options appear as bar/line-color buttons in the system monitor opt

18

180

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

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

are not found, HPDM checks to see if the user has update privileges on the ALARM_STATUScolumn.If the current user has update privileges, the ALARM_STA

Unlike the Connectivity, Disks, and Transactions icons, the Alerts icon requires an ODBCconnection to fetch the alerts status. This table describes ho

DescriptionFieldNotes about the alarm that can only be added manually by an HPDMoperator.ALARM_NOTESThe likely cause of the alarm.ALARM_PROBABLE_CAUSE

DescriptionFieldThe timestamp in local civil time (LCT) when the incident report was lastupdated.IR_LAST_UPDATE_LCT_TS*Always blank (for future use).I

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 System Offender data grid at any time.Refresh DataPause the refresh.Pa

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

1 About HPDMWhat Is HPDM?The HP Database Manager (HPDM) is an integrated graphical client that allows you to connectto and manage multiple HP Neoview

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 189)About the Co

192

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

See the Parts of the System OffenderRelated Topics“Understand System Offender Privileges” (page 194)“Find Offending Processes and Queries” (page 194)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

that spawned another process (a parent process). These commands are available only toadministrator users.To obtain Pstate information:1. Display the S

DescriptionField or OptionThe process that spawned the children processes described in the Detail tab.Parent ProcessControls which processes are displ

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

• HPDM Framework— Provides connection management for widgets— Supports persistence for widget and application data— Includes menu management— Implemen

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

DescriptionFieldGroup BoxThe total time that the query ran or is running (that is, the elapsed time),plus any time that the query spent in the waiting

DescriptionFieldGroup BoxEstimated total amount of processor (CPU) timeCPUEstimated total amount of I/O timeI/OEstimated total amount of messaging tim

Runtime StatisticsDescriptionFieldGroup BoxType of SQL statementStatement TypeInfoStatement identifier of the query, which is part of the query IDStat

DescriptionFieldGroup BoxTimestamp when the first row was returned from the root operator ofthe master executor process. A value of -1 means that the

DescriptionFieldGroup BoxTotal amount of processor (CPU) time used by the query in the previousrefresh interval. The display format is hh:mm:ss.sss fo

Alter System Offender ParametersTo display the Alter Offender Parameters dialog box and alter the parameters:1. Display the System Offender tab, as de

A refresh timer controls the refresh interval. When an update is in progress, the refresh timer ispaused.If the update completes successfully, the ref

• Support for stored procedures in Java (SPJs)— Display a list of jar files uploaded by users in your current role— Display a list of classes in a jar

3. Select a refresh interval. The timer status bar counts down the new refresh interval in seconds.Suppose the refresh timer is set to a low value (fo

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

Related Topics“Learn About the Statement List Pane” (page 212)“Learn About the Statement Pane” (page 213)“Learn About the Statement Details Pane” (pag

The buttons across the top of the Statement List pane allow you to select individual statementsor select all statements to be executed:FunctionButtonS

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

• Regardless of whether the number of rows in the result set exceeds the Rows/Page threshold,if the available virtual memory falls below the internal

are shown only for statements that are loaded from the Statement pane. The values in theStatement Details pane are:The Execution Results tab displays

a specified text file. To import or export SQL statements, use these commands from the Filemenu:DescriptionCommandReads the text of an SQL statement f

218

20 Use Metric MinerAbout Metric MinerMetric Miner is an HPDM utility that allows you to:• Execute a SQL statement or query and view the results within

22

Related Topics“About Metric Miner” (page 219)“About the SQL Whiteboard” (page 211)TermsMetric MinerLaunch Metric MinerAny user can launch Metric Miner

The user input fields, including the SQL Input Area and the Report Results Area occupy themiddle panes of the Metric Miner window:The Status, Descript

Related Topics“Use the Metric Miner Toolbar” (page 222)“Learn About the SQL Whiteboard Panes” (page 211)Use the Metric Miner ToolbarMetric Miner toolb

See for More InformationFunctionButton“Cancel a Query From Metric Miner” (page 227)Stop the refresh (cancel the query).Stop data provider“Control the

Create Report FoldersCreate a Report FolderBefore you start using Metric Miner, create a report folder. A report folder is any folder thatcontains rep

Run StatementsRun a SQL Statement Using Metric MinerUsing Metric Miner, you can run SQL statements in much the same way that you can run themby using

1. At the top of the dialog box, select a schema from the Schema drop-down menu. The SQLDesigner populates the Tables/Views field based on the schema

User_name as User_Name, query_start_datetime as Start_time, query_end_datetime as end_time, Datasource as datasource, start_priority as Pri, ro

“Use the Metric Miner Toolbar” (page 222)“Resolve Out-of-Memory Errors” (page 228)Resolve Out-of-Memory ErrorsMetric Miner allows you to submit querie

To set the refresh interval, click the Set Refresh Time button ( ), and select a refresh interval.NOTE: Once you select a refresh interval, the statem

2 Install and Start HPDMInstall the HP Database ManagerThe HP Database Manager is installed with a Windows installer. You can install the client byits

Create and Manage ReportsCreate a ReportReports that you create and store on a workstation:• Are available to all users of the same workstation.• Can

Use the Report Configuration Dialog BoxThis table describes the fields in the Report Configuration dialog box:DescriptionFieldGroupTabSpecify the name

Related Topics“Create a Report” (page 230)“Create a Report Folder” (page 224)Display and Run a Saved ReportWhen you display a saved report, Metric Min

Close a ReportTo close the currently active report, click the button to close a report ( ).To close all report tabs, click the button to close all rep

“Use the Metric Miner Toolbar” (page 222)“Create a Report” (page 230)Share a Report With Another UserAll reports residing on a workstation are availab

Link and Drill DownLink Reports in Metric MinerSuppose you have a series of reports, and some of them require input parameters. And supposevarious col

Use the Select Report Dialog BoxThis table describes the fields in the Select Report dialog box:DescriptionFieldLists the reports that are linked to t

1. Display (open the tab for) the calling report. This is the report whose result data will bepassed to the called report. For more information about

238

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

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

Set Auto Logon OptionsTo set the NCI auto logon features, click the Options button ( ) on the HPDM toolbar, or selectTools > Options from the HPDM

22 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

See the Parts of Space ManagementSpace Management shows SQL space usage statistics for a Neoview system, including SQLobjects, partition distribution

244 Manage Disk Space

Related Topics“About the Monitoring Tab” (page 246)Understand Space Usage StatisticsSpace Management shows six panes of detailed SQL space usage stati

DescriptionPaneDetailed grid view of the SQL objects within the schema.SQL Objects DetailBar graph view of the partition distribution across all disks

To display the Over Threshold Summary, display the Monitoring tab, and click the doublearrows at the top of the Logical Space tab:The Over Threshold S

Use [ Refresh ] to refresh the Over Threshold Summary data grid.To change the sort order of a displayed column:• Click the title of the column that yo

This figure shows a snapshot of the System Overall pane and the free space available:In the System Overall pane, you can:1. Select a value for Type in

3 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

From the Space Management area:1. Select a system you wish to view details about.2. Click the Monitoring tab.3. View the System Detail pane. Click the

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 53).[ 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 pane, these fields can be selecte

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

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

In the Partition Distribution Across Disks pane, 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 pane, you can either:• Double-click a bar in the graph of the SQL Objects pane• Double-click a row in the SQL Objects

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

Use the Connect / Edit System Dialog BoxThis table shows reference information for the Connect / Edit System dialog box:DescriptionExampleFieldA label

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 these groups:• “Inventory Control ” (page 262)• “Inventory Process Detail Status” (page 264)Inventory Co

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

System Registry Table TabThis figure displays the System Registry Table tab:About Space Management Tracing OptionsThe Space Management Options dialog

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

disconnect Since connections are transient, there is no concept of logging on or logging off. The HPDMequivalent of logon is making a system usable by

operator privilege An NDCS privilege that allows a user to perform administrative tasks, such as managing datasource configurations, NDCS services, da

In the Connect / Edit System dialog box, these buttons allow you to add a new system definition,connect to a system, or close the system definition.De

schema, and ODBC driver version. The banner displays the system definition. See “See theHPDM Banner” (page 41).system monitor The system monitor is a

IndexSymbols100% settings, 17721034, event message, 5621035, event message, 57AAbort Change Password if Logging Fails option, 122Abort Database Login

Association serverscomparing MXOAS and MXAS2, 156defined, 267Attributes tabmaterialized view groups, 84materialized view indexes, 81materialized views

Create time (role), 95Created by (role), 95Cut commandEdit menu, 42SQL Whiteboard, 215System Message, 54toolbar button, 44DData columns, sorting and m

Edit menu options, 42Edit Platform User dialog box, 113Edit SET dialog box, 148Edit User dialog box, 109Editing a system, 32EID Heap Alloc, Workload D

IR_DETECTED_UTC_TS, 185IR_ID, 185IR_LAST_UPDATE_LCT_TS, 186IR_LAST_UPDATE_UTC_TS, 185IR_NOTES, 186IR_SEGMENT, 185IR_SEVERITY, 185IR_STATUS, 185JJAR fi

Space Management, 246System Monitor, 171Mouse-over color, 178Multicolumn sorting, 48MXAS2defined, 268function of, 156MXOASdefined, 268function of, 156

Parent Pstate dialog box, 197Parent QID, Workload Detail dialog box, 205PARENT SEGMENT, 200Partitions tabmaterialized view indexes, 82materialized vie

defined, 269finding an offending, 194runaway, 194workload information, 201QUERY ID, 200Query ID, Workload Detail dialog box, 203QUERY NAME, 201QUERY T

Schema, defaultAdd System dialog box, 31Connect / Edit System dialog box, 26SQL Whiteboard, 213Schemasattributes tab, 64DDL tab, 65displaying, 63mater

1. Enter the Disconnect command by using one of these methods:• In the navigation tree pane, right-click the icon for the connected system, and select

data source configuration, 145understanding, 61SQLPrepare statisticsdata source configuration, 145understanding, 61Start AheadData Source Status, 142D

privileges tab, 70size, displaying, 71statistics tab, 70summary information for, 71tab, 64unique constraints tab, 68usage tab, 69Tabscloning, 46workin

Windowscloning, 46managing in HPDM, 45menu options, 43working with, 45Windows Managermenu option, 43toolbar button, 44using, 45Word Wrap command, 215W

283

The Systems Tool window displays these settings:DescriptionSettingThe current state of the system definition (Connected or Disconnected).StateThe labe

Table of ContentsAbout This Guide...13Publis

NOTE: HPDM can connect to platforms running Neoview Release 2.3 and later. However, notall features available in the current release are available in

DescriptionExampleFieldNeoview role. Note these considerations:• If you are a platform user, leave this field blank.• If you are a database user and y

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 copying another system definition:1. Use either of these methods to open the Add System Like dialog box:• In th

2. Right-click the system icon, and select Test System.• Initiate a test from the Systems Tool:1. Connect to the system as described in “Connect to a

4 Navigate HPDMSee the Parts of the HPDM InterfaceRelated Topics“Use the HPDM Toolbar” (page 44)“See the HPDM Banner” (page 41)“Use the Navigation Tre

See for More InformationDescriptionArea“Manage Disk Space” (page 241)Provides information about SQL-space usage onthe system.Space Management“Manage C

TermsareaControl the Display of an AreaBy default, HPDM displays all of the areas that the currently installed server software supportsdisplaying. How

When the Database area is selected, the navigation tree pane allows you to expand a connectedsystem, showing the database objects underneath it in hie

DescriptionOptionEdits an active system. See “Edit a System” (page 32).EditAdds a system like the selected system’s current settings. See “Add a Syste

Remove a Favorite...41Remove a

right panenavigation tree paneUse the My Favorites PaneA favorite is a shortcut to an object on the navigation tree pane. Favorites save you the troub

Create a Folder to Store FavoritesIn the My Favorites pane, you can create folders at the top level or folders within folders:1. In the My Favorites p

Use Menu Bar CommandsThe menu bar is the list of commands at the top of the HPDM main window. The menu barcommands are: File, Edit, Tools, Windows, an

DescriptionMenu OptionInsert the selected text at the cursor position.PasteHighlight all text.Select AllRelated Topics“Use Menu Bar Commands” (page 42

DescriptionMenu OptionOpens the HPDM online help and displays the Search tab.SearchDisplays the About dialog box. See “Get Version and Build Informati

See for More InformationFunctionButton“About Metric Miner” (page 219)Displays the Metric Miner, allowing youto configure, execute, and organizereports

To open the Windows Manager, click the Windows Manager button ( ) on the HPDM toolbar,or select Windows > Windows Manager from the menu bar. The Wi

5 Perform Basic HPDM OperationsGet Version and Build InformationVersion and build information appears in the About HP Database Manager box. To access

To change the sort order of a displayed column:• Click the title of the column that you want to sort. A triangle appears to the right of theheading to

display information in a data grid. The data grid is a simple table with columns and some specialfeatures for displaying and manipulating data. Data g

Materialized Views Tab...64Materialize

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 Ctrl key, and select the cells youwant to copy. Then right-click, and select Copy:The cell va

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

Export DataExport Data to the Clipboard[ Data to Clipboard ] saves the data to the clipboard. Each value is a double-quoted string. Theclipboard can t

Use the System Message TabThe System Message tab contains a system message control to convey information to users. Thesystem message can be updated by

Clone the System Message TabIf you double-click the System Message tab, the control is cloned into a new window. When thecontents of the system messag

“Use Menu Bar Commands” (page 42)“Use the HPDM Toolbar” (page 44)Termspersistence filesystem definitionSystems ToolView Event MessagesView Dial Out an

Message 21034AttributeParameterSession ID: session-idFunction: EnterfunctionSequence Number: sequence-numberfunction-input-parametersorSession ID: ses

21035See above.Cause A resource statistics informational message.Effect NoneRecovery Informational message only; no corrective action is needed.Sessio

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

Attributes Tab...88Usag

DescriptionStatisticTotal NDCS SQL server real time, in microseconds, from the time the execute startedto the time the results are sent back.ODBCElaps

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

62

6 Display Database ObjectsThis section describes how to display schemas, tables, table indexes, views, materialized views,materialized view indexes, m

• DDL tab• Privileges tabAttributes TabTo display the schema attributes and values that belong to the schema:1. Navigate to the Schema folder and clic

Name: Name of the materialized view group. Each materialized view group ishyperlinked and detailed information about the materialized view group is di

1. Select a Schema in the navigation tree.2. Click the DDL tab in the right pane.The DDL tab displays DDL output from the SHOWDDL command in the right

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

1. Select a Schema and table and click the table name in the right pane, or open the Tablesfolder and select a table name in the tree.2. Click the Col

Foreign Keys TabTo display the foreign keys information on the table:1. Select a Schema in the navigation tree and click the table name in the right p

Use the Change Password Dialog Box...116Change a Password or P

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

1. Select a Schema in the navigation tree.2. Click the Tables folder and open the Indexes folder and select an index name.3. Click the Attributes tab

The detailed summary is a snapshot of the indexes (tables indexes and materialized view indexes)in the schema at the timestamp shown at the top of the

1. Select a Schema in the navigation tree.2. Click the Views tab, or open the Views folder and select a view.3. Click the Columns tab in the right pan

1. Select a Schema in the navigation tree.2. Click the Views tab, or open the Views folder and select a view.3. Click the Privileges tab in the right

In the right pane, these tabs appear:• Attributes tab• Partitions tab• Usage tab• DDL tab• Privileges tabAttributes TabTo display the materialized vie

RecomputeDerives the materialized view from scratch. This is used on the initial refresh ofthe materialized view and also to re-derive the materialize

• Max Size: The maximum size in bytes of the partition.• Current EOF: The current data size of the partition in bytes.Usage TabTo display materialized

Timeout Option of Controlled Tables Tab...150Copy a Data Source...

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

In the right pane, these tabs appear:• Columns tab (user only)• Attributes tab• DDL tab• Partitions tabColumns TabTo display the materialized view ind

Name: Name of the materialized view index.•• Unique: Specifies if the materialized view index is unique, the value is “Yes” or “No.”• Populated: Speci

The detailed summary is a snapshot of the materialized view in the schema at the timestampshown at the top of the table display. If you select [ Refre

Attributes TabTo display the materialized view groups attributes:1. Select a Schema in the navigation tree.2. Click the Materialized View Groups tab i

In the right pane, these tabs appear:• Attributes tab• Parameters tab• Usage tab• Privileges tabAttributes TabTo display the procedure names and attri

• Creation Time: Time and date when the procedure was created. Timestamp is in theformat (yyyy-MM-dd HH:mm:ss.FFFFFF local time).• Redefinition Time:

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

In the right pane, these tabs appear:• Attributes tab• Usage tab• DDL tabAttributes TabTo display the synonym names and attributes:1. Select a Schema

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

Get Information About Alerts...183Understand

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

• Creation Time: Time and date when the trigger was created. Timestamp is in the format(yyyy-MM-dd HH:mm:ss.FFFFFF local time).• Redefinition Time: Ti

• Synonym• TriggerDDL TabThe DDL tab displays DDL output from the Show DDL command in the right pane. You canhighlight and copy contents, but you cann

• 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

7 Manage RolesAbout RolesA role is a vehicle for assigning data-access privileges to user IDs. On the Neoview platform,data-access privileges are not

• [ Data to Spreadsheet ]• [ Data to File ]Related Topics“Display the Users Who Belong to a Role” (page 96)“Add a Role” (page 97)“Grant a Role to a Us

5. Click [ View SQL Privileges ]. The SQL Privileges dialog box appears, displaying thefollowing privilege information for the selected role:• SCHEMA

“Delete a Role” (page 98)Termsrolepower roleDelete a RoleBefore deleting a role, review these considerations:• To delete a role, you must be a user in

2. Select the Security area. For more information about areas, see “Select an Area” (page 35).3. In the navigation tree pane, select the Roles folder.