topic Re: Upgrade TTU15 to TTU16 On Windows in Administration and Deployment

Upgrade TTU15 to TTU16 On Windows

parametreSEG — Wed, 29 Apr 2020 14:24:33 GMT

Hello,

Can someone share with me the process to upgrade TTU15 to TTU16 on Windows SAS9.4M2.

Thanks.

Re: Upgrade TTU15 to TTU16 On Windows

AnandVyas — Fri, 01 May 2020 07:23:43 GMT

Are you asking for Teradata Tools and Utilities upgrade? I don't think most of the SAS Admin's do this as activity as part of their role. Its better to reach out to Teradata DBA community for faster resolution.

Re: Upgrade TTU15 to TTU16 On Windows

parametreSEG — Wed, 06 May 2020 13:04:58 GMT

Thank you for your return.

I want to know how to configure SAS to use the new TTU.

And how to configue SAS to use TTU for the first time.

Re: Upgrade TTU15 to TTU16 On Windows

AnandVyas — Wed, 06 May 2020 13:46:05 GMT

For using SAS/Access to Teradata on WIN 9.4 M2 you need to have this licensed first. I am assuming you have this as part of your SAS order. You also need the below client libraries installed on your SAS compute server in order to make connectivity. Since you are already on version greater than below, its taken care of.

DBMS Products Required:
• Teradata Database version 13.10 or later
• Teradata CLIv2 client libraries, TTU 13.10 or later for Windows (64-bit libraries)

Here is the system requirements document that you can refer to. Section: SAS/ACCESS Interface to Teradata

https://support.sas.com/documentation/installcenter/en/ikfdtnwx6sr/66390/PDF/default/sreq.pdf

Once you have the pre-requirements in place, trying to make a connection from the Teradata client to see if the connectivity is established successfully outside of SAS.

If its successful try to connect it via SAS libname using any client like SAS Studio or EG.

Refer to this document for the libname options and other features that the access engine offers. https://go.documentation.sas.com/?docsetId=acreldb&docsetTarget=p0gy4y5g1dy090n18jq1riw5g8d5.htm&docsetVersion=9.4&locale=en

Re: Upgrade TTU15 to TTU16 On Windows

jklaverstijn — Mon, 11 May 2020 13:50:01 GMT

As said, probably not many SAS admins do this but I have 🙂

The process is fairly straightforward. Upgrade the Teradata client using the provided utilities. Do beware of the fact that some environment variables may have changed between 15 and 16. These are set in your environment file of choice, often the level_env_usermods.sh of your SAS configuration. Follow the Teradata guidelines for this. Also copy over any changes you made to the clisp.dat file that configures the client for eg. utf-8.

And then of course you test.

Hope this helps,

- Jan.