NonStop Servlets for JavaServer Pages (NSJSP) 6.1 System Administrator's Guide

Configuring NSJSP
NonStop Servlets for JavaServer Pages (NSJSP) 6.1 System Administrator’s Guide—596210-006
3-85
Persistent Manager Sessions
(SessionBasedLoadBalancing = false)
To create the NonStop SQL database for storing the persistent session data, perform
the task for the database product that will be used to create and access the persistent
store table:

For the NonStop SQL/MP database:
Make a copy of the nsjsp_createSessionStore_mp.sql file and replace all
occurrences of =TheT1222SessionCatalog with the Guardian location (of the
form $Volume.SubVol) where you want the persistent session catalog and table
to be created. This subvolume (disk) should be a TMF-audited data volume.
Use the following OSS command to create the table:
osh> gtacl -p sqlci <
nsjsp_createSessionStore_mp.sql.your_copy
Example 3-67 shows the SQL/MP script to create the persistent store.

For the NonStop SQL/MX database:
Make a copy of the nsjsp_createSessionStore_mx.sql file and replace the
=TheT1222SessionCatalog string with a valid catalog name. Replace the
=TheT1222SessionSchema string with a valid schema name.
Use the following OSS command to create the mx table:
osh> mxci < nsjsp_createSessionStore_mx.sql.your_copy
Example 3-68
shows the SQL/MX script to create the persistent store.
Example 3-67. SQL/MP script to create a Persistent Store
create catalog $data01.nsjspcat secure "OOOO";
--
-- Create the NonStop(tm) SQL Table in the above catalog for storing the
-- NonStop(tm) Servlets for JavaServer Pages(tm) persistent session
data.
--
create table $data01.nsjspcat.sessdata (
session_id CHAR(48) NO DEFAULT NOT NULL,
process_name CHAR(8) NO DEFAULT NOT NULL,
rec_number INTEGER UNSIGNED NO DEFAULT NOT NULL,
valid SMALLINT UNSIGNED NO DEFAULT,
maxinactiveinterval INTEGER NO DEFAULT,
lastaccessed LARGEINT NO DEFAULT,
app_name VARCHAR(150) NO DEFAULT NOT NULL,
session_data VARCHAR(3600) CHARACTER SET ISO88591,
primary key (session_id, process_name, rec_number) )
catalog $data01.nsjspcat;