How to recover InformixHQ corrupted h2 database?

Hello, today we got this message in IHQ server log 2025-07-02 08:41:30 [qtp-1564579997-597072] ERROR c.i.h.s.r.a.GenericExceptionMapper - Except ion in REST API : File corrupted while reading record: "/exp/ihq/h2db.mv.db". Possible solution: use the rec overy tool [90030-224] since that time nobody is able to login to IHQ GUI, sensors and agents seem to be working correctly Can somone help me where I can get mentioned recovery tool and how to use to get from this problem? Thanks a lot ------------------------------ Milan ------------------------------

Hello unfortunately there is not much what can be done to recover the H2 database. There might a recovery tool for H2DB. But I do not know which tool this could be. And if this tool is able to correct the corruption. It is unclear what kind of corruption this is What version of HQ do you use? H2DB for HQ needs a manual backup on OS level (with HQServer being shut down) Future versions of HQ allow a backup of the H2 database out of the HQ user interface. But for your current situation, when you do not have a backup on OS level, you unfortunately must recreate HQ setup from scratch. ------------------------------ Hedwig Fuchs ------------------------------

Hello Hedwig, Version i 3.0.0 we are planning to upgrade to 3.0.3 and currently looking for backups. Thanks for tips. Milan Rafaj Senior Lead, Infrastructure/Cloud Architecture Kyndryl Consult +420 737 264 248 www.kyndryl.cz Planned absence/Plánovaná nepřítomnost: 20.6.2025, 29.7.-12.8.2025 Kyndryl Česká republika, spol. s r. o. Sídlo: Praha 4, Chodov, V Parku 2308/8, PSČ: 148 00, IČ: 14890992 Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277) Registered address: Prague 4, Chodov, V Parku, 2308/8, Zip code: 148 00 Company ID: 14890992 Entered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)