If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2diag message error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-22-07, 07:59
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
db2diag message error

i am recieving these messages on 1 of the server after i have upgraded clients to FP14

2007-02-22-17.40.22.068000+330 I105332H319 LEVEL: Error
PID : 2716 TID : 2792 PROC : javaw.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, probe:42
MESSAGE : DIA3207E The TCP/IP call "gethostbyname" returned h_errno="11001".

any hints to track it...
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #2 (permalink)  
Old 02-22-07, 22:38
mathew.eldho mathew.eldho is offline
Registered User
 
Join Date: Jan 2007
Location: Pune, India
Posts: 27
Hey Rahul,

DIA3207E The TCP/IP call "gethostbyname" returned h_errno="1".

This type of error indicates that IP address of the target machine is
not being resolved correct. The tcpip node catalog information shows the
machine's network alias.

your problem has to do with your network configuration
http://msdn.microsoft.com/library/de.../en-us/winsock
/winsock/windows_sockets_error_codes_2.asp

I have an old link, check this msdn site to see the error code you are getting.
__________________
Eldho Mathew
IBM DB2 UDB LUW Software Engineer
Reply With Quote
  #3 (permalink)  
Old 02-23-07, 05:47
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
thanks
But i am still clueless how to solve it
The message is getting generated every 5 minutes regularly

C:\Program Files\IBM\SQLLIB\BIN>db2 list node directory show detail

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = B0
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = BULL
Service name = 50000
Remote instance name = B0
System =
Operating system type = WIN

which is correct ...
What else to see ??
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #4 (permalink)  
Old 02-23-07, 07:06
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
have you tried nslookup BULL and see for the answer..
I never catalog db on hostname but use address
it does not need a lookup to nameserver
ok : if the address changes, you have to modify the catalog
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #5 (permalink)  
Old 02-26-07, 02:39
mathew.eldho mathew.eldho is offline
Registered User
 
Join Date: Jan 2007
Location: Pune, India
Posts: 27
If you have any chages address or hostname, please varify your catalog configuration.

For more details.Please refer the following link,

http://www-128.ibm.com/developerwork...301chong2.html
__________________
Eldho Mathew
IBM DB2 UDB LUW Software Engineer
Reply With Quote
  #6 (permalink)  
Old 02-26-07, 04:35
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
Server got restarted last evening and since then i havnt seen the same error
seems like server needed some rest :-)
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #7 (permalink)  
Old 02-26-07, 07:56
mathew.eldho mathew.eldho is offline
Registered User
 
Join Date: Jan 2007
Location: Pune, India
Posts: 27
!!! " hmm..

You didn't allow her to take rest, that why she is just roared.

If you can give me the db2diag.log entries for the matching PID or timestamp. I can tell you why she roared.

[some where it detect n/w error...]
__________________
Eldho Mathew
IBM DB2 UDB LUW Software Engineer
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On