Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Informix HQ Unable to load locale categories.

  • 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
    https://docs.deistercloud.com/content/Databases.30/IBM%20Informix.2/InformixHQ.xml?embedded=true
    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
    ws://intax1206.zoub:8080/ws/1
    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>(IfxSqliConnect.java:1340)
    at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:198)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
    at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
    at com.informix.hq.agent.InformixConnectionManager.newConnectionPool(InformixConnectionManager.java:76)
    at com.informix.hq.agent.InformixConnectionManager.getTargetConnection(InformixConnectionManager.java:8
    8)
    at com.informix.hq.agent.InformixServerStatusMonitor.checkStatusOnJdbcConnection(InformixServerStatusMo
    nitor.java:149)
    at com.informix.hq.agent.InformixServerStatusMonitor.run(InformixServerStatusMonitor.java:79)
    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:

    $INFORMIXDIR/hq

    Regards,
    Doug

    ------------------------------
    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:

    https://www.oninitgroup.com/faq-items/informixhq-setup

    ------------------------------
    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
    ------------------------------