Unable to login througj BTEQ

Database
Enthusiast

Unable to login througj BTEQ

HI, I have recently installed Teradata Demo CD on my Windows XP (SP2). Teradata installed properly on my system and I am able to connect to Database through SQL assistant. However I am facing problem while loggin on the Database through BTEQ.

Entry in my host file is

127.0.0.1 localhost DemoTDATcop1

The Command that I have used to logon is

.logon DemoTDATcop1/dbc

and

.logon localhost/dbc

in both the cases i get the error message "BADLOGON(303) Invalid Logon String."

Please Help.

4 REPLIES
Enthusiast

Re: Unable to login througj BTEQ

Hi Dennis and Daniel,

Your replies have really helped me in logging into BTEQ AND FastLoad.

I have modified the entry in my hosts file as follows

127.0.0.1 localhost DemoTDAT DemoTDATcop1 ak akcop1

Hence I am able to logon to BTEQ and FastLoad by using the following command
.LOGON AK/DBC;

Then I am prompted for password
DBC;

I am using the demo V2R5 on Windows XP.

However, when I try to logon to MultiLoad using the same format, I get the following message

LOGON;
0001 .LOGON;
**** 20:50:14 UTY6214 Reminder: A .Logtable statement must be entered for a successful logon.

Please advice me what could be the problem and it's possible solution.

Thanks in advance,
Manik

Junior Contributor

Re: Unable to login througj BTEQ

Hi Manik,

Messages
Chapter 17: Client UTY
UTY-Series Messages

"UTY6214 Reminder: A .Logtable statement
must be entered for a successful logon.
Explanation: The .Logon and .Logtable statements
must both be entered for a successful connect to the
DBC. This is an informational message only.
Generated By: UMBSTMLG
Remedy: Make sure that the .Logtable statement is
entered."

Dieter
Enthusiast

Re: Unable to login througj BTEQ

Does anybody know how to identify which node was assigned to our request from the pool of box1, box2 etc Nodes?

Thanks,
Nishi
Enthusiast

Re: Unable to login througj BTEQ

i can see only "127.0.0.1 localhost" in my host file. How to login.

i tried to login using .logon ***.***.**.**/username

password:*******

but getting error CLI 224.