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
- Connect to the iSeries system
using a terminal application that emulates a 5250 terminal, such as IBM® Personal Communications.
- 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.
- Run the strsql command.
- 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()