I spent whole day digging this issue. I really appreciate any information that helps to solve an it. We've installed Teradata 2.6.2 and tTU 8.2 on a clean Windows 2003 server Intel Xeon box. When I issue logon command in fastload command prompt window it just dies with no errors. Here's a screen shot: C:\>fastload =================================================================== = = = FASTLOAD UTILITY VERSION 07.08.00.000 = = PLATFORM WIN32 = = = ===================================================================
=================================================================== = = = Copyright 1984-2006, NCR Corporation. = = ALL RIGHTS RESERVED. = = = ===================================================================
**** 12:05:11 Processing starting at: Fri May 04 12:05:11 2007
**** 12:10:49 Current CLI or RDBMS allows maximum row size: 64K
I've turned on tracing on Gateway. There're no errors there. I've checked sessions info from gtwglobal. It shows there's one disconnected session. I have no idea why and who disconnected it and I can see this is a session created by Fastload.
Enter gateway command or enter h for Help: di ne lon
Host 1 has 1 session(s) over 1 GTW(s) and 1 PE(s) ( 0 Active / 1 Disconnected / 0 Forced)
Ok. I'm answering to myself. :-) All the problems were because of mess of dll's from different versions of TD. They are installed in different folders for different versions. In our case old TTU was installed by mistake and when upgrading old dll's were not removed properly.