HP Integrity NonStop J-Series - Manual (Page 105)

Glossary
area A broad category of features that you can manage or monitor using MXDM. See “Selecting an
area” (page 30) .
association server 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
“Viewing MXCS
Services” (page 78) .
connection 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.
data grid 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” (page 40) .
data source 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.
disconnect 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” (page 21) .
favorite 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.
menu bar 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” (page 26) shows the
menu bar.
MXCS (SQL/MX
Database
Connectivity
Service) 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 or MXAS2),
a configuration server (MXOCFG), and MXCS SQL servers.
MXCS server A process that manages an ODBC connection.
MXCS Service A process that uses data sources to launch MXCS SQL servers to manage connections.
MXDM HP 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 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 also
MXAS2 .
My Systems 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” (page 33) .
navigation tree
pane 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” (page 26) shows the navigation tree
pane.
operator
permission 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
“Viewing MXCS user permissions” (page 92) or
“Adding an MXCS user” (page 93) .
page mode 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
105