NonStop JMS User's Manual (H06.03+, J06.03+, NonStop JMS 3.0+)

NSJMS Installation and Configuration for TNS/E
NonStop Server for Java Message Service User’s Manual—522356-006
3-7
Install and Configure NSJMS
6. Verify that you have access to an existing SQL catalog, or create a new catalog.
NSJMS uses SQL tables to store messages and destination information.
To create a new SQL catalog:
For additional information about the requirements for creating SQL catalogs, see
the SQL/MP Installation and Management Guide.
7. Update SQL Catalog and Table Location:

If the NSJMS SQL tables reside on the same subvolume as the SQL catalog,
using an editor of your choice, update the SQL catalog location in the
/usr/tandem/nsjms/version/creatsql file to reflect the
volume.subvol of the existing or newly created SQL catalog specified in Step
6 on page 3-7. For example:
Change:
VOLUME;
To:
VOLUME $volume.subvol;

If the NSJMS SQL tables will reside on a different subvolume than the SQL
catalog, using an editor of your choice, add the SQL catalog location to the
/usr/tandem/nsjms/version/creatsql file by adding a CATALOG
command referring to the catalog from Step 6
on page 3-7, and update the
VOLUME command to refer to the volume.subvol where the database tables
will reside. For example:
Change:
VOLUME;
To:
CATALOG $volume1.subvol1
VOLUME $volume2.subvol2
8. Use this command to create the NSJMS SQL tables. For example:
If T2766H10 is installed in a non-standard location:
OSH: export JAVA_HOME=/<java-install-dir>/java
OSH: export JREHOME=$JAVA_HOME/jre
OSH: export CLASSPATH=$NSJMS_HOME:$NSJMS_HOME/examples:$CLASSPATH
OSH: export CLASSPATH=`echo $NSJMS_HOME/lib/*.jar | tr ' ' ':'`:$CLASSPATH
OSH: export _RLD_LIB_PATH=$NSJMS_HOME/lib
OSH: gtacl -p sqlci 'create catalog $volume.subvol;exit;'
OSH: gtacl -p sqlci < creatsql