In our environment, we don't have CEM hence we had very limited storage for APMDB as we were using APM 9.x. But now after 10.3 upgrade we see significant increase in APMDB size and it seems APM Team Center is storing those data. Like CEM retention settings, do we have retention settings for Team Center data as well?
I checked the configuration files and do not see any retention settings for team center. Adding SergioMorales Lynn_Williams Hiko_Davis Guenter_Grossberger Chris_Kline for additional input.
Try this Tec Doc - https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1846866.html - if I interpret what you are reporting correctly I think it will help
This may end up be an enhancement but it may help to know
- Which tables/partitions and fields within those tables are large/growing?
We can then see what can be done today to trim the file manually/automatically
Awaiting to hear back if what Mike proposed is the issue or other tables are impacted. Please let us know the details requested.
Thanks Hal German
Hi Mike, Hal,
I went through the KB and it is indeed helpful in controlling the db size
manually, will try to perform the steps on monday but I feel having a
property to control retention will be more convenient hence will open an
Idea for the same.
Thanks a lot
On 16-Dec-2016 8:31 PM, "Hallett_German" <communityadmin@communities-
Glad that the KB was of help.
Please post the idea here so others (like me) can vote for it...
The below KB suggested by Mike has fulfilled my requirement and it helps
control data retention of AppMap which is displayed in Team Center.
By default the property "introscope.apm.data.preserving.time" is set to 365
days and in my case APMDB was using 78% of the disk just for 2 months of
data because I have 4 APM Clusters connecting to one central postgres DB.
Using the above property in combination with few other properties in all
the clusters, my APMDB usage has gone below to 25%. Below are the settings
which I have used because I don't need TeamCenter data which is more than a
introscope.apm.pruning.cron.trigger.expression=0 0 6 * * ?
Thanks Mike and everyone for your help
On Fri, Dec 16, 2016 at 10:40 PM, Hallett_German <