Question
GM Onstar
US
Last activity: 4 Nov 2019 19:21 EST
Question on Creating Partitions in Pega Tables
Can we create partitions for following Pega tables to manage purging .
PC_ASSIGN_WORKLIST
PR_DATA_IH_FACT
PR_PERF_STATS
also for 2 more custom case tables -
NBAAONS_WORK
NBAAONS_HISTORY_WORK
Since Pega is a COTS product - Our DBA's need info if it is safe to create monthly partitions.
Hi,
I haven't personally tried this, however the below post has some information that may be helpful:
https://collaborate.pega.com/question/does-pega-allows-database-table-partitioning
Hope this helps!
-Kurt