All Forums General
keerthi1987 14 posts Joined 02/16
20 May 2016
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.
 

Glass 225 posts Joined 04/10
23 May 2016

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

keerthi1987 14 posts Joined 02/16
26 May 2016

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.

CarlosAL 512 posts Joined 04/08
27 May 2016

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.

keerthi1987 14 posts Joined 02/16
28 May 2016

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

You must sign in to leave a comment.