SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)

Figure 1 MXCS Architecture - Interactions Among Three Components
Data Sources
A datasource is a logical grouping of MXOSRVRs. The data source definitions include the basic
configuration performed on the data source. MXCS requires data source definitions on the NonStop
server, and for ODBC clients on the client workstation.
Server Data Sources
Server data sources reside on a NonStop server. Each server data source represents a pool of
SQL MXCS servers that share the same NonStop SQL context. Use NSM/web or MXCI in MXCS
mode (MACL) to add, remove, configure, and monitor server data sources. See “Managing MXCS
Server Data Sources” (page 27).
Default Data Source
MXCS provides a preconfigured, default server data source on the server called
TDM_Default_DataSource. You can stop and start the TDM_Default_DataSource using NSM/web,
but you cannot delete it. The TDM_Default_DataSource has these functions:
Clients can connect to TDM_Default_DataSource and access a NonStop SQL database with
no special configuration required.
When a client tries to connect to a data source in the NonStop system, the association server
connects the client to TDM_Default_DataSource if one of the following conditions exists:
the data source name and the NonStop system data source name do not match (including
the case).
the NonStop system data source does not exist.
NOTE: TDM_Default_DataSource must be in a started state for the client to be connected. If an
ODBC client tries to connect to any server data source that is stopped, MXCS rejects the connection.
Client Data Sources
Client data sources are used for ODBC/MX connections and reside on a client workstation. Each
client data source is a logical name that identifies the attribute values used to connect to the MXCS
Data Sources 13