PeopleSoft Purge Process for Process Scheduler

What does PRCSYSPURGE process do? 
The PRCSYSPURGE application engine program is run on the master Process Scheduler server.
Updates statistics and purges process request tables.

1. Cleans up Report Manager Repository and purges Report Repository tables.
2. If more than one Process Scheduler server exists, the application engine program PRCSRVCLN is scheduled to run. This program cleans up the Report Repository tables for a specific server.
3. The application engine program PSXPARCHATTR gets run to archive BI Publisher report-related metadata and the URLs of the report files.

What tables are affected by PRCSYSPURGE?

The purge process updates the statistics of the following tables before deleting entries from them:

This step removes all expired entries from the process request tables. These tables include:

1. PSPRCSRQST - Process Request table
2. PSPRCSQUE - Process Request Queue
3. PSPRCSCHLDINFO
4. PSPRCSPARMS - Process Request Parameters
5. PS_MESSAGE_LOG - Message Log Table
6. PS_MESSAGE_LOGPARM - Message Log Parameter Table
7. PSPRCSRQSTXFER
8. PSPRCSRQSTTEXT
9. PSPRCSRQSTFILE
10. PSPRCSRQSTMETA
11. PSPRCSRQSTSTRNG
12. PSPRCSRQSTTIME
13. PS_PRCSRQSTNOTIFY
14. PS_PRCSRQSTURL
15. PS_PRCSFILE
16. PSPRCSJOBSTATUS
17. PSNVSBATCHRSTRT
18. PS_PRCSRQSTDIST - Content Distibution Manager
19. PS_CDM_LIST - Content Distribution Manager - Content List
20. PS_CDM_AUTH - Content Distribution Manager - User Access
21. PS_CDM_FILE_LIST - Report Manager - File List
22. PS_CDM_TRANSFER
23. PSRF_RATTR_TBL
24. PSRF_RSCRTY_TBL
25. PSRF_RDESC_TBL
26. PSRF_RDESC_LANG
27. PSRF_RINFO_TBL
28. PSPRCSRQSTARCH.
29. Clean the archive table PS_CDM_LIST_PURGE

The option to enable or disable updating statistics is set in the process scheduler configuration file - psprcs.cfg. In the [Process Scheduler] section in psprcs.cfg file, check the value for 'Update Table Stats on Purge'. A value of 0 disables updating of the table statistics while value of 1 enables updating of table statistics.

In the [PSTOOLS] section, check the value for 'DbFlags'. A value of 0 issue a command to issue the update table statistics to the database while a value of 1 will not update statistics. It is essential to set DBFlags to 0 while setting Update Table Stats on Purge to 1. Because only if the DbFlags allows statistics update, the purge process can update statistics.


At what frequency PRCSYSPURGE process runs?
PRCSYSPURGE process runs based upon the frequency and options set in the below navigation:
PeopleTools > Process Scheduler > System Settings > System Purge Options


Security Setup required to run PSRCSYSPURGE Process:

1. The PRCSYSPURGE program is delivered with the TLSALL process group. The user running the purge process must have access to the process group TLSALL within the primary process profile.
2. The user running the process is attached to the 'ProcessSchedulerAdmin' role.
3. The user running the process is attached to the 'ReportDistAdmin' role.
4. The Oprid must have the "Can start Application Server" permission assigned i.e. this permission list along with the TLSALL process group be attached to the user through any of the roles assigned to him/her.
5. The Oprid must have a valid Process Profile and Primary Permission List.

To find out all the OPRIDs having access to run PRCSYSPURGE program, use the below SQL statement:
SELECT c.oprid
FROM   ps_prcsdefngrp a,
       psauthprcs b,
       psoprcls c
WHERE  a.prcstype = 'Application Engine'
       AND a.prcsname = 'PRCSYSPURGE'
       AND a.prcsgrp = b.prcsgrp
       AND b.classid = c.oprclass

Security Setup to run PRCSYSPURGE process:

1)      Navigate to PeopleTools -> User Profiles

2)      Search and Select the Oprid for which access needs to be given.

3)      Navigate to the Roles tab and add a new row.

4)      Assign the "ProcessSchedulerAdmin" role.

5)      Add another new row and assign the "ReportDistAdmin" role.

6)      Add another new row and assign the "PeopleSoft User" role.

7)      Add another new row and assign the "PeopleTools" role.

8)      Now go to the General tab and note the Process Profile value.

9)      Save the component.

10)  Now go to the navigation: PeopleTools > User Profiles > Permissions & Roles

11)  Select Permission Lists and search for the Permission List noted in Step 8.

12)  On the General tab, select the "Can Start Application Server?" checkbox.

13)  Select the Process tab and in the "Process Group" link enter a new value: "TLSALL".

14)  Hit Ok to return to the previous page and Save.

Configuration Steps to run PRCSYSPURGE purge program:

1. Define report nodes for all active process schedulers.
2. Configure Master Scheduler as a Master Scheduler must run for the purge process to run.
3. Ensure that the user ID that starts the process scheduler is included in a process group for PRCSYSPURGE. The PRCSYSPURGE program is delivered with the process group TLSALL.
4. Configure the System Purge Options page.
5. Enable Purge.