share connection between EE and TeraData

[wenfei.chen]

I installed 64 bit TeraData CLI V2 and the connection between TeraData and DataStage didn't work. And then we find out that DataStage is 32 bit application, it just support 32 bit DataBase client. And for TeraData, the database user must have creat, insert, update and delete permission, otherwise, you won't see the data.

[phanee_k]

Hi,
How did you try accessing the Teradata database.
Did you add the location of the Teradata drivers in the dsenv file which will be in DSEngine directory.

Which utility of Teradata did you use to connect to Teradata.

Please provide sufficient details so that we can help you.


Thanks,

[cundyp]

IBM Case 515298 DataStage 7.5.2 accessing Teradata V2R6.1 using TTU8.1.)

DataStage is a 32-bit application and it must 'only" point to 32-bit database libraries and not 64-bit (you have no choice unless you desire to move to HP Itanium and that unrealistic). This is true for Teradata, Oracle, DB2 and so on. If the Teradata DBA refuses to make the 32-bit version available then DataStage will not connect successfully. For example, many database clients such as Oracle provide both the 32-bit and 64-bit simultaneously in the client install so you just need to point to the right one (for Oracle its lib for 64-bit and lib32 for 32-bit).

Resolution: We just resolved this issue by installing the 32 bit Teradata drivers.

[ray.wurlod]

You must also ensure that the 32-bit libraries are found by DataStage processes - this means either removing the 64-bit libraries from the shared library search path (environment variable LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH) for DataStage processes, or at least guaranteeing that the 32-bit libraries are mentioned first therein.