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-94
Determining the Storage Capacity of the Persistent
Store
Cleaning the NonStop SQL Session Data
Sessions saved by the NonStopSQLJDBCStore to a NonStop SQL database may
never get deleted and will remain as orphan sessions when:
The sessions are saved during an NSJSP container restart and are never
accessed after the restart, or
The sessions are backed up, or swapped out to the NonStop SQL database and
are never accessed again after an NSJSP container fails and is restarted.
As a result, over a period of time, the session database may become very large.
Therefore, It is important to clean the session store periodically to prevent the table
from filling up, which can lead to session creation errors.
The <NSJSP_HOME>/conf/nsjsp_cleanSessionData script enables you to delete
the sessions that have expired prior to a specified number of days (the nDays
parameter) - see Example 3-75 for details. This script should be run periodically to
clean the session. You may run this script manually as shown in Example 3-76
, or
preferably it should be automated through a job scheduler such as cron or NetBatch.
Example 3-74. The Sample Output of a fup info <filename>,detail
Command
3> fup info $DATA00.ZSDG8WWM.X8BXVN00 ,detail
$DATA00.ZSDG8WWM.X8BXVN00 26 Apr 2010, 10:44
SQL ANSI TABLE
ANSI NAME NSJSPCAT.NSJSPSCH.SESSDATA
RESOURCE FORK \POS02.$DATA00.ZSDG8WWM.X8BXVN01
SYSTEM METADATA \POS02.$OSS03.ZSD0
VERSION 1200
TYPE K
FORMAT 2
CODE 550
EXT ( 16 PAGES, 64 PAGES, MAXEXTENTS 160 )
PACKED REC 3852
BLOCK 4096
KEY ( COLUMN 0, ASC ,
COLUMN 1, ASC ,
COLUMN 2, ASC )
PART ( 0, \POS02.$DATA00.ZSDG8WWM.X8BXVN00 )
PART ( 1, \POS02.$DATA01.ZSDG8WWM.PWHXVN00 )
PART ( 2, \POS02.$FC31.ZSDG8WWM.PWJXVN00 )
PART ( 3, \POS02.$FC34.ZSDG8WWM.QS9XVN00 )
AUDIT
BUFFERED
AUDITCOMPRESS
OWNER 101,2
SECURITY (RWEP): *SQL
DATA MODIF: 5 Apr 2010, 15:12
CREATION DATE: 29 Mar 2010, 12:16
REDEFINITION DATE: 29 Mar 2010, 12:16
LAST OPEN: 5 Apr 2010, 15:11
EOF: 2224128 (10.7% USED)
EXTENTS ALLOCATED: 71
INDEX LEVELS: 2
PARTITION ARRAY FORMAT2ENABLED