Glossary

A broad category of features that you can manage or monitor using MXDM. See Selecting an area.

The logical component that starts up and manages MXCS SQL servers and associates a client connection request with a specific MXCS SQL server in a data source. See also Displaying MXCS Services.

When a user interaction requires interaction with a system, the relevant code uses the system definition for that system to transparently establish one or more ODBC connections, as needed.

A tabular presentation of system data. MXDM data grids provide special features for displaying and manipulating data. The SQL Whiteboard Statement Details pane display information in a data grid. Tabs in the Database area do not provide data-grid features. For more information about data-grid features, see Introduction to data grids.

A logical name that defines the information required to access data. On the client side, the data source defines the driver name, network address, and specific attributes, such as the catalog and schema names. On the server side, it defines startup values, the number of servers in a pool, DEFINEs, SQL/MX control statements, and resource management policies.

Because connections are transient, there is no concept of logging on or logging off. The MXDM equivalent of logon is making a system usable by entering the correct settings. The MXDM equivalent of logoff is making a system unusable by disconnecting (or invalidating any of its other settings). Use the Disconnect function when you want the client application to continue running, but you want to deny continued access to a system without having to remove the system definition. See Disconnecting from a system.

A favorite is a shortcut to an object on the navigation tree pane. Favorites appear in the My Favorites pane. Clicking a favorite enables you to navigate quickly to any object on the tree pane that might otherwise require scrolling through and expanding numerous parent objects. MXDM enables you to create favorites and organize them in folders.

SQL/MX Administrative Command Library

The menu bar is the list of commands at the top of the MXDM main window. The menu bar commands are: File, Edit, Tools, Windows, and Help. MXDM interface shows the menu bar.

The server component that enables connectivity from client applications to the SQL/MX database. The SQL/MX Database Connectivity Service consists of an Association server (MXOAS), a configuration server (MXOCFG), and MXCS SQL servers.

A process that manages an ODBC connection.

A process that uses data sources to launch MXCS SQL servers to manage connections.

HPE NonStop SQL/MX Database Manager (MXDM) is an integrated graphical user interface (GUI) client that enables you to connect to and manage multiple NonStop SQL/MX databases.

MXOAS is the component of the SQL/MX Database Connectivity Service (MXCS) that receives client connection requests for database access and associates the requestor with a server to execute the requested access. See Displaying MXCS Services.

MXOSRVR is the MXCS SQL server process. MXOSRVR handles database requests from the clients. The association servers spawn MXOSRVRs on all segments in a platform.

In the navigation tree pane, a folder showing the group of SQL/MX platforms that are currently defined in the Systems Tool. The icon for each system shows the connection status for that system. For more information, see Using the navigation tree.

The left pane of the NonStop SQL/MX Database Manager interface that displays a tree of the database objects in a hierarchical form. MXDM interface shows the navigation tree pane.

An MXCS permission that allows a user to perform administrative tasks, such as managing data source configurations, MXCS services, data sources, and servers, by making changes to status and configuration. For more information, see Displaying MXCS user permissions or Adding an MXCS user.

A SQL Whiteboard feature that breaks large result sets into pages and fetches one page at a time. To prevent out-of-memory conditions, page mode limits the amount of memory used by the SQL Whiteboard. In page mode, only a partial result of a query is held in memory and displayed in the Statement Details page. For more information, see Page mode.

A binary file that contains state and user preference information (for example, system definitions, user-specified options, favorites, and layout information). For more information, see Saving and importing system definitions.

A request for data from the database; specifically, the execution of a SQL statement, which requests columns and rows from one or more tables and views. In the context of the SQL/MX optimizer, a query is a request for data access through an DML statement.

The right pane of the NonStop SQL/MX Database Manager interface displays information about the selected objects in the navigation tree pane. MXDM interface.

A subdivision of a SQL/MX cluster that consists of 16 processing nodes (CPUs). Each segment has a name (for example, HPQ0101), and the SQL/MX cluster contains one master segment. All other segments are considered slave segments.

Any DML or DDL statement including, but not limited to SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, GRANT, and REVOKE. For more information about SQL statements, see HPE NonStop SQL/MX Release 3.4 Reference Manual.

A utility that allows you to enter and execute SQL statements from within MXDM. For more information, see Introduction to the SQL Whiteboard.

The user view of a system definition.

A user-named set of all of the information required to construct an ODBC connection string: server data source, username, password, server IP address or DNS name, port number, default schema, and ODBC driver version. The banner displays the system definition. See MXDM banner.

The system monitor is a tool within MXDM that displays status and performance data for the SQL/MX platform. The displayed status and performance data includes seven performance metrics and four system status icons.

The tool used to define, add, edit, remove, duplicate, test, and open a connection with a SQL/MX platform. The Systems Tool is available from the Tools menu.

The default data source for SQL/MX platform. TDM_Default_DataSource is the default data source for database access. You cannot delete TDM_Default_DataSource, but you can configure other data sources.

MXCS permission that allows you to view data source configurations, MXCS services, MXCS servers, and data sources. See also Displaying MXCS user permissions.