SQL/MX Quick Start (G06.24+, H06.03+)

Welcome to Quick Start
HP NonStop SQL/MX Quick Start—523724-002
1-5
Installing or Removing the Sample Database
If OSS has been installed and the Manage OSS files option has been selected,
DSM/SCM automatically extracts the setmxdb script from the pax file and installs it in
the /usr/tandem/sqlmx/bin directory.
If the files are not present in this directory, DSM/SCM might not be configured to
extract the files automatically. In this case, you must extract the files manually:
1. At the TACL prompt, change to the $SYSTEM.ZOSSUTL subvolume:
volume $system.zossutl
2. Use the copyoss command to extract the files:
run copyoss t0517pax
3. In OSS, verify that the setmxdb, readme, and sample SQLJ.sqlj files were
extracted to the /usr/tandem/sqlmx/bin directory.
For more information on 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 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. 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 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 ... ]