MXDM features and functionalities
Database and MXCS objects enable you to perform the following actions:
-
Search for specific database objects in all catalogs and schemas on the connected systems.
-
Browse database objects and view the tables, indexes, views, procedures, SQL/MP aliases, triggers, and sequence generators, and materialized views in each schema. You can also view details of individual SQL/MX objects.
-
Browse MXCS objects. On a managed system, you can view the MXCS services and functions, data sources, MXCS servers, and MXCS user permissions.
-
Manage database objects.
-
You can create and drop database objects such as catalogs, schemas, tables, indexes, triggers, views, SQL/MP Aliases, stored procedures in Java, and sequences. You can alter tables, indexes, views, SQL/MP Alias and sequences, enable and disable triggers, register and unregister catalogs, and create a table based on another table. You can also rename tables, indexes, views, and sequences.
-
View the properties of PL/MX functions.
-
View a summary of groups of objects, such as, schemas in a catalog, tables in a schema, indexes on a table.
-
Change the ownership of database objects such as catalogs, schemas, tables, views, procedures, triggers, and sequences.
-
View information related to the size of the schema.
-
View information about the partitions of a table or an index, such as the physical location, size of extents and maximum partition size.
-
Copy various tabular data such as list of catalogs, schemas, data sources, object properties, servers, or services to spreadsheets or files.
-
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.
-
Launch OSM Event Viewer to view EMS logs.
-
-
Execute queries and view data results using SQL Whiteboard.
-
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 it (syntax highlighting).
-
Cancel an executing query.
-
Open and save query text to a file.
-
Use parameters in queries.
-
-
Perform the following actions using MXDM Framework:
-
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 tool bar 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 enables users with the operator permission, 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.
-
Associate a data source with one or more services.
NOTE:Only
SUPER.SUPER
user can assign and change user permissions. -
-
MXDM works seamlessly for a tenant user when connected to a tenant database of SQL/MX (multi-tenancy). For more information on multi-tenancy, see SQL/MX Database Services Manual.
- Related Topic
- Obtaining version and build information