MicroStrategy ONE

Purge the Change Journal

You can keep the size of the change journal to a manageable size by periodically purging older entries that you no longer need to keep.

When you purge the change journal, you specify a date and time. All entries in the change journal that were recorded prior to that date and time are deleted. You can purge the change journal for an individual project, or for all projects in a project source.

MicroStrategy recommends archiving your change journal entries before purging. For instructions on how to archive the change journal, see Export the Change Journal.

To Purge the Change Journal for All Projects in a Project Source

  1. In Developer, expand Administration, and then expand System Monitors.
  2. Right-click Change Journal Transactions and select Manage change journal.
  3. Set the date and time. All data recorded before this date and time is deleted from the change journal.
  4. To purge data for all projects, select the Apply to all projects check box. To purge data relating to the project source configuration, leave this check box cleared.
  5. Click Purge Now. When the warning dialog box opens, click Yes to purge the data, or No to cancel the purge. If you click Yes, change journal information recorded before the specified date is deleted.

    If you are logging transactions for this project source, a Purge Log transaction is logged when you purge the change journal.

  6. Click Cancel.

To Purge the Change Journal for a Single Project

  1. In Developer, right-click on the project and select Project Configuration.
  2. Expand Project definition, and then select Change Journaling.
  3. Under Purge Change Journal, set the date and time. All change journal data for this project from before this date and time will be deleted from the change journal.
  4. In the Purge timeout (seconds) field, specify the timeout setting in seconds.
  5. Click Purge Now. When the warning dialog box opens, click Yes to purge the data, or No to cancel the purge. If you click Yes, change journal information for this project from before the specified date and time is deleted.
  6. Click OK.