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-21

Cleaning the NonStop SQL Session Data

Example 5-12. Using the nsjsp_cleanSessionData Script

osh> /usr/tandem/webserver/servlet_jsp/conf: nsjsp_cleanSessionData 0

NonStop(tm) Servlets for JavaServer Pages(tm)

Persistent Sessions Cleanup Script

T1222 v6.0

_________________________________________________________________

Cleans up the persistent session data stored in a NonStop(tm) SQL

database for NonStop(tm) Servlets for JavaServer Pages(tm).

Persistent Session Store type is SQL/MX [y(default) or n]:

Please enter the Persistent Session Catalog [T1222CAT.T1222SCH] :

nsjspcat.nsjspsch

Persistent Sessions Catalog = nsjspcat.nsjspsch

Persistent Sessions Table = nsjspcat.nsjspsch.SessData

Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.2

>>DELETE FROM nsjspcat.nsjspsch.SessData

+>WHERE (Juliantimestamp(current) -

+> Juliantimestamp(timestamp '1970-01-01:00:00:00.00') -

+> (1000 * lastaccessed) ) >

+> (1000 * 1000 * (maxinactiveinterval + (0 * 24 * 60 * 60)) );

--- 0 row(s) deleted.