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

MXCS ConfigurationNonStop ODBC Server Configuration
The configuration parameters are provided as part of the
command line.
Network configuration
Not Applicable. All data source names (and configuration
values) are shared between all ODBC/MX service instances
in the same system.
Map server class names to SCS names
Not ApplicableMap user name aliases to SCS and server class names
To configure the MXCS environment, use NSM/web or MXCI. The service does not have to be
started for you to configure MXCS data sources.
NonStop ODBC Server user aliases can be created in Safeguard at any time.
Resource Governing
Both products provide resource governing capabilities.
MXCS supports resource governing based on cost. When configured, MXCS sends an event
message (EMS) to register any attempt to exceed the cost limit. The query can be stopped or
executed. Resource governing policies are configured through the Resource Management tab in
NSM/web.
MXCS ConfigurationNonStop ODBC Server Configuration
Not ApplicableElapsed time
Same (only stop and log actions are supported)Estimated cost
Not ApplicableRows accessed
Not ApplicableRows used
Not ApplicableExecution time
Setting Control Statements
Use control statements to modify the execution of an SQL query.
You can configure control statements in both products but the statements are associated with
different configuration objects. In the NonStop ODBC Server configuration, a control statement is
associated with a profile. In MXCS, a control statement is associated with a data source (which
implements the same concept as a profile).
An MXCS control statement can be any valid SQL/MX control statement and is executed at the
time the client connects to the server. Use NSM/web or MXCI to configure the control statements
for a data source.
Control statements defined for NonStop SQL/MP might not work with SQL/MX. For information
on control statements, see HP NonStop SQL/MX Release 3.2 Reference Manual.
Configuring MXCS Data Sources
A server class in an NonStop ODBC Server environment corresponds to a data source in an MXCS
environment. The following table compares the terminology between NonStop ODBC Server and
MXCS.
Corresponding MXCS Data Source AttributesNonStop ODBC Server Class Attributes
User name is based on the login name for the connecting
user ID; there is no default.
Guardian user name
Priority is the same as specified for the association server
or as defined in the data source configuration.
Priority
All available CPUs in the system are used in a round-robin,
or as defined in the data source configuration.
CPU list
Available serversAvailable servers
60 Migrating Applications from NonStop ODBC Server