Hi,
In order to install and configure Datastage and DB ,Is it good to install and coonfigure them on the same server or it would be better if we can have on different servers.
What can be the demerit if we follow with second approach.
Can any one suggest me the best approach out of these two before i go with proper installation of DS and DB by considering all merits and demerits.
Thanks
Reg Datastage and Database installation and config
Moderators: chulett, rschirm, roy
There is no simple and correct answer. The answer depends upon the computer configurations when separate vs. when on the same box and also on your connectivity between the systems - how fast is the network and does anyone else use it?
Normally the database engine is on a different system from the ETL tool.
Normally the database engine is on a different system from the ETL tool.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Putting the database and DataStage together on the same box *might* give you faster load and extract times for that staging database - however it will be fighting with the DataStage engine for access to RAM, disk I/O and CPU power. Generally since you pay per CPU licenses for both the database and DataStage it is beneficial to put them on separate hardware so you get the full value for those licenses. DataStage will use every bit of CPU and RAM you can give it.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I agree with that. It's a good general rule that's been taught on Windows sys admin training since Windows NT (and probably before). One machine one major application. And don't use your (Windows) domain controllers for anything else.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.