SQL/MX Quick Start (H06.04+, J06.03+)

Welcome to MXCI and the Sample Database
NonStop HP SQL/MX Quick Start—540438-001
1-6
Installing or Removing the Sample Database
For more information about the pax command, see the Open System Services Shell
and Utilities Reference Manual.
Installing or Removing the Sample Database
Use the setmxdb script to install or remove the sample database for NonStop
SQL/MX. You do not need to have super user ID privileges, but you must have
permissions to create tables in the volume where you plan to put the database. The
usage format and command options you can use with setmxdb are described below.
Online help also shows the usage format and command options. To display the online
help from OSS, use this command:
setmxdb -help
To install or remove the SQL/MX sample database:
1. Log on to the NonStop system where NonStop SQL/MX is installed.
2. Start the OSS shell by entering this command at the TACL prompt:
osh
You are now in the OSS environment. The OSS environment is case-sensitive.
3. Before you run the script, change the directory to the location of the script by
entering:
cd /usr/tandem/sqlmx/bin
4. Run the setmxdb script. The usage format for setmxdb is:
setmxdb [ operation ...] [option ... ]