The database purge utility for an Informix® event database is implemented as
a stored procedure.
Before you begin
To use the utility for an Informix database,
you must run the Informix dbaccess
command in an environment that has been properly sourced for the Informix environment variables.
Refer to the Informix documentation
for more information.
Procedure
- To purge the inactive bucket, run the stored procedure
using dbaccess:
dbaccess - fastpurge.sql
The
fastpurge.sql file is stored in the same location as the other scripts
generated during database configuration (the default location is profile_root/databases/event/node/server/dbscripts/informix).
- Run the eventpurgepool script to purge the connection pool:
On Windows® systems: eventpurgepool.bat

On Linux® or UNIX® systems: eventpurgepool.sh