Helo every DB2 Gurus!

In my z/OS system log I found 1000 and 1000 messages in the following form:

DSNL512I  - DSNLILNR TCP/IP 877                  
GETHOSTBYADDR(192.168.200.1) FAILED WITH         
           RETURN CODE=1 AND REASON CODE=00000000 

This message appeared every 3 seconds. Which manner Can I stop this?

Best Regards

Győző

------------------------------
Gyozo Karsai
------------------------------

Hello ,

Usually these type of messages are seen on DR site when Db2 failover happens and DNS entries and TCP profile are still being stabilized , usually network and z/OS sys progs can help you to figure out the problem.
If this is your production system work with network and z/OS team and enquire if there were any recent changes .

STOP DDF should stop the messages being logged to MSTR but you do not want to do that as it will stop DBAT connections to this Db2.

Found this APAR which describes what actions one can take to diagnose.

https://www.ibm.com/support/pages/apar/II10962 

Hope this helps.

Regards,
Manoj K Jadwani

------------------------------
Manoj Jadwani
Product Manager
BMC Software
------------------------------

Very odd - I get this one:

DSNL512I  -xxxx DSNLILNR TCP/IP DVIPA 970        
ACTIVATION(::192.1nn.n.nn) FAILED WITH            
           RETURN CODE=121 AND REASON CODE=766C7303

but every three minutes and only from one subsystem...

I do not let it worry me...as it is non-prod

------------------------------
Roy Boxwell
Senior Software Architect
Software Engineering GmbH
Duesseldorf
+4921196149675
------------------------------

Hi Győző,

I've come across this occasionally in the past, and solved it by editing etc/hosts to include the IP address/hostname of your z/OS system.

Hope this helps.

Regards,

Gary Maltby

------------------------------
GARY MALTBY
------------------------------

Hi there, 

the return code 1 means that there's no domain available, as you can see here:

USS Return codes

How Db2 aquires IP and domain is explained here, first paragraph:

https://www.ibm.com/docs/en/db2-for-zos/12?topic=messages-dsnl512i

A gethostbyaddr() call is expecting a domain in return. The ip given by Db2 is probably correct. The problem is that a wrong, or no domain, is given to this call. And the return code is very clear: no domain available.

The most probable cause is that the resolver is not working well. You should look at the TCP.PROFILE and/or the USS configuration. 

Hope it helps.

------------------------------
Diego Cardalliaguet
IBM Data&AI zStack Leader for EMEA
IBM
------------------------------

What IP address do you have in your BSDS? 

Is that IP address valid for you z/OS system?

See more info & instructions here https://www.ibm.com/support/pages/apar/II14515

------------------------------
Jørn Thyssen
Principal Solutions Advisor
Rocket Software
------------------------------

Hey

GETHOSTBYADDR is issued by DDF during startup(unitl V8 I guess. startup process changed in V9 because of IPV6 support). 
If you see DSNL512I, I think your site is missing definitions in TCP/IP for DDF.
You'll needs to resolve host name from IP address shown, meaning refering proper DNS or add definitions to local resolver( /etc/hosts, TCPIP.HOSTS.LOCAL, etc, whatever your site uses).

------------------------------
Yasuhiro Ohmori
------------------------------

1) If the z/OS has a /etc/hosts file ..... eliminate it .... it will result in symptom reported

2) Check content of TCPIP.HOSTS.LOCAL .... if inaccurate, then correct and tso makesite hlq=TCPIP

------------------------------
Paul Newton
Consulting IT Specialist
IBM
Coppell
------------------------------