Cancel the database statistics updating process

About this task

If you receive the following error on submitting a new database statistics job, it is possible that the Database Statistics process terminated abruptly:
  • The Database Statistics process is already in progress

If you receive this error message, you need to manually cancel the process.

Procedure

  1. Ensure that the PolicyCenter application server is running.
  2. Open a command prompt and navigate to the following location in the PolicyCenter installation directory:
    • admin/bin
  3. Enter the following command to cancel the process that updates database statistics.
    • system_tools -password password -cancelupdatestats

    The PolicyCenter administration command prompt tools all require that you enter the password of an administrative user for the tool to work. The use of a user name is optional.