WebSphere

Purging the inactive bucket for an Informix event database

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
  1. 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).

  2. Run the eventpurgepool script to purge the connection pool:
    • For Windows operating system On Windows® systems: eventpurgepool.bat
    • For Linux operating systemFor UNIX operating system On Linux® or UNIX® systems: eventpurgepool.sh

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/tcei_purge_inactive_bucket_informix.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).