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

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” (page 104) .
persistence file 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” (page 46) .
query 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.
right pane The right pane of the NonStop SQL/MX Database Manager interface displays information about
the selected objects in the navigation tree pane.
“MXDM interface” (page 27) .
segment 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.
SQL statement 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
the SQL/MX Reference Manual.
SQL Whiteboard A utility that allows you to enter and execute SQL statements from within MXDM. For more
information, see
“Introduction to the SQL Whiteboard” (page 101) .
system The user view of a system definition.
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”
(page 28) .
system monitor 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.
Systems Tool 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.
TDM_Default_
DataSource One of two default data sources for the 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.
user permission MXCS permission that allows you to view data source configurations, MXCS services, MXCS
servers, and data sources. See also
“Viewing MXCS user permissions” (page 95) .
109