migrating to AWS, question about some large tables
(cf. SR-B86277)
our installation is migrating from home-hosted to AWS. looking to move the Oracle DB, our DBA has raised a question about some large tables, whether they need to be migrated.
AES_PEG_RULE.CMP3$177451
EOS_PEG_ADM1.CMP3$79301
EOS_PEG_ADM1.CMP3$79343
EOS_PEG_RULE.CMP3$147855
Looks to me like there is a Pega installation with RULE & DATA in separate schemas, and another instance for AES.
These files are collectively about 60GB. They have not been accessed since about 12 months back. That feels like around the time we migrated PRPC versions. Are they perhaps leftover temporary files from the migration?
***Edited by Moderator Marissa to update categories/SR Details***
Pegasystems Inc.
US
What is in these CMP3 tables? That is not a pega table name that I know of so maybe the table structure will give us an idea of what they are.
Pegasystems Inc.
US
I haven't received the table structure yet but I did a little googling and these tables were created by Oracle. They are related to compression advisory. From what I see it looks like these are temporary tables that will be deleted at some point but from some posts it does not look like they are deleted in a timely manner. I would ask Oracle about them but I would not expect that they need to be migrated.