Archives of the TeradataForum

Message Posted: Wed, 17 May 2006 @ 16:28:29 GMT

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

Hi,

Yes, MLOAD uses CLI. As with all CLI applications, MLOAD uses the TDPid coded in the logon string. A Teradata CLI logonstring is of the form:

     tdpid1/user1,pswd1

The CLI software reads the tdpid value (tdpid1 in the example above), appends the literal 'COPn' ('n' is a number starting at 1) to this name and then issues an os call to look up this value (e.g. tdpid1cop1) in the hosts file/dns table. The result of this call is the ip address for the Teradata system.

Yes, there's more processing involved to try and ensure session balancing across the different ip addresses that the Teradata system uses, but that's the basic logic.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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