×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Bteq connect to a remote machine

Bteq connect to a remote machine

Bteq connect to a remote machine

(OP)
Ok, I have two Teradata machines, let's say machine A and machine B. Does anyone know how to connect to machine B from machine A? (with bteq)

As far as I can tell there aren't env variables or command line options and .logon user@machine or .logon //machine/user doesn't seem to do anything.

thx
bobm

RE: Bteq connect to a remote machine

Try using .logon machine/user
make sure that your hosts file or dns contains an entry for "machinecop1"
regards
Nico

RE: Bteq connect to a remote machine

If I undestand your question, you can't [to my knowledge] directly share data via BTEQ between 2 Teradata systems. You can of course use Arcmain Copy to move data from 1 to another, with another host as the input driver. You can also telnet from one system's node to another system if both /etc/host files are populated, but that is unix. Once you have telnet'd to another system, you can invoke BTEQ from that node and work.....

RE: Bteq connect to a remote machine

If I undestand your question, you can't [to my knowledge] directly share data via BTEQ between 2 Teradata systems. You can of course use Arcmain Copy to move data from 1 to another, with another host as the input driver. You can also telnet from one system's node to another system if both /etc/host files are populated, but that is unix. Once you have telnet'd to another system, you can invoke BTEQ from that node and work.....

RE: Bteq connect to a remote machine

You need to do 2 things:
1. Your /etc/hosts file needs to contain an alias for the second machine.  So if you are on machine A then your hosts file needs an entry like xxx.xxx.xxx.xxx machineB machineBcop1.
2. When you logon the syntax is .logon machineB/username.  Bteq will append the cop1 to the end of machineB.  If you don't have the alias in the hosts file it won't find it.  Also this is not an internet address so no '//' in front of the system name.

I highly recommend taking some Teradata Training from NCR, specifically Teradata Concepts and Facilities covers this topic.

Edmond Ray
Senior Scalable Data Warehouse Consultant
NCR Government Systems
edmond.ray@ncr.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close