KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums KX Solutions API / function to flush IHDB? Re: API / function to flush IHDB?

  • Laura

    Administrator
    July 29, 2021 at 12:00 am

    Hi Adriano!

    This is an issue not only in IHDBs but RDBs i.e. if EOD is missed due to downtime then not only is the old data never pushed to HDB but it’s no-longer loaded to the RDB (because a new log file is made).

    As a custom solution to this issue you could

    • check for this scenario on startup
    • playback the previous log file (I’m not very familiar with IHDBs but I imagine there’s an equivalent) https://code.kx.com/q/kb/replay-log/
    • EOD with the appropriate date

    Obviously this falls apart when the process is off for more than a day (you could loop through each missed log file I suppose), but hope that helps!

    Josh