Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Informix DNS Warning

    Posted Fri March 06, 2020 02:02 PM
    Hello everybody,

    I have an Informix 12.10.FC13 server running and lately I have been seeing the following message on my online.log:

    "02/24/20 13:31:02  WARNING: Detected slow or failing DNS service response 1 time(s)."

    Does anyone know what is this message about?

    Thanks,
    Regards

    ------------------------------
    Celso Freitas de Andrade
    ------------------------------

    #Informix


  • 2.  RE: Informix DNS Warning

    Posted Fri March 06, 2020 02:13 PM

    It is exactly what it says.  Slow DNS name resolution is a huge performance problem on database connections.  Have your network administrator check your DNS name resolution for your database server host and your network.

     

    This is a relatively recent (in the past couple of years to my knowledge) log message addition.  We always had to check several other items to figure out the cause of slow connections.  In my experience, this message in the log is accurate, so, involve your network administrator for DNS name resolution.

     

    Hal Maner

    M Systems International, Inc.

     




    Original Message


  • 3.  RE: Informix DNS Warning

    Posted Fri March 06, 2020 08:07 PM
    Edited by System Admin Fri January 20, 2023 04:22 PM
    Hello Celso,
    I have seen the same message from a customer using version 12.10.FC12.
    If you get rare warning messages, it's likely a network problem.
    If this happens frequently, you may want to review your DNS settings.

    https://www.ibm.com/support/pages/slow-connections-informix-dynamic-server-caused-dns-issues
    https://www.ibm.com/support/pages/possible-cause-slow-connection-database-server

    And I recommend reading Fernando's post when you have time.
    http://informix-technology.blogspot.com/2012/01/dns-impact-on-informix-impacto-do-dns.html

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    Original Message


  • 4.  RE: Informix DNS Warning

    Posted Sat March 07, 2020 04:17 AM
    In case of network not changing frequently and only a known set of applications, from known set of hosts, connecting to Informix, you might want to be more independent from DNS (and maybe temporary glitches) by taking advantage of DNS caching which can be done on OS as well as on Informix level.
    On Informix level you're configuring the Name Service Cache through NS_CACHE onconfig parameter, defaulting to 900 seconds (15 minutes) cache entry expiration time for each type of cache, i.e. a new DNS call would be required (and could slow you down), for a given host, every 15 minutes.
    Nothing should keep you from increasing the cache duration to a much higher value, and should you eventually have a need to expire and re-load some outdated cached information, you can temporarily lower this dynmaically, even to zero seconds (disabling a cache), at any time (onmode -w{m|f}).

    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


Related Content