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?
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.