Archives of the TeradataForum

Message Posted: Tue, 17 Sep 2002 @ 22:12:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Modify the i_dbcpath entry in clispb.dat or place an entry in %Windows% \system32\drivers\etc\hosts for host DBC.

First,

clispb.dat looks like this:
--------------------------
req_buf_len=1024
resp_buf_len=8192
max_num_sess=300
i_dbcpath=dbc <-----<<< Change this entry from DBC to the network host
name
of your Teradata System
change_opts=Y
keep_resp=N
loc_mode=N
wait_for_resp=N
parcel_mode=Y
resp_mode=R
use_presence_bits=N
msg_security=N
var_len_req=N
var_len_fetch=N
wait_across_crash=N
tell_about_crash=Y
two_resp_bufs=N
save_resp_buf=N
ret_time=N
req_proc_opt=E
--------------------------
Then your bteq utility will try to connect to the name specified on
i_dbcpath and not DBC.  Hopefully your Domain Name Server will resolve
your Teradata Host Name to a numeric IP address.
--------------------------
or, second
%windows%\System32\Drivers\etc\hosts file looks like this (default
version):
--------------------------
# Copyright (c) 1993-1995 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows NT.
#
# 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
192.168.1.100 DBC <-------- Add a line like this with the correct IP
address of your Teradata on your network.
--------------------------
Then when your bteq utility tries to connect to the default name of DBC,
it will know DBC's numeric IP address.  Actually this is a bad thing to
do.  Your Domain Name Server (DNS) should be set up to resolve DBC's name
to a numeric IP address.  But this is "OK" to do for testing.

--------------------------
Third, from an MS DOS window, use the MS DOS (windows) ping program to
ping your Teradata Host name.  If you don't get a ping reply, then you
aren't going to connect with anything to that host name.  "ping DBC" for
example.

	<Prev	Next>		<<First	<Prev	Next>	Last>>