Generate statistics SQL for tables that exceed a threshold

Procedure

  1. Ensure that the PolicyCenter 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 generate database statistic SQL statements for tables exceeding the change threshold.
    • system_tools -password password -getincrementaldbstatisticsstatements

    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.

Results

PolicyCenter groups the output statements by table.