At run time, DataStage is a client application, and Oracle is a database server. Its as simple as that, irrespective of how the topology is organized.
> ----------
> From: David Barham[SMTP:
David.Barham@Anglocoal.com.au]
> Reply To:
informix-datastage@oliver.com
> Sent: Thursday, 16 November 2000 15:15
> To:
informix-datastage@oliver.com
> Subject: RE: DataStage and Oracle on Different Unix Machines
>
> Even though you have the Oracle database on another server, you will
> still need to install the Oracle client on the server where you have
> DataStage. Installing the Oracle client will set up an Oracle Home and
> a bin directory. These are the ones to tell DataStage.
>
> Yes, what you are doing is possible and probably quite common.
>
> -----Original Message-----
> From:
sudhir.mahendru@db.com [SMTP:
sudhir.mahendru@db.com]
> Sent: Thursday, November 16, 2000 2:13 PM
> To:
informix-datastage@oliver.com
> Subject: DataStage and Oracle on Different Unix Machines
>
> Hi
> I have a situation in which I need to Install DataStage 4.0 Server on
> one Unix Machine and underlying database Oracle on other Unix Machine
> to do the load balancing
> If this is possible then what could be the entries in dsenv file for path
> of
> oracle home and oracle bin dir.
> any other thing which is required for this.
> thanks and regards
> Sudhir Mahendru
> GTS/APHO-ITA/CA$H/IDMS-Datawarehouse
> (65) 423-7449
>
>
>
> **********************************************************************
> ***
> This e-mail and any files transmitted with it may be confidential
> and are intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this e-mail in
> error, please notify the sender by return e-mail, and delete this
> e-mail from your in-box. Do not copy it to anybody else
>
> **********************************************************************
> ***
>