On Linux, UNIX, and Windows systems, the rapid purge utility for
a DB2 database is implemented as a shell script or batch file.
Steps for this task
To purge the inactive bucket, use one of the following commands:
The parameters of this command are as follows:
- dbalias
- The database alias. The event database must be cataloged on the DB2 client;
if you are running the script on the DB2 server, the database is already cataloged.
- dbuser
- The database user ID to use when connecting to the event database.
- dbpassword
- The password to use for the specified user ID. This parameter is optional;
if you do not specify the password, the DB2 database will prompt for it.
- copydir
- The path to a directory to be used for the files generated by the load
utility. This parameter is required only if you have enabled forward recovery
for the event database (with the LOGRETAIN and USEREXIT database configuration
settings enabled). By default, the event database does not use forward recovery.