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

1 Introduction to MXDM
This chapter discusses the following topics:
•
“Overview” (page 12)
•
“MXDM features and functionalities” (page 12)
•
“MXDM functional flow” (page 13)
Overview
MXDM is an integrated graphical user interface (GUI) client that enables you to connect to and
manage multiple NonStop SQL/MX databases. Using MXDM, you can browse database and
SQL/MX Connectivity Services (MXCS) objects, execute DDL and DML statements, view query
results, manage MXCS objects, assign access permissions to system users, and launch the HP
NonStop SQL/MX Remote Conversational Interface (RMXCI). RMXCI enables you to perform
administrative and database management tasks by running SQL statements interactively or from
script files.
For more information on RMXCI, see HP NonStop SQL/MX Remote Conversational Interface
(RMXCI) Guide.
Related Topics
“MXDM features and functionalities” (page 12)
MXDM features and functionalities
MXDM provides the following features and functionalities:
•
Database and MXCS objects—enables you to perform the following:
Browse database objects. For each schema, you can view its tables, indexes, views,
procedures, and SQL/MP aliases. You can also view details of individual SQL/MX
objects. ◦
◦ Browse MXCS objects. On a managed system, you can view the MXCS services, data
sources, MXCS servers, and MXCS user permissions.
◦ View a summary of groups of objects, such as, schemas in a catalog, tables in a schema,
indexes on a table, and so on.
◦ View information related to the size of the schema.
◦ Use the SHOW DDL tool to generate and save the Data Definition Language (DDL) script
for a group of SQL/MX objects.
◦ View information related to table profiles and statistics.
◦ View EMS logs.
•
SQL Whiteboard —enables you to execute queries and view data results. Using the SQL
Whiteboard, you can perform the following:
◦
Execute DDL and Data Manipulation Language (DML) statements.
◦ Persist queries across sessions for reuse.
◦ Copy query results to a spreadsheet.
◦
Highlight a portion of an SQL statement and execute (syntax highlighting).
◦ Cancel an executing query.
12 Introduction to MXDM