DX Application Performance Management

  • 1.  Team Center Data retention settings

    Posted Dec 16, 2016 03:14 AM

    Hi All,

     

    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?

     

     

    Regards,

    Mukesh Singh



  • 2.  Re: Team Center Data retention settings

    Broadcom Employee
    Posted Dec 16, 2016 09:34 AM

    Hi Mukesh,

     

    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.

     

    Thanks,
    Matt



  • 3.  Re: Team Center Data retention settings
    Best Answer

    Broadcom Employee
    Posted Dec 16, 2016 09:47 AM

    Hi Mukesh,

     

    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

     

    cheers

    Mike

     

     

     



  • 4.  Re: Team Center Data retention settings

    Broadcom Employee
    Posted Dec 16, 2016 09:50 AM

    Hi Mukesh:

        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

     

    Thanks

    Hal German



  • 5.  Re: Team Center Data retention settings

    Broadcom Employee
    Posted Dec 16, 2016 10:00 AM

    Hi Mukesh:

        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



  • 6.  Re: Team Center Data retention settings

    Posted Dec 16, 2016 11:54 AM

    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

     

    Regards,

    Mukesh

     

    On 16-Dec-2016 8:31 PM, "Hallett_German" <communityadmin@communities-



  • 7.  Re: Team Center Data retention settings

    Broadcom Employee
    Posted Dec 16, 2016 12:10 PM

    Hi Mukesh:

       Glad that the KB was of help.

          Please post the idea here so others (like me) can vote for it...

    Thanks

    Hal German



  • 8.  Re: Team Center Data retention settings

    Posted Dec 19, 2016 12:43 AM

    Hi All,

     

    The below KB suggested by Mike has fulfilled my requirement and it helps

    control data retention of AppMap which is displayed in Team Center.

     

    https://www.ca.com/us/services-support/ca-support/

    ca-support-online/knowledge-base-articles.TEC1846866.html

    <https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1846866.html>

     

     

    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

    week.

     

    introscope.apm.pruning.enabled=true

    introscope.apm.pruning.cron.trigger.expression=0 0 6 * * ?

    introscope.apm.data.agingTime=1 DAY

    introscope.apm.data.preserving.time=6 DAYS

    introscope.apm.data.obsolete.time=5 DAYS

     

    Thanks Mike and everyone for your help

     

     

    Regards,

    Mukesh Singh

     

     

    On Fri, Dec 16, 2016 at 10:40 PM, Hallett_German <