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 JUNE 02, 2024

Applies to:

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

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.