White papers or manuals for Teradata SQL. 2

[jorgevasconcelos]

Hi yall,

I would like to know where can I find some white papers or tutorials (for FREE)about Teradata SQL.
Thanks in advance
Jorge.

P.S: Thank you tdatgod, for the "Getting Started" hints you gave me.
By the way, I´m using a Windows 2000 OS.

 

[tdgulbra]

You should be able to find all the manuals you could ever hope for at

http://www.info.ncr.com.

Enjoy!
Tony

 

[jorgevasconcelos]

Hi,

I´m a little bit lost trying to set a client-server Teradata environment.
Here´s the scenario:
- I have 2 machines: One with Windows2000, and the other one with Windows NT.
- I´m using only the Teradata demo version.
- I´m trying to set the Win NT machine as a Server and the Win 2000 as a client.
- I´m on a ethernet topology.
- I created a new user called "novabase" using BTEQ on the Server machine, and also created another new user called "Jorge" using BTEQ on the client machine.

How can I procced in order to correctly set the Teradata client-server env?

Here are some issues found trying to set this kind of scenario:
1) The user "Jorge" is not recognized by the WINDDI of the same machine that it was created (client machine) as well as it is not recognized by the server too (BTEQ and WINDDI of the server machine).
The only way to logon with the user "Jorge" is using the BTEQ of the client machine (machine where "Jorge" was created).
It seems to work correctly (I created a Table named "TEST" using this user).
When I try to log into Teradata as "Jorge" using the BTEQ of the server machine, and it returns me an error 3004 (User not authorized).
When I use the WINDDI of the server machine I cannot see the user "Jorge".But I can see the user "novabase".
So, the main point is: How can I create users that can be properly logged on a Teradata net?
(What´s the correct procedure to do that ?)
2) Can I use win 98 as a Teradata client ?

Regards,
Jorge

 

[tdatgod]

Hi,
Are you sure you didn't install the demo software on both machines and therefore when you created navabase it was created on the teradata instance on the one machine and then when you created Jorge it was created on the other?

Also rememeber that the Demo software is for demonstation purposes only and should not be used for Production level work.

That said.

Your configuration sounds fine. The teradata server on NT and the client on Win 2K. on the Win2K box you have to check to make sure the COP aliases are set up prpoerly in the host file ( or in DNS if you are using DNS )

xxx.yyy.zzz.www demo1099cop1 dbccop1

where xxx.yyy.zzz.

http://www is

the IP address of the box teradata server is running on.

This will allow the DEMO version of the client software to talk to the Demo Server running on the other node.

Again if you look in the host file on your windows 2K box and see.....

127.0.0.1 localhost demo1099cop1 dbccop1

it means you installed the teradata Demo on the WIN2K box as well and you have 2 separarte instances of teradata and that is why you can't see your users from the other machine.

uninstall the Teradata RDBMS DEMO version from the Win2K box and update the IP addresses to point to the NT workstation so you don't get confused.


2. The client software is not certified on 98. However that doesn't mean it won't run, just that we don't support it. Try it, the worse it can do is fail.

--