SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
5-75
MXRPM tool
MXRPM tool
MXRPM is an OSS tool that reprocesses module files. This tool processes module files
with version 3200 and above.
This tool helps to improve embedded SQL application performance by persisting the
result of Similarity Check in the module files. When you move the module files from a
test to a production system, use this tool to replace compile time objects and their
specific attributes with run time objects and their specific attributes in the module file.
When the application loads in the production environment, Similarity Checks are
avoided for statements in the module files that are successfully reprocessed by the
tool.
-map map-file
map-file is an unstructured OSS file, which contains the mappings between
compile time and runtime ANSI names for tables and views. If the absolute path for
the file is not specified, the tool searches for the file in the current directory.
The compile time and runtime ANSI names specified in the map-file can contain
only ISO88591 characters. A colon is used as a delimiter between the compile time
and the runtime ANSI names. Any leading and trailing spaces are removed. Each
mapping must be on a separate line. For more information, see Guidelines for
map-file on page 5-76.
-log log-file
This tool logs the result of processing the module files in log-file. If the -log
option is specified without the log-file, it logs the result to the console. For
more information, see Guidelines for log-file on page 5-76.
-modlist modules-list-input-file
modules-list-input-file is an unstructured OSS file which contains the list
of module files. This tool can process only OSS module files. Each module file
must be specified on a separate line. For more information, see Guidelines for
module-list-input-file on page 5-76.
module-files-list-separated-by-spaces
You can specify the modules on the command line with the module file names
separated by spaces.
mxrpm [ -log [ log-file ] ]
-map map-file
{ -modlist modules-list-input-file | module-
files-list-separated-by-spaces }
| -help