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. |