MX 2.x)

Migrating Applications from NonStop ODBC Server

HP NonStop SQL/MX Connectivity Service Manual—524944-008

A-7

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.

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. Refer

to the SQL/MX Reference Manual for a detailed description of control statements.

NonStop ODBC Server Configuration MXCS Configuration

Elapsed time Not Applicable

Estimated cost Same (only stop and log actions are

supported)

Rows accessed Not Applicable

Rows used Not Applicable

Execution time Not Applicable