Glossary, My systems, Disconnect – HP Integrity NonStop J-Series User Manual
Page 108: Data source, Menu bar, Area, Navigation tree pane, Data grid, Operator permission association server, Data sources mxcs service

Glossary
area
A broad category of features that you can manage or monitor using MXDM. See
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
connection
When a user interaction requires interaction with a system, the relevant code uses the
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 41)
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
.
See
“Disconnecting from a system” (page 22)
.
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.
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
.
My Systems
In the navigation tree pane, a folder showing the group of SQL/MX platforms that are currently
defined in the
. The icon for each system shows the connection status for that system.
For more information, see
“Using the navigation tree” (page 34)
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.
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 95)
or
“Adding an MXCS user” (page 96)
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
108 Glossary