No connect to tera database after upgrading tera client to R

peterreich · Post by **peterreich** » Fri Dec 23, 2005 1:28 am

After installing tera data client TTU Upgrade (7.1 - > 8.0) we receive an error message if we try to connect tera data using DataStage (for exp. trying to import meta data).

My question: is it necessary to reinstall the DataStage teradata adapter packages after the upgrade - or - is there a known problem using tera data client 8

We using DataStage Server 7.5 on Solaris 9 (SunOS dwhtn2 5.9 Generic_118558-06).

Thanks in advance

kcbland · Post by **kcbland** » Mon Dec 26, 2005 2:25 pm

I don't know if there's a difference in Teradata plugins for different versions of Teradata client. That being the case, there's nothing you should have to do on the DataStage side. What you do need to do is make sure that all appropriate dsenv changes are up to date for the new client, such as paths and environment variables and then recycle the engine.

It's helpful in the future if you post the exact error messages, otherwise we're just guessing.

My guess is your client upgrade changed directories for shared libraries and DS doesn't know where the new libraries reside because the dsenv file was not updated. But who knows until we see the error messages.

peterreich · Post by **peterreich** » Tue Dec 27, 2005 12:25 am

Hello Ken

Thank you for the reply.
Now we have found the source of the problem, there was an entry in a .profile. UTT8 only works with java classes, in the .profile there was on "old" entry for "terabin". It seems, DataStage checks the existens of the enviroment variables. After we have eliminated this entry it runs without any problem.

Beste regards
Peter

kcbland · Post by **kcbland** » Tue Dec 27, 2005 7:40 am

Whooosh

A swing and a miss (to use a baseball analogy).