WebSphere WebSphere Enterprise Service Bus, Version 6.0.1 Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Purging the inactive bucket for a DB2 database (z/OS systems)

On z/OS systems, the rapid purge utility for a DB2 event database is implemented using the DB2 load utility.

Why and when to perform this task

To purge the inactive bucket:

Steps for this task

  1. Use the eventbucket.jacl 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 profile_path/event/dbscripts/db2zos directory (profile_path is the path to the directory containing the profile for the WebSphere ESB runtime environment. Upload one of the following files:
    • If bucket 0 is inactive, upload fastpurge00.ctl.
    • If bucket 1 is inactive, upload fastpurge01.ctl.
    Note: The control file must be uploaded with a fixed record format and a logical record length of 80.
  3. On the z/OS host, 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 the Enter key to continue to the next panel.
  6. In the recdsn entry field, specify the name of the data set containing the uploaded control file.
  7. Press the Enter key. The JCL script to purge the inactive bucket is generated.
  8. Press the Enter key to clear the output messages.
  9. Edit the generated JCL script as needed.
  10. Submit the JCL script.

Task topic

Terms of Use | Rate this page

Timestamp iconLast updated: 13 Dec 2005
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.websphere.wesb.doc\doc\tcei_admin_purgeInactiveBucketDb2Zos.html

(C) Copyright IBM Corporation 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)