|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/21/2007 1:12:00 PM
Posts: 5,
Visits: 1
|
|
I want to connect to a remote machine using BTEQ from my system (DEMO Teradata installed).The entry has been added to the hosts file , I can ping the machine using the alias .
But while I try to connect through BTEQ it's giving me following error
------------------
*** CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.
*** Return code from CLI is: 224
*** Error: Logon failed!
-------------------
Message Remedy in the message manual is "Check the DBC/1012 name."
Could some one please help me understand what does that mean (DBC/1012)?
Your inputs will be highly appreciated.
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 10/12/2006 2:51:00 PM
Posts: 68,
Visits: 1
|
|
Hi KM,
when you log on via bteq, you have stg like this:
.logon /,;
suppose that your server's name is TDSERVER, you need to:
1. write in the bteq file: .LOGON TDSERVER/,
2. have in you hosts file an entry like this:
xxx.xxx.xxx.xxx(ip address of the server) TDSERVER TDSERVERCOP1
Remember that BTEQ can connect to the server using the hosts file.
Let me know if you need further detail.
Bye,
TDUser
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 3/27/2007 5:35:00 AM
Posts: 58,
Visits: 1
|
|
Hi
Your BTEQ must start with
.logon TDEMO/USERID,password;
It think for the TeraData demo it is
.logon TDmon/dbc,dbc;
Also BTEQ will not work unless your etc host file does not contain the following entery
(Directory C:\WINDOWS\SYSTEM32\DRIVERS\ETC )
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
127.0.0.1 localhost
11.11.11.11 TDEMO tdemocop1
11.11.11.11 is the IP Address of your PC or the server where this server resides.
That's All Folks Divvy Certified TeraData Master
|
|
|
|