Executable files

File Name

Description

Where Installed

ansp.exe

The OSS file for the ANSI names server process (ANSP), which provides ANSI-to-Guardian name mapping for NonStop utilities.

/usr/tandem/sqlmx/bin
mxrpm

The OSS tool for reprocessing module files.

/usr/tandem/sqlmx/bin
MXAGENT

A Guardian code file 500 which is the SQL/MX backup/restore agent for the Backup and Restore 2 utility.

$SYSTEM.SYSTEM
MXAUDSRV The SQL/MX audit fixup server, a licensed Guardian code file 500, which performs audit fixup for online MODIFY and POPULATE INDEX operations after a fuzzy data copy is created. During MODIFY and POPULATE INDEX processing, the MXAUDSRV is started and stopped automatically as required. Do not attempt to run MXAUDSRV. $SYSTEM.SYSTEM
MXCMP

The SQL/MX compiler, a licensed Guardian code file 500, which compiles DML queries, and executes DDL and utility commands.

$SYSTEM.SYSTEM
MXESP

The SQL/MX executor server process, a licensed Guardian code file 500 used for parallel execution of queries. MXESP processes are started and stopped automatically as required. Do not attempt to run MXESP.

$SYSTEM.SYSTEM
MXRTDSRV

A licensed Guardian code 100 file that acts as an external bridge to provide a link between SQL/MX and NonStop SQL/MP through the SQL/MX compiler (MXCMP). MXRTDSRV processes are started and stopped automatically as required. Do not attempt to run MXRTDSRV.

$SYSTEM.SYSTEM
MXUDR

A Guardian code file 500 which acts as a layer of software between the SQL/MX executor and JVM that supports SPJs in SQL/MX. MXUDR processes are started and stopped automatically as required. Do not attempt to run MXUDR.

For more information on SPJs, see the SQL/MX Guide to Stored Procedures in Java.

$SYSTEM.SYSTEM
MXUTP A licensed Guardian code file 500

for the materialized view feature, which is not supported with SQL/MX Release 3.2.x. MXUTP processes are started and stopped automatically as required. Do not attempt to run MXUTP.

$SYSTEM.SYSTEM
MXOMSG

A message file associated with MXCS.

$SYSTEM.SYSTEM
IMPORT

The IMPORT utility, which resides in the Guardian file space and is a licensed Guardian code file 500.

$SYSTEM.SYSTEM
MXTOOL An OSS command-line utility, which is a licensed Guardian code file 500, performs various utility functions such as fixup, goaway, info, verify, and cleanup. $SYSTEM.SYSTEM
MXIMPDDL

An OSS command-line utility, which is a licensed Guardian code file 500, replicates the DDL definition and statistics of SQL/MX objects.

$SYSTEM.SYSTEM
MXGNAMES

The Guardian code file 500 for the MXGNAMES utility.

$SYSTEM.ZMXTOOLS
import

The symbolic OSS link to the IMPORT utility that resides in Guardian file space.

/usr/tandem/sqlmx/bin
mxci

The OSS file for the SQL/MX conversational interface (MXCI). To run mxci, you must be in the OSS environment.

/usr/tandem/sqlmx/bin
mxCompileUserModule The command-line tool used to produce compiled module definitions for embedded applications. For more information, see the SQL/MX Programming Manual for C and COBOL. /usr/tandem/sqlmx/bin
mxexportddl

The OSS file for the mxexportDDL utility. See SQL/MX Management Manual.

/usr/tandem/sqlmx/bin
mxsqlc

The OSS-based C preprocessor to preprocess embedded SQL statements in C/C++ programs. The preprocessor replaces SQL statements in C/C++ programs with C function calls to the call-level interface (CLI). For details on mxsqlc, see the

SQL/MX Programming Manual for C and COBOL.
/usr/tandem/sqlmx/bin
mxsqlco The OSS-based COBOL preprocessor to preprocess embedded SQL statements in COBOL programs. For details on mxsqlco, see the SQL/MX Programming Manual for C and COBOL. /usr/tandem/sqlmx/bin
mxtool

A link to $system.system.mxtool utility.

/usr/tandem/sqlmx/bin
SqlMxHealthCheck

The command-line tool used to verify and report any metadata inconsistencies prior to performing a system upgrade or fallback.

/usr/tandem/sqlmx/bin