Enable Database Scheduling

If any of the following messages are shown upon login or when typing health login, the steps below should be carried out:

  • CACHE DATABASE MAINTENANCE NOT SCHEDULED
  • TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED

For general information on scheduling, see: Scheduling.

For considerations and guidance on frequency of the schedule to set up for your system. see the System Maintenance section of the Best Practices Guide.

Important

Schedules must be set up on all unified nodes. This ensures that they still run in the event of a failover and DR scenario.

  • For cache database maintenance:

    With for example a schedule name dbcache:

    schedule add dbcache voss trim-cache

    See also Database Commands

    Typing health login at the command line will now not show the CACHE DATABASE MAINTENANCE NOT SCHEDULED message.

    The schedule instance can be modified, for example every 24 hours:

    schedule time dbcache every 24 hours

  • For transaction database maintenance:

    With for example a schedule name dbtxn:

    schedule add dbtxn voss transaction archive 7

    or

    schedule add dbtxn voss transaction delete 7

    Note that transaction archiving also deletes transactions. For further details, see Database Commands for Transaction Management

    Typing health login at the command line will now not show the TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED message.

    The schedule instance can be modified, for example weekly on Sunday:

    schedule time dbtxn weekly 0