HP Integrity NonStop J-Series - Manual (Page 48)

•
<node.$vol> : specify the location of the metadata tables for the catalog. For example:
\NSK01.$data01.
•
<subvol reference> : specify the designated subvolume name for the schema. For
example: SASH2.
NOTE: The subvolume name is always prefixed by ZSD and must have eight characters
(including ZSD).
2. Create a directory in OSS to place the database script files:
OSS> mkdir -p <NonStop SASH Home>/spring/samples/jpetstore/dbconfig
For example:
OSS> mkdir -p /home/sash_usr/sash/spring/samples/jpetstore/dbconfig
NOTE: <NonStop SASH Home> can be any working directory. It is suggested that you
create the spring/samples/jpetstore/dbconfig directory structure in <NonStop
SASH Home
>.
3. Copy the following scripts from the <My SASH Home>\spring\samples\jpetstore\
db
Windows directory to the <NonStop SASH Home>/spring/samples/jpetstore/
dbconfig OSS directory:
•
jpetstore_tables_script.sql
•
jpetstore_dataload_script.sql
NOTE:
•
The jpetstore_tables_script.sql script creates the SQL/MX database catalog,
schema, and tables for JPetStore.
•
The jpetstore_dataload_script.sql script loads the database with sample data.
4. Go to the OSS directory, where the jpetstore_tables_script.sql and
jpetstore_dataload_script.sql
files are copied:
OSS> cd <NonStop SASH Home>/spring/samples/jpetstore/dbconfig
For example:
OSS> cd /home/sash_usr/sash/spring/samples/jpetstore/dbconfig
5. Create the JPetStore database catalog, schema, and tables:
mxci>> obey jpetstore_tables_script.sql;
NOTE: By default, the jpetstore_tables_script.sql file creates the database catalog
name as jpetstorecat and schema name as jpetstoresch. If these names conflict with
the existing catalog and schema names, modify the database catalog and schema names in
the jpetstore_tables_script.sql script file.
If you modify the database catalog and schema names, the new names must be updated in
the jdbc.properties file located in the <My SASH Home>\spring\samples\
jpetstore\src\main\webapp\WEB-INF
directory, included in the SAMPLES.zip file.
6. Load the sample data in the JPetStore database tables:
mxci>> obey jpetstore_dataload_script.sql;
The JPetStore database is set up on the NonStop system.
Deploying JPetStore on NonStop
To deploy JPetStore on the NonStop system, complete the following steps:
48 Installing the Spring Framework