Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Referential Integrity on Service Center 5

Referential Integrity on Service Center 5

Referential Integrity on Service Center 5

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

Actually, I found it difficult to believe that Peregrine SC did not have some form of data integrity. File system design was abandoned decades ago primarily due to data inconsistencies and update effort. In addition, it seems as though not many people have an issue with the fact that data integrity is not standard, which is a massive surprise to me.

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

Yes, Integrity has been an issue at other customers and that is why they put processes in place to deal with this,  i.e. who has access to the support data inside SC so that data anomolies aren't created. Also, The SC developer has always been in close contact with the Report developer to assist in what data to extract from which fields.

RE: Referential Integrity on Service Center 5

Some of my clients handle integrity by putting processes in place and making use of data administrators to ensure that data are always valid.  However this is a manual process which is very time consuming.

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

ServiceCenter 5.1 has something called the "The Cascade Update Utility". The function of this utility is to "allow Administrators to maintain database integrity and consistency by altering the data in one or more dependent files to match changes made to data in a source file".

[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).



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close