MXDM functional flow

The functional model within which MXDM operates includes the following components on the client workstation:

  • MXDM

  • Windows ODBC/MX driver

On the NonStop system, you must install the required MXCS objects and create those database objects that you want to manage using MXDM. MXDM functional flow shows the MXDM functional flow.

MXDM functional flow

The following is the sequence of events involved in establishing the connection between MXDM and the server components, and in managing the objects:

  1. MXDM sends a connection request to the MXCS using the Windows ODBC/MX driver. MXDM specifies an IP address or the NonStop server Domain Naming Service (DNS) name and port number that is defined when the Association server started up.

  2. The ODBC/MX driver accesses an MXCS Association server on the NonStop system.

  3. The Association server associates the client application with an available MXCS server for the data source.

  4. MXDM sends a connection request to the MXCS server that was assigned by the Association server. After the user information is validated, a connection between MXDM and the SQL/MX database is established.

Subsequently, you can view and administer the database and MXCS objects on the system. You can view the DDL statements for the database objects in MXDM. You can use these statements to create the database objects using mxci.

For more information, see HPE NonStop SQL/MX Release 3.4 Connectivity Services Manual.