Informix HQ Unable to load locale categories.
Antonin Rozehnal could not start the InformixHQ agent on AIX; the JDBC connection failed with Unable to load locale categories. Doug Lawry said an earlier version had this with LANG=en_GB.utf8, worked around by setting LANG=en_US.utf8 for HQ only, fixed later by IBM via a newer hq directory. Antonin could not upgrade due to AIX 7.1. Doug said keep DB_LOCALE and CLIENT_LOCALE as usual.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 ------------------------------ #Informix
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 ------------------------------
More details are here: https://www.oninitgroup.com/faq-items/informixhq-setup ------------------------------ Doug Lawry Oninit Consulting ------------------------------
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 ------------------------------
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 ------------------------------