Setting up an sql/mx database on nonstop – HP Integrity NonStop J-Series User Manual
Page 29
Table 6 Softwares to be installed on the Windows system
Download
Software
Download from
and set the PATH and JAVA_HOME environment variables.
JDK version 1.6
For information on installing JDBC Type 4 driver on a Windows system, see JDBC Type 4
Driver Programmer's Reference for SQL/MX.
JDBC Type 4 driver
version
Download from
and set the PATH and
ANT_HOME
environment variables.
Ant 1.8.2
Setting up an SQL/MX Database on NonStop
1.
Edit the <TMF Adapter Home
>\Samples\TMF_Adapter_Sample\dbconfig\student_script.sql
file to include
the following:
•
<$datavol>
: specify the Guardian volume for the primary partition of the table. For
example: $data01
•
: specify the owner of the schema. For example: super.sashusr
•
: specify the location of the metadata tables for the catalog. For example:
\NSK01.$data01
•
: specify the designated subvolume name for the schema. For
example: SASH1
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, using the command:
OSS> mkdir -p <NonStop TMF Adapter Home>/spring/samples/TMFAdapter/dbconfig
For example:
OSS> mkdir -p /home/sash_usr/sash/spring/samples/TMFAdapter/dbconfig
NOTE:
HP recommends that you create /spring/samples/TMFAdapter/dbconfig
directory structure under <NonStop TMF Adapter Home>.
3.
Copy the student_script.sql from the<TMF Adapter Home
>\Samples\TMF_Adapter_Sample\dbconfig\
Windows directory to the OSS directory
created in Step 2.
4.
Go to the OSS directory where the student_script.sql file is copied, and create the
database catalog and schema, using the SQL/MX command:
OSS> obey student_script.sql;
NOTE:
By default, the student_script.sql file creates the database catalog name as
simplecat
and schema name as simplesch. If these names conflict with any of the existing
catalog and schema names, modify the database catalog and schema names in the
student_script.sql
script file.
If you modify the database catalog and schema names, update the
application.properties
file present in SAMPLES.zip, available in the <TMF Adapter
Home>\Samples\TMF_Adapter_Sample\src
directory.
The SQL/MX database is setup on your NonStop system.
Integrating Spring with Transaction Management Facility (TMF)
29