Installing repository dbs remotely vs locally

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
peep
Premium Member
Premium Member
Posts: 162
Joined: Mon Aug 20, 2012 6:52 pm

Installing repository dbs remotely vs locally

Post by peep »

Hi Can you please suggest

we are planning to install repository dbs for IIS 8.7 and 11.3 .
we are in debate whether to install repository databases locally or with other dataware house databases.

please provide your expert sugesstion what are the benefits and drawbacks to install repo dbs locally and

what are the benefits and drawbacks to install repo dbs remotely to IIS server.

Thanks.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Tell us how fast the network is between where you propose to install the engines and where the databases are. That will be the main consideration.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
peep
Premium Member
Premium Member
Posts: 162
Joined: Mon Aug 20, 2012 6:52 pm

Post by peep »

Hi Ray,

Thanks for responding.

We have decided to install repository db locally to avoid any network delay.

I will installing service tier , engine and repository tier on the same linux red hat server.

Closing the thread..
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Good call. That's why I asked the question. If you had elected to use a remote database, I would have advised strongly to use a dedicated, very high speed network segment.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply