InformixHQ repository
Answered: green (solid confidence) — Answers explained that InformixHQ needs a repository database that is an ordinary Informix instance, with sizing figures and a pointer to a setup FAQ; the asker thanked them.
Advisory only.
Posted in 2021
Sh To asked how to set up the InformixHQ repository. Andreas Seifert said it is an ordinary Informix instance with just a database created, ideally a separate Innovator-C instance, about 4GB for one HDR pair, buffered log, en_us.819. Doug Lawry recommended 5-minute sensor frequency, needing around 100MB per agent with 30-day retention. Sh To was satisfied.
Topics: Server Administration
Hello, I see that we need to set up a repository https://youtu.be/xsylAz5U1sY?t=2612 But in the IBM doc I didn't find instructions for this https://www.ibm.com/docs/en/informix-servers/14.10?topic=administration-informixhq-guide Also, Is it preferable to set a a light server just for monitoring ? How much space for every monitored server is suitable ? Thanks ------------------------------ Sh To ------------------------------ #Informix
Hello, Yes, a repository DB is necessary. It is best to use your own Innovator-C instance for this. Then the productive instance is not stressed and it remains free. The Developer Edition reaches its session limit with 3 monitored instances. Whether this is okay from a licensing point of view is debatable. Unfortunately, IBM has not yet commented on how a repository server only for InformixHQ is to be evaluated license-wise. In my configuration (one monitored HDR pair) - I need about 4GB storage for the repository. I hope this helps. ------------------------------ Andreas Seifert CURSOR Software AG http://www.admin-scout.com ------------------------------
Hello It helps thanks, but Is there any documentation to build this repository ? Thanks ------------------------------ Sh To ------------------------------
Hello Sh To, The repository is a normal Informix instance. Only the database needs to be created. InformixHQ creates the tables itself. My database runs fine with buffered log and DB_LOCALE en_us.819 ------------------------------ Andreas Seifert CURSOR Software AG http://www.admin-scout.com ------------------------------
OK Thanks a lot Samuel ------------------------------ Sh To ------------------------------
Most of your questions have been answered while I was away for a few days, but there is some additional input here: https://www.oninitgroup.com/faq-items/informixhq-setup We recommend reducing sensor frequency to 5 minutes. With the default retention of 30 days, your database will then only need around 100MB per HQ agent. ------------------------------ Doug Lawry Oninit Consulting ------------------------------
thank you very much for this additional information Samuel ------------------------------ Sh To ------------------------------