NonStop Servlets for JSP System Administrator's Guide

Programming and Management Features
NonStop Servlets for JavaServer Pages (NSJSP) System Administrator’s Guide—525644-001
4-14
The nsjsp_manager User Interface
The nsjsp_cleanSessionData script cleans up orphan or expired sessions from
the NonStop SQL database stored for persistent sessions support (see Configuring
Persistent Sessions on page 3-34 for more details).
The default value of 7 for number of days means that sessions that have expired more
than 7 days ago will be deleted from the NonStop SQL database.
Example 4-11 a screen snap-shot of the nsjsp_manager user interface invoking the
nsjsp_cleanSessionData script.
Example 4-11. nsjsp_manager Clean NSJSP Session Data
#---------- NSJSP Manager Main Menu ----------#
0) List All Web Applications
1) Start a Web Application
2) Stop a Web Application
3) Install a Web Application
4) Reload a Web Application
5) Remove a Web Application
6) Clean NSJSP Session Data
7) Clean NSJSP Log Files
8) Change NSJSP Manager Log File
9) Exit
#-------------------------------------------#
Enter your selection ([0]-9) ...... 6
Enter number of days for which session data is to be preserved/saved... [7]
NonStop(tm) Servlets for JavaServer Pages(tm)
Persistent Sessions Cleanup Script
T1222V20_17MAR03_BASE_V200_5
_________________________________________________________________
Cleans up the persistent session data stored in a NonStop(tm) SQL
database for NonStop(tm) Servlets for JavaServer Pages(tm).
Persistent Sessions Catalog = $DATA.T1222CAT
Persistent Sessions Table = $DATA.T1222CAT.SessData
SQL Conversational Interface - T9191G07 - (21JUN01)
COPYRIGHT COMPAQ COMPUTER CORPORATION 1987-2001
>>>>DELETE FROM $DATA21.T1222CAT.SessData
+>+>WHERE (Juliantimestamp(current) -
+>+> Juliantimestamp(timestamp '1970-01-01:00:00:00.00') -
+>+> (1000 * lastaccessed) ) >
+>+> (1000 * 1000 * (maxinactiveinterval + (7 * 24 * 60 * 60)) );
*** WARNING from SQL [100]: No rows selected or modified.
--- 0 row(s) deleted.
>>>>
>>
End of SQLCI Session