Purge

Purge, a data clean-up operation, removes the data from the database, cache, and text index unlike the logical delete done in other delete operations. Purge enables you to keep only the required data and reduce the disk capacity required.

Use the command line to purge the following objects:

  • Records
  • Repositories
  • Data sources
  • Events

To trigger purge, use the command line utility $MQ_HOME/bin/datacleanup.sh.

For example, the command datacleanup.sh -o repository -a 69390 -rn ALL -m 20101 purges all records of all repositories in enterprise ID 69390 and member ID 20101.

The purge log file (located in $MQ_COMMON_DIR\Temp\Year\Month\Date\Hour) provides details such as:

  • Purge Start Date
  • Member who initiated the purge
  • Event Descriptor
  • Repository or the Repositories’ ID to which Purge is applicable.
  • Exec mode
  • Number of rows deleted
  • Number of records deleted
  • All relevant data