WebSphere

Purging the inactive bucket for a DB2 event database (iSeries systems)

On iSeries® systems, the database purge utility for a DB2® event database is implemented as a stored procedure.

About this task

To purge the inactive bucket:
Procedure
  1. Connect to the iSeries system using a terminal application that emulates a 5250 terminal, such as IBM® Personal Communications.
  2. Log in with a user ID that has sufficient privileges to run the fast purge stored procedure. The user ID used to create the event database is recommended.
  3. Run the strsql command.
  4. Type the following SQL statement:
    call collection/fast_purge()
    collection is the name of the collection that contains the event database. The default collection is event:
    call event/fast_purge()

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_db2_iseries.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).