Difference between a TDPID and a USERID

Database

Difference between a TDPID and a USERID


Hi,

When we login to a teradata database, we give .

Whats the difference between a TDPID and a userid. i.e when do we use a tdpid to login and when do we use a USERID.

3 REPLIES

Re: Difference between a TDPID and a USERID

oops.. i am sorry.. i missed some text

Hi,

When we login to a teradata database, we give

LOGON tdpid/userid, password

Whats the difference between a TDPID and a userid. i.e when do we use a tdpid to login and when do we use a USERID.

Thank You,
Swathi.V.
Teradata Employee

Re: Difference between a TDPID and a USERID

Hello,

Usually it is the IP of the server machine e.g:

Suppose your Teradata server is at 1.1.1.1 then you will use ".LOGON 1.1.1.1/username, password".

But if you are on the Teradata server machine, then you dont have to put IP in it, then it will be ".LOGON username, password".

Regards,

Adeel

Re: Difference between a TDPID and a USERID

Hi,

Case 1:

When you access the Teradata server through FICON channel from IBM mainframe environment then we have to use TDPID to logon. 

EX: 

.logon TDPA/USERID,password;

or

.logon USERID,password;

/* If you fail to mention TDPID then the mainframe will assign the default TDPID, it can be TDPA or TDPC*/

Case 2:

If you access the Teradata server through Local area network (LAN) from UNIX or Windows OS then we have to use the hostname to logon. Here we can also use the ipaddress of the server instead hostname of TD server.

EX:

.logon TD_hostname/USERID,password;

or

.logon 192.168.9.8/USERID,password;

The USERID will remain the same in both the case.

Regards,

Kharthigeyan.