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

Welcome to Quick Start
HP NonStop SQL/MX Quick Start—523724-002
1-7
Installing or Removing the Sample Database
-part <p1> <p2> Specifies additional or alternate volume names
on which partitioned tables in the sample
database are to be created.
Only one table in the SQL/MX sample
database, the PARTLOC table, may be
partitioned. If the -part option is specified,
then the PARTLOC table is created with two
partitions, using the volumes designated via
this option.
If the -part option is not specified, then a non-
partitioned PARTLOC table is created.
All tables in the Data Mining database have
three partitions. The -vol option is used to
specify the location of the first (or primary)
partition, while the -part option is used to
specify the locations of the second and third
partitions.
Only one table in the Pub/Sub sample
database, the INBOX table, is partitioned. This
table has three partitions. The -vol option is
used to specify the location of the first (or
primary) partition, while the -part option is
used to specify the locations of the second and
third partitions.
The default value for each of the -part
partitions is the volume specified via the
=_DEFAULTS define. (The OSS command
info_define =_DEFAULTS may be used to
view this value.)
-catalog <name> Specifies the catalog in which to create sample
database tables. The default catalog is
SAMDBCAT.
-quiet Suppresses the display of results except for
errors. The default behavior is for results to be
displayed.
-log <file> Specifies the log file to which the non-error
results of running the script are written. The
default value is /dev/tty (that is, displayed
on the terminal from which the script is
executed).