Purging Runtime Monitor Tables

The PeopleSoft system provides a collection of Data Mover scripts that you can run to purge the runtime Service Operations Monitor tables within a database. These scripts reside in the PS_HOME\scripts directory on your file server. The following table describes the purpose of each script.

Warning! Shut down the application server before running any of the Data Mover scripts described in this section.

Script Name

Description

AppMsgPurgeAll.dms

Deletes queue data from every archive or live runtime Service Operations Monitor table in the database, regardless of status. Typically, you run this script after an upgrade or while switching from a demonstration to a production environment.

AppMsgPurgeArchive.dms

Deletes queue data from every archive runtime Service Operations Monitor table in the database.

AppMsgPurgeLive.dms

Deletes queue data from every live runtime Service Operations Monitor table in the database.