Join UsClose Share?Profiles ▼Communities ▼Apps ▼ Forums InfoSphere Information Server for System z Log in to participate Expanded section▼Topic Tags ? Mills ICONS Replacement Team (205) 733-5409; [email protected] Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Recently I've started learning Teradata DB. I've installed BYNET driver, Database and Express tools (Teradata Service Control and etc) and other tools: BTEQ, Fastload,Multiload and other.
Enter your logon or BTEQ command: logon teramed4/dbadmin; logon teramed4/dbadmin Password: ******* *** CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database. *** Return code from CLI is: About Me Name: Abul Hasim Location: KOLKATA, WEST BENGAL, India View my complete profile Web mahasim.blogspot.com Log They should be able to resolve or tell you what is needed. Hewlett Packard View All Topics View All Members View All Companies Toolbox for IT Topics Data Warehouse Groups Ask a New Question Teradata For discussion on Teradata , please visit the view publisher site
Topic Forum Directory > Information Management > Forum: InfoSphere Information Server for System z > Topic: Error Handling No replies Display:ConversationsBy Date 1-1 of 1 Previous Next SystemAdmin 110000D4XK 93 Posts ALL RIGHTS RESERVED. = = = ======================================================================== 00:46:06 UTY2411 Processing start date: WED DEC 20, 2006 ======================================================================== = = = Logon/Connection = = = ======================================================================== 0001 .logtable DB_AEDWD1W.ST_ZIP_CRRR_LOC_LOG; 0002 .logon ORCHSERVER,; Anthony S.
Already a member? As you can see, you have to add "cop1" to your DB name - like loopback adapter. jadams01 replied Apr 17, 2006 On Apr 17, 2006, at 11:01 AM, john.mills via teradata-l wrote: > Yes. Find Ip Address Of Teradata Server Click Here to join Tek-Tips and talk with other members!
Just remember that whatever ID is used will have "cop1" suffix appended before the hostname lookup. Teradata Hosts File John Mills replied Apr 13, 2006 I do not know the answer to this; however, I would like to know as well since I received the same error when I tried can be any integer.So the tdpid in my case is DemoTDAT.FYIW, I copied the line and created a new tdpid (tdp1) that was easier to remember with the line127.0.0.1localhosttdp1cop1Sonny. directory Adding the host name to the /etc/hosts file will not, by itself, fix the problem.The server name (called "tdpid" in the BTEQ documentation) that you specify in the logon string is
Silent Leiw replied Mar 26, 2014 As the error message displayed,adding your database ip address to the host file can resolve this problem 2014-03-26 19:46 GMT+08:00 Community_Member [email protected] >: > Question Cli Error 224 No Message Text Available All product names are trademarks of their respective companies. Our DNS entries go in once per month and not for another two weeks. End : 07:31:04 - WED MAR 26, 2014 .
Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. http://hasimma.blogspot.com/2010/08/howtoteradata-cli-error-mtdp.html Thanks a lot! Cli Error 224 In Teradata Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Rdbms Code 224 Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More...
m_kalyani replied Apr 17, 2006 Must have the ip address of teradata server in /etc/hosts file of the operating system. --Kalyani.M Top Best Answer 0 Mark this reply as the best Top White Papers and Webcasts Popular 5 Best Practices for Business Intelligence Related Forrester Consulting Report: Empowered Customers Drive ... TERAMED4 is not in my HOST file on my PC, but resides on our companys DNS (Domain Name Server). Toolbox.com is not affiliated with or endorsed by any company listed at this site. Rdbms Code 224:mtdp: Em_nohost(224): Name Not In Hosts File Or Names Database.
Register now while it's still free! Bteq Logon Syntax No, not really. HASIM`S_ABODE Wednesday, August 18, 2010 HowToTeraData: CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.
More Data Warehouse Groups Your account is ready. Srikanth D replied Dec 3, 2010 You need to add the complete host domain in resolve.conf Top For discussions on Teradata please visit the Data Warehouse – General Discussions group. Join this group Popular White Paper On This Topic 5 Best Practices for Business Intelligence 13Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Find Tdpid George Coleman replied Mar 27, 2014 If you have an entry for ABCCOP1 in /etc/hosts, then you can logon to ABC.
Have a look at /etc/hosts file. From: Tony Howe When using BTEQ, FASTLOAD, FASTEXPORT or MULTILOAD utilities from a UNIX or WINDOWs server I get the following error: Teradata BTEQ 06.01.00.00 for WIN32. Fred Pluebell replied Apr 13, 2006 When you specify .LOGON MyTD/SomeUser,password Teradata CLI will try to resolve the hostname "MyTDcop1" (and 2, 3, etc. ERROR: Error in the LIBNAME statement.
Shaan replied Mar 26, 2014 Thanks Every one. Thanks again. 0 Kudos Reply alihammad Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-03-2014 11:12 AM Now where should I add/mention this Alias "ABCCOP1" in the DBC file which i use? Don't you think ?
Teradata Utility Returned With Error Code 12 | UTY1006 CLI error: 224, MTDP: EM NOHOST(224): name not in HOSTS Sh4nk4r asked Mar 26, 2014 | Replies (8) I am trying to Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.