Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 31 Jul 2002 @ 19:22:51 GMT

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

Subj:   Re: Long Logon times via CLIv2
From:   Dieter Nöth

  I have 6 machines that I logon to. Do you set it to one less than the machine with the most cop entries or the total number of cop entries?  

When you got 6 Teradatas, you probably don't use DBCcopxx at all. It's the logical name of a Teradata sytem used in your bteq/fastload...

logons: .logon foo/username,password
System Name foo with 4 nodes -> set foo=4
another system named bar with 20 nodes -> set bar=20

CLI is trying to resolve the ip-addresses of all nodes of a system. This is fast for the existing nodes foocop1 to foocop4, but then the non-existent node foocop5 is causing the trouble. Depending on your name resolving (hosts, Wins, DNS etc.) this may be very slow, i've seen delays of > 100 seconds.

You typically don't have the same problem with odbc, because the addresses are resolved when you add a new DSN.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020