E-IB: Proper Use of Integration Broker Messaging Data Archiving Process and/or Purging Scripts

(Doc ID 622210.1)

Last updated on MAY 12, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.40 to 8.55 [Release 8.4]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 200765496 (initially for Tools 8.10-8.22 Application Messaging, later extended to 8.40-8.5x Integration Broker

*** Latest revision: 12-May-2016 ***

Goal

You are actively using Integration Broker, and the application messaging live transaction tables are growing quite large with time.
Those data are not needed as the messages/operations in status "Done" have already populated the correspondent data tables.

You are wondering about the proper usage of Data Mover Scripts (DMS) "AppMsgPurgeLive.dms" and "AppMsgPurgeAll.dms":
Is it safe to run one of these scripts regularly without impacting normal operation of the PeopleSoft application?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms