How to run BTEQ in Windows machin

General
Enthusiast

How to run BTEQ in Windows machin

Hi,

We are using Teradata Studio 15.10 in loacal, but we are unable to run big SP's in Studio.So we are planned to use BTEQ to run SP's.We are not used before.can anyone help us to run and connect BTEQ in windows.

4 REPLIES
Enthusiast

Re: How to run BTEQ in Windows machin

You can type Bteq at the command prompt after you have installed the software or start from a batch file

Rglass

Enthusiast

Re: How to run BTEQ in Windows machin

Hi,

We are try to logon using BTEQ to teradata,but we getting below error.

*** Warning: RDBMS CRASHED OR SESSIONS RESET.  RECOVERY IN PROGRESS.

^C^C^C *** Warning: Exiting because of three BREAKs!

 *** Exiting BTEQ...

We have attached the screen shot.can anyone help us.

Junior Supporter

Re: How to run BTEQ in Windows machin

Hi.

You say you're using bteq in a windows machine, but the screenshot shows you are on a linux one (and as root), accessed from a windows machine via ssh (putty).

The error message that you are getting is shown when you try to connect to a non-existent host by ip address or to a host that isn't running Teradata DB (thus not listening on 1025 port).

Your 192.99.93.216 host isn't running Teradata DB, probably.

Cheers.

Carlos.

Enthusiast

Re: How to run BTEQ in Windows machin

We changed IP to localhost 127.0.0.1/username.Now it's working.thank you so much.