DSXchange

Hi
We have installed DS Client, DS Server, Database Server are all in different machines. Iam not able to get the DSN names, when I import through the ODBC table definitions. In the ODBC Table Definition - I get the server name where DS server is installed. Should I do anything in the machine where DS Server is installed? I also tried to make a ODBC Connectivity in the DS Client (through control panel). But still Iam not getting the DSN names. Please help me out to get the DSN names. Hope I explained the situatin clear, If it is not understable, please let me know. I will try to explain still clear.

Thanks in advance.

Which database are you connecting to? If it is Oracle, can you use tnsping on your DataStage system?

We are using DB2 as our source. All the DSN are already created.

Indrani,

can you db2connect to the database from the DataStage server?

DSNs with associated database information need to be set up in .odbc.ini and a reference to each DSN must be set up in the uvodbc.config file in your project.

There has been a recent thread on just this topic; search should find it fairly easily. A good search term might be DBMSTYPE.

"One important thing to remember: the DataStage Server is the ODBC client, so you need to configure ODBC on the machine where the DataStage server is running.

Mike "


We have connected the DS Server and the DB2 server machine.
So you need to get the ODBC connectivity and place all the DSN names in the DS Server machine.

So If I place just the DSN names in the server machine , will it bring the datas from DB2 source?

In the above, Mike seems to say the same in a question from yesterday 's forum.

ray.wurlod wrote:DSNs with associated database information need to be set up in .odbc.ini and a reference to each DSN must be set up in the uvodbc.config file in your project.

There has been a recent thread on just this topic; search should find it fairly easily. A good search term might be DBMSTYPE.

Ray, I still didn't get you about the odbc.inin and the uvodbc.config

There is a (hidden) file called .odbc.ini in the DataStage Engine directory (the directory specified by $DSHOME). Sometimes an environment variable $ODBCINI has been created to refer to the location of .odbc.ini.

The .odbc.ini file contains the definitions of all DSNs visible from the DataStage server machine. (If you're old enough you'll remember that this is how things used to be done in Windows 3.1 and earlier, too. Now the Registry entry is still called OBDCini, maybe as a commemoration.)

You edit the .odbc.ini file to create and configure DSNs.

There is a uvodbc.config file in each project. This determines which DSNs are visible from that particular project. Each DSN must also have a value for DBMSTYPE of either ODBC (which means look in .odbc.ini) or UNIVERSE (which means use BCI/UCI functions rather than an ODBC driver to connect to a UniVerse (or DataStage) data source).

Ray,
I understood about the odbc.ini and uvodbc.
So If I make the ODBC connectivity with the DSN names in the DS Server machine, will I get the data in the DS client machine.

DSNs only appear in the drop-down list in the ODBC stage if you've imported at least one table definition from the data source.

When you're going through the process of Import > Table Definitions > ODBC Table Definitions in the Manager client, all DSNs named in the project's uvodbc.config file appear in the drop down list of available DSNs.

ray.wurlod wrote:DSNs only appear in the drop-down list in the ODBC stage if you've imported at least one table definition from the data source.

When you're going through the process of Import > Table Definitions > ODBC Table Definitions in the Manager client, all DSNs named in the project's uvodbc.config file appear in the drop down list of available DSNs.

Yes, But Iam not getting any DSN names in the Import > Table Defn> ODBC Table Defn in the DS client machine. It says empty DSN names.

ray.wurlod wrote:DSNs only appear in the drop-down list in the ODBC stage if you've imported at least one table definition from the data source.

When you're going through the process of Import > Table Definitions > ODBC Table Definitions in the Manager client, all DSNs named in the project's uvodbc.config file appear in the drop down list of available DSNs.

Yes, But Iam not getting any DSN names in the Import > Table Defn> ODBC Table Defn in the DS client machine. It says empty DSN names.

Should I make the necessary changes in the DS Server / DS client machine?

You must make the changes on the DS server, particularly the uvodbc.config file in the project and the .odbc.ini file in the "home" directory.

No changes are required on the DS client machine.

Ok, Thanks Ray

so far i have the same problem i know i have to configure /uvodbc.config

but how should i set this.

[ODBC DATA SOURCES]

<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

i have oracle and sybase dbs running .

please help me

thanks!