Question
3
Replies
229
Views
GM Onstar
US
Posted: November 4, 2019
Last activity: November 4, 2019
Last activity: 4 Nov 2019 19:21 EST
Closed
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.
Posted: 2 years ago
Pegasystems Inc.
US
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
Posted: 2 years ago
Pegasystems Inc.
US
Please check below pdn link. Search for "partitioning".
Posted: 2 years ago
GM Onstar
US
LInk https://pdn.pega.com/pegarules-database/about-pegarules-table-partitioning takes me to a not authorized page..