Hp Integrity NonStop J-Series Manuel d'utilisateur

HP NonStop MXDM User Guide for SQL/MXRelease 3.2HP Part Number: 691119-001Published: August 2012Edition: J06.14 and subsequent J-series RVUs; H06.25 a

The NSM/web, SQL/MX Database Manager, and Visual Query Planner help systems are accessiblefrom their respective applications. You can download the Ref

Statement paneThe Statement pane enables you to enter any SQL command (DDL or DML) in the text field. Themaximum number of characters you can enter in

Figure 39 Parameters dialogEnter a value, for example 1. The statement is executed, and the following tabs will appear inStatement Details dialog:• Ex

• When a statement is executed and the number of rows in the result set exceeds the Rows/Pagethreshold, statement execution happens in the page mode.

Table 32 Execution Results fieldsFunctionField or buttonIndicates when the statement was last evaluated.Last EvaluatedIndicates the time taken to exec

Table 34 File menu optionsFunctionMenu itemLoads the text of an SQL statement from an ASCII file to the Statement field.Load SQL StatementSaves the cu

Glossaryarea A broad category of features that you can manage or monitor using MXDM. See “Selecting anarea” (page 30).association server The logical c

SQL Whiteboard. In page mode, only a partial result of a query is held in memory and displayedin the Statement Details page. For more information, see

IndexAAboutbox, MXDM, 38command, Help menu, 29Add DEFINE dialog box, 85Add SET dialog box, 86Admin_Load_DataSourcestopping service for, 80Alertsdata g

Delimited identifiers, 83Disconnectingtoolbar button, 29Disconnecting (see also Connecting)defined, 105disconnecting (see also connecting)function, 21

Next Page buttondescription of, 103Statement Details pane, 102NodeMXCS Services, 79order, 84utilization, 84NonStop SQL/MX Remote Conversational Interf

| Vertical Line. A vertical line separates alternatives in a horizontal list that isenclosed in brackets or braces. For example:INSPECT { OFF | ON | S

statistics, 84SQL Whiteboardcanceling an SQL query, 102command, 29defined, 106displaying, 98executing hightlighted test, 102highlighting syntax, 104lo

1 Introduction to MXDMThis chapter discusses the following topics:• “Overview” (page 12)• “MXDM features and functionalities” (page 12)• “MXDM functio

◦ Open and save query text to a file.◦ Use parameters in queries.• MXDM Framework —enables you to perform the following:Manage multiple SQL/MX databas

Figure 1 MXDM functional flowThe following is the sequence of events involved in establishing the connection between MXDMand the server components, an

2 Installing and uninstalling MXDMThis chapter discusses the following topics:• “Supported version of SQL/MX” (page 15)• “Contents of the installation

NOTE: If you want to use RMXCI, you must install RMXCI and the JDBC T4 V32 driver.Installing MXDMThis section discusses the following topics:• “Instal

Before uninstalling MXDM, you must consider the following:• You do not have to uninstall the MXDM client before installing a newer version of MXDM.• U

3 Managing MXDM system objectsThis chapter discusses the following topics:• “Starting up MXDM” (page 18)• “Adding a system” (page 18)• “Connecting to

the objects. You can also use the Save Persistence option to save the system definition. Duringsubsequent attempts to connect to that system, the save

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

1. Open the Connect / Edit System dialog in one of the following ways:• In the navigation tree pane, right-click the system name, and select Connect..

Related Topics“Adding a system” (page 18)“Disconnecting from a system” (page 21)TermsMy SystemsSystems Toolsystem definitionDisconnecting from a syste

Figure 3 Systems Tool dialogTable 2 (page 22) describes the settings in the Systems Tool dialog.Table 2 Systems Tool settingsDescriptionSettingDisplay

Table 3 Systems Tool optionsDescriptionSettingEnables you to test a selected system and displays the results in the Connection Test Resultdialog. Test

2. In the Add System Like dialog:a. Specify a new name in the System Name field.b. Retain or modify the information specified in the fields of the sel

To set the connection timeout:1. Perform one of the following:• On the MXDM toolbar, click Options ( )• Select Tools→Options...The Options dialog app

4 Navigating MXDMThis chapter discusses the following topics:• “MXDM interface” (page 26)• “MXDM banner” (page 27)• “Using the MXDM menus” (page 27)•

Table 4 Parts of the MXDM interface (continued)DescriptionLabelNumberDisplays the selected area.Selected area5Favorites appear in the My Favorites pan

Using the File menu optionsTable 5 (page 28) describes the File menu options.Table 5 File menu optionsDescriptionOptionImports persistence data from a

Table 7 Tools menu optionsDescriptionOptionLaunches the SQL Whiteboard. For more information on SQL Whiteboard, see “Using theSQL Whiteboard” (page 98

ContentsAbout this guide...7Publishing history...

Table 10 MXDM toolsDescriptionToolDisplays the Connect / Edit System dialog and enables you to connect to a system ormodify a system definition. For m

Table 11 Supported areasDescriptionAreaProvides information about the database objects. For moreinformation, see “Viewing database objects” (page 47).

Using the My Favorites paneMXDM enables you to create favorites and organize them in folders. Subsequently, you can usefavorites to easily navigate to

Removing a favoriteTo remove a favorite, right-click the favorite, and select Remove.Removing a favorites folderTo remove a folder, right-click the fo

When you select the Database area, you can view the database objects on the connected systems,in the navigation tree.The right pane displays more deta

Related Topics“MXDM interface” (page 26)“Adding a system” (page 18)“Using the My Favorites pane” (page 32)“Using the right pane” (page 35)“Disconnecti

Working with windows, tabs, and panesMXDM provides all of the conventional user-interface controls available in other Windowsapplications. MXDM window

Figure 9 Window controlsWorking with windows, tabs, and panes 37

5 Performing basic MXDM operationsThis chapter discusses the following topics:• “Obtaining version and build information” (page 38)• “Resolving errors

To change the sort order of a displayed column, click the heading of the column that you want tosort. A triangle appears at the right indicating the o

Using a favorite...32Viewing a list of f

Figure 12 Changed order of columnsWorking with data gridsThis section discusses the following topics:• “Introduction to data grids” (page 40)• “Obtain

Some MXDM tabs, such as the tabs in the Database area, do not provide data grids. You can sortsingle columns and copy the data in these tabs. However,

Figure 14 Viewing multiple rows in the data gridRelated Topics“Introduction to data grids” (page 40)“Customizing the data grid” (page 42)Copying data

Table 18 Procedures to customize the data gridDo thisToShow or hide columns 1. Right-click a column heading in any data grid, and select Show/Hide Gri

Figure 16 Searching for informationRelated Topics“Introduction to data grids” (page 40)Copying dataYou can copy data to different locations, and use t

Copying data to a browserData to Browser invokes Internet Explorer or a default browser that displays the table data. Thedata is copied internally in

3. Click Yes.MXDM copies the information from the .mxdm file into the persistence file and prompts youto reconnect if you were connected to active sys

6 Viewing database objectsThis chapter discusses the following topics:• “Viewing catalogs and their objects” (page 47)• “Viewing schemas” (page 49)• “

4. Click a catalog.The following tabs related to the catalog appear in the right pane:• Attributes• Registrations• Schemas• DDLFigure 17 (page 48) sho

2. In the right pane, click Registrations.The following details appear:• System — The system where this catalog is registered.• Location — The physica

Viewing the table index columns...59Viewing the table index attribut

5. Click a schema.The following tabs related to the schema appear in the right pane:• Attributes• Tables• Views• Procedures• SQL/MP Aliases• DDLFigure

Viewing tables within a schemaTo view the tables within a schema:1. In the navigation tree, select the schema.2. In the right pane or the Tables folde

2. Do one of the following:• In the right pane, click SQL/MP Aliases.• Within the schema, click the SQL/MP Alias folder.The following details appear:•

6. Select a table.The right pane displays the following tabs:• Columns• Primary Key• Hash Key• Store Order• Check Constraints• Unique Constraints• For

2. In the right pane, click Columns.The following details appear:• Primary Key — An icon or special symbol to indicate that the column is part of the

2. In the right pane, click Store Order.The following details appear:• Position: — The position of the column in the key, for the physical file.• Colu

2. In the right pane, click Attributes.The following details appear:• Name — The name of the table.• Metadata UID — The internal UID number of the tab

2. In the right pane, click Partitions.The following details appear:• Partition Number: — The index number of the partition.• System: — The name of th

2. In the right pane, click DDL.The DDL tab displays the SHOW DDL output for the table. You can use this statement in MXCIto create the table. For mor

6. Expand the contents of a table.The Indexes and Triggers folders appear.7. Within the Indexes folder, select the required Index.In the right pane, t

8 Launching the NonStop SQL/MX Remote Conversational Interface...96Introduction to RMXCI...

2. In the right pane, click Attributes.The following attributes and their values appear:• Name: — The name of the index.• Metadata UID: — The internal

2. In the right pane, click Partitions.The following details related to table index partitions appear:• Partition Number: — The name of the column (st

7. Within the Triggers folder, select the required Trigger.In the right pane, the following tabs related to the trigger appear:• Attributes• Related O

2. In the right pane, click Related Objects.The following details appear:• Relationship: — This attribute specifies the relationship between this trig

Figure 22 SHOW DDL dialogNOTE: The SHOW DDL option is available only for a schema node and its child nodes in thenavigation tree. The SHOW DDL option

2. Under the navigation tree pane, click Database.MXDM displays a list of existing systems.3. In the navigation tree, expand the contents of the syste

2. In the right pane, click Columns.The following details related to view columns appear:• Column Name — The name of the column (string).• Source Obje

Viewing information related to view privilegesTo view information related to the view privileges:1. In the navigation tree, select the view.2. In the

6. Select a procedure.In the right pane, the following tabs related to the procedure appear:• Attributes• Parameters• Related Objects• DDL• Privileges

2. In the right pane, click Attributes.The following details related to attributes appear:• Name — The name of the procedure.• Metadata UID — The uniq

About this guideThis guide describes how to use MXDM to monitor and manage SQL/MX databases.Related Topics“Publishing history” (page 7)“New and change

2. In the right pane, click Parameters.The following details related to parameters appear:• Name — The name of the parameter.• Direction — The followi

2. In the right pane, click Privileges.The following details related to the procedure privileges appear:• Grantee: — The name of the user whose privil

6. Select an SQL/MP alias.In the right pane, the following tabs related to the procedure appear:• Attributes• DDLFigure 25 (page 72) shows the propert

2. Under the navigation tree pane, click Database.MXDM displays a list of existing systems.3. In the navigation tree, expand the contents of the syste

7. In the right pane, click Statistics.The following histogram statistics for the table appear:• Column Name: — The name of the column.• Data Type: —

The top pane displays the column name, table name, the percentage sampled, and the time whenthe sample was taken.The following details appear:• Data T

7 Managing MXCS objectsThis chapter discusses the following topics:• “Viewing MXCS servers” (page 76)• “Stopping an MXCS server” (page 78)• “Viewing M

4. In the right pane, click MXCS Server Status.The list of MXCS servers and their status appear.Figure 27 (page 77) shows the MXCS servers and their s

Stopping an MXCS serverTo stop an MXCS server:1. Log on to the HP NonStop SQL/MX Database Manager.2. Under the navigation tree pane, click Connectivit

5. In the right pane, click MXCS Services to display details of the Association and Configurationservers.Figure 28 (page 79) show the properties relat

Table 1 Chapters in the manual (continued)DescriptionChapterDiscusses the procedures to view and manage MXCS objects“Managing MXCS objects” (page76)Di

To start up an MXCS service:1. Log on to the HP NonStop SQL/MX Database Manager.2. Under the navigation tree pane, click Connectivity.3. In the naviga

Viewing data sourcesTo view data sources:1. Log on to the HP NonStop SQL/MX Database Manager.2. Under the navigation tree pane, click Connectivity.MXD

4. In the navigation tree pane, click a data source. In the right pane, the properties in the DataSource Status tab appear.Figure 30 (page 82) shows t

• “Using the Control Query Defaults tab” (page 87)• “Using the Control Table Statements tab” (page 87)NOTE:Some tabs provide tooltips that explain the

Table 22 General Properties options (continued)DescriptionOptionGroupSpecifies the number of minutes that a client-server connection remainsidle befor

Table 22 General Properties options (continued)DescriptionOptionGroupSee “Adding and modifying the resource management policy” (page 85).ModifyRemoves

Figure 32 Add DEFINEAbout SETsSET variables affect the behavior of MXCS. For example, you can set default catalog and schemanames for servers running

Figure 34 SET SESSION example 2Using the Control Query Defaults tabTo add or modify a CQD configured for a data source:1. Under the navigation tree pa

Table 26 (page 88) describes the options.Table 26 Options in the Control Table Statements tabDescriptionValueSpecifies name of the table.NameDetermine

Similarity checkDescriptionValueThe value used is the system default setting that exists at execution.<Not Set>SQL/MX recompiles the statement a

Describes how to use SQL/MX Remote Conversational Interface to run the RMXCIcommands, and SQL statements interactively or from script files.SQL/MX Rem

• “Using the Control Query Defaults tab” (page 87)• “Using the Control Table Statements tab” (page 87)NOTE: If you made changes to the values in a tab

9. Select one of the following options:NOTE: After you click one of the stop options, you cannot cancel the operation.• Stop on Client Disconnect• Sto

The tracing facility generates a pair of messages for each function that is traced:• First message — Contains the input parameters to the function• Se

Figure 37 MXCS Permissions tabTo view the current MXCS users:1. Log on to the HP NonStop SQL/MX Database Manager.2. Under the navigation tree pane, cl

5. Click Add...The Add User dialog appears.6. Under System Users, select Operator or User.7. From the System Users grid, select the users that you wa

6. Click Yes to confirm.The MXCS user is deleted.Related Topics“Viewing MXCS user permissions” (page 92)“Adding an MXCS user” (page 93)“Editing MXCS u

8 Launching the NonStop SQL/MX Remote ConversationalInterfaceThis chapter discusses the following topics:• “Introduction to RMXCI” (page 96)• “Locatin

catalog, and schema name also are considered while logging on. To set auto logon properties,see “Setting Auto Logon options” (page 97).You can launch

A Using the SQL WhiteboardThis appendix discusses the following topics:• “Introduction to the SQL Whiteboard” (page 98)• “Viewing the SQL Whiteboard”

Figure 38 SQL WhiteboardRelated Topics“Statement List pane” (page 99)“Statement pane” (page 100)“Statement Details pane” (page 102)Statement List pane