View Only
  • 1.  Informix HQ Unable to load locale categories.

    Posted Sat August 08, 2020 04:52 PM
    I have running IDS 14.1. I would like to run Informix HQ. I followed the instructions
    I have started the server, but I'm not able to start InformixHQ agent due to error:

    2020-08-08 21:25:51.923 [main] INFO com.informix.hq.agent.MetricMonitorApplication - InformixHQ Monitoring Agen
    t, version 1.0.0 (build date: 2019-02-07T11:20:26-0600)
    2020-08-08 21:25:51.931 [main] INFO com.informix.hq.agent.MetricMonitorApplication - Agent running on AIX
    2020-08-08 21:25:51.932 [main] INFO com.informix.hq.agent.MetricMonitorApplication - Starting Monitor
    2020-08-08 21:25:51.967 [main] INFO com.informix.hq.agent.WebSocketManager - Attempting to connect to server at
    2020-08-08 21:25:52.989 [WebSocketConnectReadThread-35] INFO com.informix.hq.agent.WebSocketManager - Connected
    2020-08-08 21:25:53.047 [WebSocketConnectReadThread-35] INFO com.informix.hq.agent.MetricMonitorApplication - A
    gent running in local mode relative to the target database server
    2020-08-08 21:25:53.106 [ServerStatusMonitor] INFO com.zaxxer.hikari.HikariDataSource - pool-target - Starting.
    2020-08-08 21:25:54.262 [ServerStatusMonitor] ERROR com.zaxxer.hikari.pool.HikariPool - pool-target - Exception
    during pool initialization.
    java.sql.SQLException: Unable to load locale categories.
    at com.informix.jdbc.IfxSqliConnect.<init>(
    at com.informix.jdbc.IfxDriver.connect(
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(
    at com.zaxxer.hikari.pool.PoolBase.newConnection(
    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(
    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(
    at com.zaxxer.hikari.pool.HikariPool.<init>(
    at com.zaxxer.hikari.HikariDataSource.<init>(
    at com.informix.hq.agent.InformixConnectionManager.newConnectionPool(
    at com.informix.hq.agent.InformixConnectionManager.getTargetConnection(
    at com.informix.hq.agent.InformixServerStatusMonitor.checkStatusOnJdbcConnection(InformixServerStatusMo
    Caused by: com.informix.asf.IfxASFRemoteException:

    Probably need to be adjusted connection string.
    I can do this for common Java applications, where should I set it for Informix HQ (jetty)?

    Antonin Rozehnal

  • 2.  RE: Informix HQ Unable to load locale categories.

    Posted Sun August 09, 2020 03:56 AM
    Hi Antonin.

    This affected us on an earlier version with:

    export LANG=en_GB.utf8

    A work-around was:

    export LANG=en_US.utf8

    The problem was subsequently fixed by IBM. You can update HQ only by installing the latest IDS in a different location and replacing the contents of:



    Doug Lawry
    Oninit Consulting

  • 3.  RE: Informix HQ Unable to load locale categories.

    Posted Sun August 09, 2020 04:17 AM
    More details are here:

    Doug Lawry
    Oninit Consulting

  • 4.  RE: Informix HQ Unable to load locale categories.

    Posted Sun August 09, 2020 11:25 AM

    Hi Doug,

    thank you for your advice. I guess, this encoding settings is just for Informix HQ, isn't it?
    The setting of DB_LOCALE of individual databases on monitored servers the agents does not need to know? Or it'll find out for itself?

    My LOCALE settings
    AIX - 7.1 - LANG=cs_CZ 
    IFX - DB_LOCALE=cs_cz.8859-2@sis

    I'm not able to install last build of IDS 14.x, due dependency on AIX 7.2., so I don't even have the last build of IHQ.

    Antonin Rozehnal

  • 5.  RE: Informix HQ Unable to load locale categories.

    Posted Sun August 09, 2020 12:51 PM
    Yes - set LANG differently just for HQ. You should have DB_LOCALE and CLIENT_LOCALE set to your usual values when starting HQ.

    Doug Lawry
    Oninit Consulting