Dropping and restoring database schemas

Last Updated : Sep 19, 2020 |
Prolog information
After installing Avaya Analytics™, you can send test traffic to Avaya Oceana® for validating reports. When you are satisfied with the results, you can delete the test data using the steps in this procedure and start working afresh.
Other:
These steps delete all data from the Avaya Analytics™ database.
  1. Log in to the Cluster Control Manager (CCM) console as the customer user.
  2. Switch to being the root user by entering the command su.
  3. To run the Analytics Administration script, use the following command:
    ADDITIONAL INFORMATION:
    ccm release orca analytics
  4. Select Database by pressing the corresponding number.
  5. To select the Drop and Restore Database Schemas option, enter the corresponding number.
    STEP RESULT:
    The CCM console displays the following warning:
    Continuing will remove all data from Database.
  6. In the Confirm [y/n] field, type y.
    ADDITIONAL INFORMATION:
    Entering n cancels the operation.
    STEP RESULT:
    The CCM console starts installing the schemas and restarts the Avaya Analytics™ database pod.
  7. Return to the previous page by entering b.
  8. Quit the current page by entering q.
  9. Return to the main menu by entering m.