Service Operations Insight

 View Only

 CA CCC database requirements requirements

Cristinel Danie's profile image
Cristinel Danie posted Aug 17, 2021 10:35 AM
Hello folks,

my first post to this community so please indulge it if already answered (I searched this answer for almost an hour on the community and for several days on the web without any concluding answer).

I see that as a prerequisite for CA CCC an Oracle Database is needed. But I have already my environment licensed for MSSQL Database . Would it work if I would build this environment (is it stable and reliable) ?

Many thanks !

Cristi
David DuPre's profile image
David DuPre
Could you please define "CA CCC"?  The only on I can think of is "Capacity Command Center"... is that what you are asking about?

David
David DuPre's profile image
David DuPre
Oracle is the only database that will support CCC (Capacity Command Center) an old Hyperformix / CA product.

FYI. the Day_Dim table is only configured to populate up until 2021/01/01 which means if you still use CCC/CCR/DM products that it will fail for anyone installing it....

Unless you update the installer DML file:
    \ScriptFiles\DML\load_day_dim.sql 
before you install it.

If you have an old system you are trying to restart you must find and run that DML code with a new value set for:
either nLoopCount - add 3650 to it for 10 more years.
or move the start date up a few years.  
---- Code below -----------
declare
   dDate                date;
   dStartDate        date := to_date('01/01/1990','MM/DD/YYYY');
   nLoopCount     INTEGER :=  11323;
--------------- 
Only setup to run 30 years.
It will still work if you adjust this code.

Hyperformix CCC/CCR/DM -- still works!
David