SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Managing Database Applications

HP NonStop SQL/MX Installation and Management Guide—544536-007

11-8

Distributing Programs Across Nodes

3. If the application refers to SQL/MP tables or views by using SQL/MP aliases,

create the SQL/MP aliases in the production environment. See Setting SQL/MP

Aliases on page 11-11.

4. Generate a new module or modules for the program:

For an embedded SQL program in C, C++, or COBOL, run the

mxCompileUserModule utility on the production system to SQL compile an

embedded module definition:

mxCompileUserModule myprog.exe

Alternately, run the mxcmp command to SQL compile a module definition file:

mxcmp sqlprog.m

For more information, see the SQL/MX Programming Manual for C and COBOL.

The program is now ready for execution in the production environment.

Distributing Programs Across Nodes

This subsection provides guidelines for running programs in a distributed database

network.

For comprehensive information about managing a distributed database environment,

see Section 13, Managing an SQL/MX Distributed Database.

For information about how to code programs to query distributed database objects,

see the SQL/MX Programming Manual for C and COBOL.

Versioning Issues for a Distributed Database Environment

For information about managing SQL/MX Release 2.x query plan versions in a

distributed database environment, see the SQL/MX Database and Application

Migration Guide.

Moving Applications to a Remote Node

To move an application to a remote node (where the metadata for the application’s

objects does not reside), move the application files and recompile the module

definitions on the remote node. Do not attempt to copy the module file for that

application to the remote node. Note that this approach risks generating a query plan

on the remote node that differs from the query plan on the original node.

For detailed instructions about how to move application files and modules to a remote

node, see Moving Programs From Development to Production on page 11-3.