WebSphere

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

On Linux®, UNIX®, and Windows® systems, the database purge utility for a DB2® database is implemented as a shell script or batch file.

Procedure
To purge the inactive bucket, run one of the following commands:

The parameters of this command are as follows:

dbalias
The database alias. The event database must be catalogued on the DB2 client; if you are running the script on the DB2 server, the database is already catalogued.
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 prompts you 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 or USEREXIT database configuration settings enabled). By default, the event database does not use forward recovery.

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