How to find?

[admin]

The answer depends on a lot of things. If you were using ODBC to import
table definitions, then what you would see in the pick list is a list of
ODBC sources on the server. On a Windows server, what these ODBC sources
point to depends on their definition. There is no way in DataStage to
figure this out. In the case of Oracle ODBC sources, even the ODBC source
does not tell you as it simply provides a name which is resolved by the
Oracle client. The Oracle client has many ways of resolving this name. One
of the most common is through TNSNAMES.ORA. This file will tell you which
database on which server the name points to. However, If you are using
directory services for Oracle name resolution, then you would have to go to
the directory server to find out where the name points.


On the other hand, if you are using ORAOCI stages or importing table
definitions through plug-in stages, then you can skip the ODBC part above
and go straight to TNSNAMES (or whatever other name resolution you might be
using).

Also, don't confuse Oracle Homes with Oracle Services (or databases). An
Oracle Home is simply the install location of a version of Oracle software.
It might be full database software or it might just be the client software.

You would not normally have/need more than one Oracle Home on a DataStage
server (although I can think of obscure exceptions to this). If you are
talking to both Oracle 8i and 9i databases, then you need to choose either
the Oracle 8i or 9i client to install on the DataStage server. Your choice
might depend on the version of DataStage as you need to have at least
DataStage 6 to use the Oracle 9i client.

I'd be surprised if you could use both the ORAOCI8 and ORAOCI9 plugins on
the same server (at least with a Windows server, anyway) as both call a DLL
of the same name and the version they find will depend on which one is on
the path first (and ORAOCI8 plugin does NOT like the Oracle 9i client).


I hope this helps. I'm not exactly sure what you are asking. Perhaps you
could provide a bit more information about what you are trying to do.


To answer you very first sentence, the only sure way for DataStage to know
which Oracle server it is talking to, is to submit a query to the server to
ask it. If you can explain why this is important, then I could give you a
query to do this. Usually it is the other way around ... you supply
parameters to DataStage telling it what server to connect to (by using a
name resolved by ODBC and/or the Oracle client).


-----Original Message-----
From: Venkat [mailto:nvkuriseti@rediffmail.com]
Sent: Thursday, 15 January 2004 4:10 PM
To: datastage-users@oliver.com
Subject: How to find?

Hey Gurus,

Can we find which Oracle Server we are connecting from DataStage. The
Example is, Suppose I am Using 5 Oracle Servers (Ora8i,Ora9i,...) to
DataStage Project. So, If we want to know which Oracle server and Oracle
path DataStage using to a job or project. But I found some Information while
"Importing Table Defination" and all Oracle Homes. So, Where can we find
this information from DataStage files?
This DataStage will store Oracle Information to any DataStage Files? If so,
let me know what are the files and then we will find.

Thanx and Regards,
Venkat