My Oracle Support Banner

E-IB: Proper Use of Integration Broker Messaging Data Archiving Process and/or Purging Scripts (Doc ID 622210.1)

Last updated on JANUARY 08, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.