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.
— ***************************************************************
—
— ******************************************************************
— ******************************************************************
—
— SourceSafe Information:
—
— $Header:: /pt843/SCRIPTS/BSE/AppMsgPurgeAll.dms 9 2/19/03 $
—
— ******************************************************************
— Purges all Application Messaging queue data. Data in both live
— and archived tables are purged.
— ******************************************************************
SET LOG APPMSGPURGEALL.LOG;
— core tables:
DELETE FROM PSAPMSGPUBHDR;
DELETE FROM PSAPMSGPUBDATA;
DELETE FROM PSAPMSGPUBCON;
DELETE FROM PSAPMSGSUBCON;
DELETE FROM PSAPMSGPUBERR;
DELETE FROM PSAPMSGPUBERRP;
DELETE FROM PSAPMSGPUBCERR;
DELETE FROM PSAPMSGPUBCERRP;
DELETE FROM PSAPMSGSUBCERR;
DELETE FROM PSAPMSGSUBCERRP;
DELETE FROM PSAPMSGPCONDATA;
DELETE FROM PSAPMSGSCONDATA;
DELETE FROM PSIBERR;
DELETE FROM PSIBERRP;
DELETE FROM PSIBDEBUGLOG;
DELETE FROM PSAPMSGIBATTR;
DELETE FROM PSIBAEATTR;
DELETE FROM PSIBRELMSGSEQ;
DELETE FROM PSIBRELMSGHDR;
DELETE FROM PSIBRELMSGDATA;
DELETE FROM PSAPMSGDOMSTAT;
DELETE FROM PSAPMSGDSPSTAT;
— synchronous core tables:
DELETE FROM PSIBLOGHDR;
DELETE FROM PSIBLOGDATA;
DELETE FROM PSIBLOGERR;
DELETE FROM PSIBLOGERRP;
DELETE FROM PSIBLOGIBINFO;
— 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.
— ***************************************************************
—
— ******************************************************************
— ******************************************************************
—
— SourceSafe Information:
—
— $Header:: /pt843/SCRIPTS/BSE/AppMsgPurgeArchive.dms 9 2/1 $
—
— ******************************************************************
— Purges the archived Application Messaging queue data.
— ******************************************************************
SET LOG APPMSGPURGEARCHIVE.LOG;
— 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.
— ***************************************************************
—
— ******************************************************************
— ******************************************************************
—
— SourceSafe Information:
—
— $Header:: /pt843/SCRIPTS/BSE/AppMsgPurgeLive.dms 9 2/19/0 $
—
— ******************************************************************
— Purges the live Application Messaging queue data.
— ******************************************************************
SET LOG APPMSGPURGELIVE.LOG;
— core tables:
DELETE FROM PSAPMSGPUBHDR;
DELETE FROM PSAPMSGPUBDATA;
DELETE FROM PSAPMSGPUBCON;
DELETE FROM PSAPMSGSUBCON;
DELETE FROM PSAPMSGPUBERR;
DELETE FROM PSAPMSGPUBERRP;
DELETE FROM PSAPMSGPUBCERR;
DELETE FROM PSAPMSGPUBCERRP;
DELETE FROM PSAPMSGSUBCERR;
DELETE FROM PSAPMSGSUBCERRP;
DELETE FROM PSAPMSGPCONDATA;
DELETE FROM PSAPMSGSCONDATA;
DELETE FROM PSIBERR;
DELETE FROM PSIBERRP;
DELETE FROM PSIBDEBUGLOG;
DELETE FROM PSAPMSGIBATTR;
DELETE FROM PSIBAEATTR;
DELETE FROM PSAPMSGDOMSTAT;
DELETE FROM PSAPMSGDSPSTAT;
— synchronous core tables:
DELETE FROM PSIBLOGHDR;
DELETE FROM PSIBLOGDATA;
DELETE FROM PSIBLOGERR;
DELETE FROM PSIBLOGERRP;
DELETE FROM PSIBLOGIBINFO;
— lock tables:
DELETE FROM PSIBFCLOCK;
DELETE FROM PSIBADSLOCK;
