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

Manager Web Application

NonStop Servlets for JavaServer Pages (NSJSP) 6.0 System Administrator’s Guide—544548-004

5-20

Cleaning the NonStop SQL Session Data

Sessions saved by the NonStopSQLJDBCStore to a NonStop SQL database may

never get cleaned up and will remain as orphan sessions when:



the sessions are saved on 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 the NSJSP container fails and restarts.

As a result, over a period of time, the database may become very large.

The NSJSP_HOME/conf/nsjsp_cleanSessionData script enables you to clean up

the sessions that have expired prior to a specified number of days (the nDays

parameter). Run this script periodically as part of a cron job or any other

administrative process. Example 5-11 shows the SQL session data cleanup script.

Example 5-12 shows the nsjsp_cleanSessionData script.

Example 5-11. SQL Session Data Cleanup Script

Usage: nsjsp_cleanSessionData nDays

where nDays: Number of days for which session data is to be

preserved/saved. Sessions that have expired more

than 'nDays' ago will be deleted. A value of zero (0)

will delete all the expired sessions.