Purge Runtime Service Operations 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.

There are many reasons or occasions to purge the appmessage tables, especially during an upgrade or other activities life renaming a default local node apart from the need to keep the data in these tables manageable.

In order to purge the runtime service operations monitor tables in PeopleSoft, you will need to run the below mentioned dms. Here is brief description of each:

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

2. AppMsgPurgeArchive.dms

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

3. AppMsgPurgeLive.dms

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

For your reference, these dms of the version 8.53.06 are also shown below:

— ***************************************************************
— This software and related documentation are provided under a
— license agreement containing restrictions on use and
— disclosure and are protected by intellectual property
— laws. Except as expressly permitted in your license agreement
— or allowed by law, you may not use, copy, reproduce,
— translate, broadcast, modify, license, transmit, distribute,
— exhibit, perform, publish or display any part, in any form or
— by any means. Reverse engineering, disassembly, or
— decompilation of this software, unless required by law for
— interoperability, is prohibited.
— The information contained herein is subject to change without
— notice and is not warranted to be error-free. If you find any
— errors, please report them to us in writing.
—
— Copyright (C) 1988, 2012, Oracle and/or its affiliates.
— All Rights Reserved.
— ***************************************************************

— archive tables:
DELETE FROM PSAPMSGARCHPH;
DELETE FROM PSAPMSGARCHPD;
DELETE FROM PSAPMSGARCHPC;
DELETE FROM PSAPMSGARCHSC;
DELETE FROM PSAPMSGARCHPT;
DELETE FROM PSAPMSGARCHST;
DELETE FROM PSIBLOGHDRARCH;
DELETE FROM PSIBLOGDATAARCH;
DELETE FROM PSIBLOGIBINFOAR;

— lock tables:
DELETE FROM PSIBFCLOCK;
DELETE FROM PSIBADSLOCK;

— ***************************************************************
— This software and related documentation are provided under a
— license agreement containing restrictions on use and
— disclosure and are protected by intellectual property
— laws. Except as expressly permitted in your license agreement
— or allowed by law, you may not use, copy, reproduce,
— translate, broadcast, modify, license, transmit, distribute,
— exhibit, perform, publish or display any part, in any form or
— by any means. Reverse engineering, disassembly, or
— decompilation of this software, unless required by law for
— interoperability, is prohibited.
— The information contained herein is subject to change without
— notice and is not warranted to be error-free. If you find any
— errors, please report them to us in writing.
—
— Copyright (C) 1988, 2012, Oracle and/or its affiliates.
— All Rights Reserved.
— ***************************************************************

— archive tables:
DELETE FROM PSAPMSGARCHPH;
DELETE FROM PSAPMSGARCHPD;
DELETE FROM PSAPMSGARCHPC;
DELETE FROM PSAPMSGARCHSC;
DELETE FROM PSAPMSGARCHPT;
DELETE FROM PSAPMSGARCHST;
DELETE FROM PSIBLOGHDRARCH;
DELETE FROM PSIBLOGDATAARCH;
DELETE FROM PSIBLOGIBINFOAR;

— lock tables:
DELETE FROM PSIBFCLOCK;
DELETE FROM PSIBADSLOCK;

— ***************************************************************
— This software and related documentation are provided under a
— license agreement containing restrictions on use and
— disclosure and are protected by intellectual property
— laws. Except as expressly permitted in your license agreement
— or allowed by law, you may not use, copy, reproduce,
— translate, broadcast, modify, license, transmit, distribute,
— exhibit, perform, publish or display any part, in any form or
— by any means. Reverse engineering, disassembly, or
— decompilation of this software, unless required by law for
— interoperability, is prohibited.
— The information contained herein is subject to change without
— notice and is not warranted to be error-free. If you find any
— errors, please report them to us in writing.
—
— Copyright (C) 1988, 2012, Oracle and/or its affiliates.
— All Rights Reserved.
— ***************************************************************

Apurva Tripathi

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

Click Here to Leave a Comment Below 0 comments

Leave a Reply:

Save my name, email, and website in this browser for the next time I comment.