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.