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.