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

Configuring NSJSP
NonStop Servlets for JavaServer Pages (NSJSP) System Administrator’s Guide—525644-003
3-48
Creating a NonStop SQL Database to Store the
Persistent Session Data
$Volume.SubVolume). This subvolume (disk) should be a TMF-audited data
volume.
To support the persistent session database scalability, partition the session data. This
can be done either by adding the partitions at the NonStop SQL table creation time or
on-the-fly by using the ALTER TABLE command in the NonStop SQL Command
Interpreter (SQLCI). Partitioning can be done by adding the partition option to the
CREATE TABLE command, as shown in Example 3-32.
Example 3-33 on page 3-49 shows how to add two partitions based on the value of the
session_id key. The two partitions (in addition to the main table) are indicated by the
two parameters passed to the partition option. These parameters are
=TheFirstSessionPartition and =TheSecondSessionPartition values.
Replace these two values with Guardian locations of the form $Volume.SubVolume.
These two subvolumes (disks) should be TMF-audited data volumes.
Note. The following example assumes that you are creating a NonStop SQL/MP database
table. If you wish to create a NonStop SQL/MX database table, be aware that the maximum
record size limit is 4036 bytes (unlike the 4096 byte limit in SQL/MP). As a result, you will have
to reduce the size of app_name field to VARCHAR(200) in order to create a NonStop SQL/MX
database table.
Example 3-32. SQL Script for Configuring Persistent Sessions
sqlci> create catalog =TheT1222SessionCatalog secure "OOOO";
sqlci> create table =TheT1222SessionCatalog.SessData (
session_id VARCHAR(48) NO DEFAULT NOT NULL,
process_name VARCHAR(8) NO DEFAULT NOT NULL,
rec_number INTEGER UNSIGNED NO DEFAULT NOT NULL,
app_name VARCHAR(255) NO DEFAULT NOT NULL,
session_data VARCHAR(3712) CHARACTER SET ISO88591,
valid SMALLINT UNSIGNED NO DEFAULT,
maxinactiveinterval INTEGER NO DEFAULT,
lastaccessed LARGEINT NO DEFAULT
primary key (session_id, process_name, rec_number) )
organization key sequenced
audit
catalog =TheT1222SessionCatalog;