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-23
Grouping Applications and Modules to Run Multiple
DISPLAY USE OF Operations
Displaying the Modules in a Local Directory
DISPLAY USE OF returns information about the modules in a local OSS directory
when you specify the directory with the MODULE_DIR clause.
DISPLAY USE OF MODULE_DIR '/usr/myapp' MODULE 'cat.sch.t24';
You must specify the fully qualified OSS directory path of a locally placed module.
Otherwise, an error occurs. The local directory is searched for modules matching the
pattern you specified in the MODULE_DIR clause. If modules that match the pattern
are not found in the local directory, an error is returned and searching does not extend
beyond the local directory.
For more information about the syntax of the MODULE_DIR clause of DISPLAY USE
OF, see the SQL/MX Reference Manual.
Grouping Applications and Modules to Run Multiple DISPLAY
USE OF Operations
As the number of modules created on your system grows, the time required to run a
single DISPLAY USE OF operation on most or all of them might become excessive. To
significantly reduce this operations, you should group modules into subsets by using
such criteria such as applications, associations with tables, or any other grouping that
is relevant to your environment. Once you create the module subsets, you can run
multiple DISPLAY USE OF operations on different CPUs to simultaneously access
each of the subsets in far less time than it would take to run a single DISPLAY USE OF
operation on the modules.
This subsection provides instructions and examples for precompiling embedded
applications to generate different modules using the module grouping precompiler
option. It contains examples of these activities:
•
Using the module grouping precompiler option to precompile embedded C
applications to generate different modules
•
Using DISPLAY USE OF to search for SQL/MX objects used by specified modules
•
Using mxCompileUserModule to place SQL compiled modules in the user
specified local directory
•
Using DISPLAY USE OF to search for compiled modules by specifying an SQL/MX
object
Assume you have five applications written in C and want to group these applications
and their modules into these two groups:
•
t01.sql, t02.sql, and t03.sql into the group INVENTORYAPP
•
t11.sql and t21.sql into the group SHIPMENTAPP