Instruction Manual

◦ 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.

◦ Open and save query text to a file.

◦ Use parameters in queries.

• MXDM Framework —enables you to perform the following:

Manage multiple SQL/MX databases using a single instance of MXDM.◦

◦ Save the connection definition when you connect to a system the first time, and retrieve

the definition automatically during subsequent attempts to connect to that system.

◦ Access tools using menu and toolbar options.

◦ Customize the elements displayed in the UI.

◦ Copy grid contents to a spreadsheet, clipboard, browser or a file.

◦ Launch RMXCI.

• Data source and connectivity management — If you have the operator permission, MXDM

enables you to perform the following:

◦ Add information related to environmental variables, such as, Control Query Defaults

(CQDs), DEFINEs and SETs, and Control Table Statements.

◦ Create, edit, copy or delete data sources.

◦ Start and stop data sources.

◦ Stop server processes.

◦ Start and stop MXCS services.

◦ View user permissions.

NOTE: Only the SUPER.SUPER user can assign and change user permissions.