Clarity PPM

Expand all | Collapse all

Why CA PPM requires a "physical" database server?

Jump to Best Answer
  • 1.  Why CA PPM requires a "physical" database server?

    Posted 12-11-2017 02:53 PM

    Looking for a technical explanation about why CA PPM requires a "physical" database server.

    The platform administrators here need to justify this decision in terms of I/O per miliseconds requirements or another technical metric. 

    The release to be installed is CA PPM 15.3.



  • 2.  Re: Why CA PPM requires a "physical" database server?

    Posted 12-11-2017 08:28 PM

    Hi,

     

    CA PPM data structure is defined  by following Entity Relationship Diagrams(ERD).

    I hope it is useful for your investigation.

     

    https://docops.ca.com/ca-ppm/15-3/en/reference/ca-ppm-entity-relationship-diagrams-erd 

     

    PPM requires Relational Database to implement above ERD.  (Oracle and SQL Server are supported Database currently)

    I cannot imagine that PPM does not use Relational Database.

    Because if PPM uses flat files, I believe that critical performance issue will occur and it will be very hard to keep data integrity.

     

     

    Thank you.



  • 3.  Re: Why CA PPM requires a "physical" database server?
    Best Answer

    Posted 12-12-2017 01:42 AM

    Virtual databases are supported only on specific supported platform where we have tested against these platform. Also we have seen with virtual platform the I/O seems to be inconsistent and performance is bad.

     

    We have documented the same in our release notes too Release Notes (On Premise) - CA PPM - 15.3 - CA Technologies Documentation  

     



  • 4.  Re: Why CA PPM requires a "physical" database server?

    Posted 12-12-2017 04:02 AM

    Hi,

     

    Oh my gosh!

    I misread "physical" database server. 

     

    Thank you.



  • 5.  Re: Why CA PPM requires a "physical" database server?

    Posted 12-12-2017 09:10 AM

    Thank you Suman.

    The origin of the confusión came from the Deployment Architecture document. The Release Note explanation is very useful, but still the Deployment Architecture for 1000 users says that Database Tier and DWH Tier do not allow virtualization (VM), unlikely the other Tiers.

     

    Source: CA PPM r15_x Deployment Architecture for 1K users

     

    Regards

    Juan



  • 6.  Re: Why CA PPM requires a "physical" database server?

    Posted 12-12-2017 09:17 AM

    I will get that corrected but virtualization are allowed in supported stack



  • 7.  Re: Why CA PPM requires a "physical" database server?

    Posted 12-14-2017 04:52 PM

    Great. Thank you!