Can we install the datastage server without database?

ICE · Post by **ICE** » Tue Nov 14, 2006 12:58 am

Dear All,

May I know whether we can install the Datastage server without installing the database on that datastage server?
As per my knowledge,I think we must have the database on the datastage server.
Am I correct?

Thanks,

Prashantoncyber · Post by **Prashantoncyber** » Tue Nov 14, 2006 1:39 am

Datastage has its own database called "DataStage Engine" which is derived from UniVerse which gets installed anutomatically while installing datastage server & where all repository objects are stored.
Hence as far as I know datastage cant be installed with out this database.
thanks

ray.wurlod · Post by **ray.wurlod** » Tue Nov 14, 2006 7:28 am

To which database are you referring? DataStage must have its own database, called the Repository, co-resident. You don't get a choice on this.

But any database that you are accessing for data and metadata can be anywhere accessible from the DataStage server; in particular it does not need to be co-resident. Beware, however, that performing lookups over a network is one of the least performant activities that DataStage can do.

All this changes in version 8.0, when you can separate the repository (IBM Information Server, or IIS), the application server (IBM Websphere Application Server, or WAS), and the DataStage client onto separate machines if you wish.

chulett · Post by **chulett** » Tue Nov 14, 2006 7:34 am

As noted, it would have been nice to know what 'the database' is that you are referring to. If you are asking if something like an Oracle database, let's say, needs to be installed on the same server as DataStage to be accessable by it - heck no. That would be one heck of a limitation in the product.

Depending on exactly what you are accessing, you may find you'll need a copy of their client software installed on the DataStage server - but nothing more than that.

If you mean the 'repository' database that holds all things DataStage, then that answer is a resounding 'yes'... until 8.x comes out.

ICE · Post by **ICE** » Tue Nov 14, 2006 11:42 pm

Yes.I mean it for the other database like oracle or sql server or something like that.I don't mean for Datastage universal database.
So,after I read your resposes ,I understand as I don't need database to install datastage server.Am I right?
So that means, datastage server and database server can be on the different servers.Right?

narasimha · Post by **narasimha** » Tue Nov 14, 2006 11:56 pm

So,after I read your resposes ,I understand as I don't need database to install datastage server.Am I right?

Right

So that means, datastage server and database server can be on the different servers.Right?

Right

DeepakCorning · Post by **DeepakCorning** » Tue Nov 14, 2006 11:59 pm

Yes , No req of a Database to install DS server.

ICE · Post by **ICE** » Wed Nov 15, 2006 12:15 am

I got it.
Thanks so much for all of your responses.

vmcburney · Post by **vmcburney** » Wed Nov 15, 2006 5:52 am

One way to look at it is that what you can access from your PC is similar to what DataStage can access from its server. You can access databases on database servers with the right client software such as Oracle client or ODBC. You cannot open MS Access databases or files on other computers unless you copy it to your computer or map a drive. Same with the DataStage server.

The main benefit of putting a database on the DataStage server is as a staging area where you can do fast bulk loads directly into that database from DataStage without any network latency. It doesn't make sense to put an operational or reporting database on the DataStage server as the users of that database would be constantly vying with DataStage for CPU and RAM resources.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 15, 2006 9:10 am

Another way to look at it is from the database server's perspective.

A running DataStage job, or a metadata import or View Data request from DataStage, is just another client application as far as the database server is concerned.