Header Ads

  • Recent Posts

    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.

    1 comment:

    1. Hi, I want to delete PSREOPRTS Older than 1 Year , What retention days should I specify and where ?
      As I see there is hierarchy how this Expiration Days are selected.

      ReplyDelete

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad