All Forums Database
swathi v 2 posts Joined 05/08
22 May 2008
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.

swathi v 2 posts Joined 05/08
22 May 2008

oops.. i am sorry.. i missed some textHi,When we login to a teradata database, we giveLOGON tdpid/userid, passwordWhats 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.

Adeel Chaudhry 773 posts Joined 04/08
22 May 2008

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

-- If you are stuck at something .... consider it an opportunity to think anew.

kharthigeyan 2 posts Joined 10/10
16 Nov 2011

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.

You must sign in to leave a comment.