Purging the inactive bucket for a DB2 database (Linux, UNIX, or Windows systems)

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 (found in the profile_root/event/dbscripts/db2 folder):

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.

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)