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

Installing NonStop SQL/MX

HP NonStop SQL/MX Installation and Management Guide—523723-004

3-19

Starting MXCI

MXCI runs as an OSS process and must be started from within the OSS environment.

To start MXCI:

1. At a TACL prompt, start the OSS shell by entering:

osh

You are now in the OSS environment.

2. Enter the mxci command to start MXCI. Always enter the command using

lowercase letters, because the OSS environment is case-sensitive.

The MXCI session begins, and the MXCI prompt (>>) appears.

For information about MXCI commands, see the SQL/MX Reference Manual.

Installing Visual Query Planner

Visual Query Planner is distributed as a setup file named MXVQP in the

$SYSTEM.ZMXTOOLS subvolume. To install Visual Query Planner:

1. Use OutsideView, the Receive File option, or FTP to download MXVQP to a

Windows NT workstation.

MXVQP is a binary file. If you use the Receive File option, select Binary but do not

select Add CR LF. Specify SETUP.EXE for the local file name.

2. Run SETUP.EXE. The InstallShield application guides you in installing (or

removing) the Visual Query Planner executable files. By default, InstallShield

places the executable and online help in the C:\Program Files\Hewlett

Packard\NonStop SQL-MX folder. If you prefer, you can select a different

installation folder.

3. Delete SETUP.EXE if you want.

Visual Query Planner requires the Microsoft ODBC DataSource Administrator (client)

to connect to NonStop SQL/MX. For information about installing the Microsoft ODBC

Data Source Administrator, see the ODBC/MX Driver for Windows.

For information about using Visual Query Planner, see the SQL/MX Query Guide, or

see the Visual Query Planner online help in the Visual Query Planner.

Installing the SQL/MX Online Help

SQL/MX online help files are provided in the NonStop Technical Library (NTL) and on

the site update tape (SUT). The help files are designed for best viewing on a TSM

Note. Check that the file mxci in the OSS directory /usr/tandem/sqlmx/bin is secured

for read and execute access to your node. If it is not secured for execute access, you cannot

start it. If necessary, use the OSS command chmod to change the options.