The database purge utility for a DB2® event database is implemented using the DB2 load utility.
About this task
To purge the inactive bucket:
Procedure
- Run the eventbucket command to identify
the inactive bucket (bucket 0 or bucket 1).
- Upload the appropriate utility control file. These
files are generated during database configuration and are located
in the /event/dbscripts/db2zos directory.
Upload one of the following files:
- If bucket 0 is inactive, upload the fastpurge00.ctl file.
- If bucket 1 is inactive, upload the fastpurge01.ctl file.
Upload format: The control
file must be uploaded with a fixed record format and a logical record
length of 80.
- Go to the ISPF DB2I Primary Option Menu and select the Utilities option.
- Specify the following information:
Field |
Value |
Function |
EDITJCL |
Utility |
LOAD |
Statement Data Set |
The name of the data set containing the uploaded control
file |
LISTDEF |
NO |
Template |
NO |
- Press Enter to continue to the next panel.
- In the recdsn entry field, type the name of the data set
containing the uploaded control file.
- Press Enter. The JCL script to purge the
inactive bucket is generated.
- Press Enter to clear the output messages.
- Edit the generated JCL script as needed.
- Submit the JCL script.
Results
The generated JCL script can be reused. After you create the
scripts for purging both buckets (0 and 1), you do not need to repeat
this entire procedure.