Referential Integrity on Service Center 5
Referential Integrity on Service Center 5
(OP)
We are currently implementing SC5 as a Tivoli (TSD) replacement on an Oracle db. I have some serious concerns about data integrity and I am not sure of whether it is the manner in which the agents are implementing the product or whether it is the product itself. Can anyone provide me with information regarding this 'problem'?
RE: Referential Integrity on Service Center 5
There is no RI in an default system. the best way to implement this would be through the built in tools that peregrine provides. This would be very time consuming for the whole product and therefore the area of concern should be specified. Why do you question the agents ?
RE: Referential Integrity on Service Center 5
In terms of the agents, I think they are pretty clued up with respect to SC however, there is no harm in establishing that what they say is valid.
I see that you are a programmer working on SC. Has integrity not been an issue on your implementation on SC, especially relating to update anomalies? If reporting is performed with inconsistent data, the reports will yield variable results depending on the criteria you use in the 'where' clause of the query e.g. company, company_id, company_code etc.
RE: Referential Integrity on Service Center 5
RE: Referential Integrity on Service Center 5
At other clients we used the tools supplied by Peregrine to build referential integrity into the sysem, but as pietie said it would be very time consuming to build it into the entire system, therefore you should identify the areas of concern and concentrate on those.
Although building referential integrity into the system was more expensive in the short term, the clients preferred this option as it eliminated an extra headcount in the long term
RE: Referential Integrity on Service Center 5
[Above quotation is from the System Tailoring manual for SC5.1, Volume 2]
I want to repeat that this utility exists first in the 5.1 version of SC, so do not try to find it in any earlier version (including 5.0).
cheers,
JJ