GK_STATS Configuration Settings

The GK_STATS component provides the following settings:

  • gkr.db.dbstats.executeOnStartup: defines whether the NIGHT mode (FULL maintenance) should be executed on startup
  • gkr.db.dbstats.nightHours: defines a set of hours for which the NIGHT mode (FULL maintenance) is executed. This is used in combination with the scheduler configuration.

Example configurations:

  • FULL maintenance at startup plus FAST maintenance for scheduler execution (default product configuration):
# run GK_STATS in NIGHT mode (FULL maintenance) for all tables when application is starting
gkr.db.dbstats.executeOnStartup=true
# set at which hours is NIGHT mode executed
# set to NULL to disable NIGHT mode during day (you usually set this together with gkr.db.dbstats.executeOnStartup=true)
gkr.db.dbstats.nightHours=
  • No maintenance at startup plus FULL maintenance for scheduler execution at 01,02,03,04,05 o'clock.

    Please be aware that this kind of configuration may cause issues. See description below for the NIGHT mode.

# run GK_STATS in NIGHT mode (FULL maintenance) for all tables when application is starting
gkr.db.dbstats.executeOnStartup=false
# set at which hours is NIGHT mode executed
# set to NULL to disable NIGHT mode during day (you usually set this together with gkr.db.dbstats.executeOnStartup=true)
gkr.db.dbstats.nightHours=01,02,03,04,05