Manual

1. Edit the jpetstore_tables_script.sql file to add the following:
• <$datavol>: specify the Guardian volume for the primary partition of the table. For
example: $data01
• <user>: specify the owner of the schema. For example: super.sashusr
• <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 must only be five characters long.
2. Create a directory in OSS to place the database script files, using the command:
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, using the OSS command:
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 using the SQL/MX command:
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
any of the existing catalog and schema names, you must 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 present in the <My SASH Home>\spring\samples\jpetstore\
war\WEB-INF directory, included in the SAMPLES.zip file.
6. Load the sample data in the JPetStore database tables, using the SQL/MX command:
mxci>> obey jpetstore_dataload_script.sql;
The JPetStore database is set up on your NonStop system.
56 Installing Spring Framework