WebSphere

Purging the inactive bucket for a DB2 event database

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
  1. Run the eventbucket command to identify the inactive bucket (bucket 0 or bucket 1).
  2. 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.
  3. Go to the ISPF DB2I Primary Option Menu and select the Utilities option.
  4. 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
  5. Press Enter to continue to the next panel.
  6. In the recdsn entry field, type the name of the data set containing the uploaded control file.
  7. Press Enter. The JCL script to purge the inactive bucket is generated.
  8. Press Enter to clear the output messages.
  9. Edit the generated JCL script as needed.
  10. 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.

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