The Runtime writes session information to the "log database". This article shows how to purge sessions from this database.
The purge described in this article will delete rows from the Runtime's session tables. Please note that some RDBMS systems need DBA operations in order to free the physical storage of tables and indexes (defragmentation, move, shrink, rebuild...).
Manual purge from the Sessions view
The purge can be executed manually directly from the Designer. The purge will be executed on the Runtime to which the Designer is connected.
Click on the "Delete until" button and you will prompted for a date. The purge will delete all sessions until the specified date/time.
You can also click on the "Delete all" button, which will delete ALL the sessions from the log database.
Using the "purge" command
Another way of purging is to execute the purge command.
This can be done from the Command tab in the Runtime editor (available in Analytics and in the Designer) :
A few examples for this command :
- purge keep 100 session: deletes all sessions except the last 100 sessions
- purge keep 50 session status killed: deletes all sessions with status "killed" except the last 50 killed sessions. The sessions with other status are left.
- purge keep 10 day: deletes all sessions older than 10 days.
- purge keep 3 session sessionname MONTHLY%: deletes all sessions whose name starts with "MONTHLY" except the 3 latest sessions.
You can also execute this command from your OS command line, using the startcommand utility :
> startcommand.bat "connect to localhost port 42000;purge keep 5 day"
Please note that when you execute a purge command on a runtime that uses a log database that is shared with other runtimes, it will affect all the sessions that are stored in the database (not only those that were written by the runtime that is executing the purge command).
Scheduling a purge in the Runtime Scheduler
The scheduler can purge the session logs automatically. To do this, select the "Purge" tab in the Runtime editor (available in Analytics and in the Designer) :
For more information on the sheduler and Cron examples, please read the Stambia Designer help.