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

Manager Web Application
NonStop Servlets for JavaServer Pages (NSJSP) System Administrator’s Guide—525644-003
5-20
Cleaning Up the NonStop SQL Session Data
Cleaning Up the NonStop SQL Session Data
Sessions saved by the NonStopSQLJDBCStore to a NonStop SQL database may
never get cleaned up and remain as orphan sessions when
•
The sessions are saved on an NSJSP container restart and never accessed after
the restart,
•
Or the session were backed up or swapped out to the NonStop SQL database and
not accessed again after the NSJSP container failed and was restarted.
Over time, the database may become very large.
The iTPWS_INSTALL_DIR/bin/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.
Managing Constraints
The manager web application has these constraints:
•
The manager web application only manages the web applications in a virtual host.
Therefore, you must configure a manager web application for every virtual host.
•
The manager web application manages only the running NSJSP container.
•
Any commands or changes made using the manager web application affects only
the running server processes. Therefore, any new dynamic server processes
created after the change may be inconsistent with the existing servers. This
behavior is exactly the same as the nsjsp_manager utility behavior used by prior
versions of NSJSP.
Example 5-15. 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.
Example 5-16. Using the nsjsp_cleanSessionData Script
osh> /usr/tandem/webserver/bin/nsjsp_cleanSessionData 5
Sessions that have expired at least 5 days ago will be deleted from the
NonStop™ SQL Database.