PRCSYSPURGE deletes reports per the retention value:
SELECT PT_RETENTIONDAYS FROM PS_PRCSSYSTEM
Tables impacted:
- PSPRCSRQST
- PSPRCSQUE
- PSPRCSPARMS
- PS_MESSAGE_LOG
- PS_MESSAGE_LOGPARM
- PS_PRCSRQSTDIST
- PS_CDM_LIST
- PS_CDM_AUTH
- PS_CDM_FILE_LIST
Plug a file into PS's report depository - store a file into an existing folder and point url to it to access the file:
1. Choose an existing folder on web server, say /w/psft/psreports/AAA/20180119/928013 - there are some files in the folder, say AP_MATCH_111111. so Process Instance = 111111, CONTENT_ID=928013
2. Insert into 4 tables:
1. Choose an existing folder on web server, say /w/psft/psreports/AAA/20180119/928013 - there are some files in the folder, say AP_MATCH_111111. so Process Instance = 111111, CONTENT_ID=928013
2. Insert into 4 tables:
- insert into PS_PRCSRQSTDIST values (111111,'MY_OPRID',2)
- insert into PS_CDM_LIST values (111111, 928013,'AP_MATCH','Application Engine','$PS_CFG_HOME/appserv/prcs/$DB_NAME/log_output/AE_AP_MATCH_1889633','AP Matching',14,sysdate, sysdate, sysdate+7,5, '$REPORT_NODE', '$DB_NAME/20180119/928013', 9999999, 'Index.html',5,0,' ','GENERAL',0,' ',' ',' ')
- insert into PS_CDM_AUTH values (928013,111111,'MY_OPRID',2)
- insert into PS_CDM_FILE_LIST values (111111, 928013, 'AP_MATCH_1889633.log', 'LOG',2490,sysdate)
