AnsweredAssumed Answered

Managing DB size

Question asked by gilry01 Employee on Aug 14, 2017
Latest reply on Aug 16, 2017 by Jennifer_Jessup

PAM 4.2SP2

 

Can someone point me to anything related to PAM DB size? My DB is over 100GB. I've tried steps outlined in

https://communities.ca.com/message/241760483 and it won't let me drop or truncate the C2OServiceOperationInstance table and it's over 60GB by itself. I don't need reporting data and set the OasisConfig.properties file as outlined in the thread but it looks like it's still putting data in this table. I also tried using the option to purge reporting data from the GUI but not sure it's doing anything since the DB and tables look the same and the same size.

Outcomes