Teradata user platforms

[WILLIEWANKA]

I'm about to take a class on Unix, and I had some questions relating to teradata.

I'm not very familiar with Unix, but I do know that our TD runs on MP-RAS. Are there advantages to using Unix over Windows to run queries through the database?

Is there a way for a user to log into the TD Unix environment through windows? What TD utility would they use, and how would they invoke it? I'm most familiar with the Windows TUF package. There are some utilities that I have never used such as WinCLI and BteqWin, and these names obviously point to a windows platform, but are they used to access the Unix boxes?

 

[dnoeth]

Most Teradata (command line) utilities that use the call level interface (CLI) run on Windows or different Unix flavours or mainframes, e.g. bteq or load tools like FastLoad.

Some (GUI) tools like Teradata SQL Assistant (AKA QueryMan) or Teradata Administrator (AKA WinDDI) use ODBC and only run on Windows (although there's ODBC for Unix) because those tools are programmed in Visual Basic(?).

But using those tools you can connect to any Teradata running on MPRAS or W2K.

Dieter

 

[tdatgod]

Teradata is Teradata is Teradata. It doesn't matter if the Server is Windows or MPRAS.

Conversely we support a wide range of clients from IBM Mainframes, To Windows, to most flavors of *nix

Our Clients tools connect to a special port at an IP address. They have no idea whether that IP address is runnign MPRAS or Windows nor do they care.

Just make sure the correct COP Aliases are setup for the IP addresses where teradata is running in your local hosts file or in DNS if you are running with that.


the database and client communicate and handle EBCDIC to ASCII and big endian to little endian conversions seamlessly.

There may be minor differences between Windows clients and *nix clients like

.run file = c:\temp\myscript.txt

vs

.run file = /tmp/myscript.sql

but they are few and far between.

If you know how to use the windows client, you probably know how to use the *nix version and visa versa.

that is one of the best value propositions going for teradata. Your existing Teradata training will work in any Teradata Environment.




----

 

[kampi]

From the research I have done, I have found that Teradata customers who are attaching to EMC storage do not Timefinder and SRDF to create copies of speficic data. Does anyone know why? Is there a problem using these features? Or do most Teradata users use other utilities to create secondary copies?

thanks.