Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Teradata with win2k 1

Status
Not open for further replies.

tkdba

Technical User
Sep 2, 2002
2
US
Does anyone have experience using Teradata v2r4.1 on win 2k in a production environment? If so are there any 'gotchas' that would be different from using Teradata with Unix?
Are there any websites I could go to for more info?

Thanks in advance
 
Hi,
4.1 on windows only runs on W2K. Therefore all 4.1 Windows customers must be running W2K.

However W2K customers could still be running 4.0.x, but I would strongly recommend they upgrade to 4.1 to get the priority scheduler feature which allows the system to automatically tune different types of queries ( I/O bound vs CPU bound vs High priority vs Low priority ) to run nice together on the same box.

One of our Goals in making 4.1 was to minimize the differences in functionality between the UNIX and the Windows version.

I believe We accomplished that, but I may be bias I was the Release Achitect for 4.1.

I wrote a difference paper as part of the 4.1 release.

There are a couple resusage logging fields that aren't collected.

The tunable setting program is called XCTL on MPRAS and only CTL on Windows.

There is a Windows only JAVA program called Multi-tool for doing administrative tasks on the server.

You must have the Microsoft Visual Studio C++ compiler installed to use Stored procedures on Windows whereas on UNIX the standard C compiler is used. ( we don't allow any other stored procedure compilers on Windows )

The windows version 'can be' integrated with NTLM/Kerberose Login authentication allowing for better security. Takes a little set up. Again there is an earlier tek-tip message on that.


If you want you can order a DEMO copy of the 4.1 for Windows 2K ( actually see my earlier post on making it run on XP as well ) and try it out for your self.


If you can find a feature which doesn't work on Windows which works on UNIX let me know. You can post them here or send them to my Email

Tdatgod@yahoo.com

Like I said I tried very hard in the release to find the difference and eliminate them.

We even went so far as to add a version of Unix tools like Awk, Sed, grep and the like to the Windows package to make UNIX people more comfortable with the administration.
 
Thanks for your info Tdatgod! I have ordered the Demo and will proceed from there
 
Hi,
I should point out as I have in my previous mailgrams about the demo.

The Teradata V2r4.1 for Windows 2000 Demo


is a Totally Free Evalualtion copy of Teradata, most of the utilities and most of the manuals. Other manuals are available at



There are no Time bombs or features which are disabled although some of the utilities might not be on the CD and the Maximum Database/Table space is limited to 1 Gig.

At a minimum I believe you need 250 meg of free disk space to install it plus whatever you intend on using for Database/Table space.

There is warning about not using this in a production environment which would violate the end user license of the evaluation.

It comes preloaded with a Sample Database and Sample Applications which you can play around with.

All the source code for the sample applications are included so you can look at them to write your own applications against your own tables and database if you develop.

All the data for the sample Databases is included, so you can delete and reload the sample Database tables at any point.

As I said it is totally Free however, You must give NCR some personal information like where to mail it to obtain the CD.

Please feel free to read the privacy Statement if you have any further concerns about the information collected as part of ordering the CD.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top