About this task

Use the PurgeConversationsLocalDB script to:

  • Delete all the conversations stored in the conversation repository.

  • Delete the conversations stored in the conversation repository for a specific application.

  • Optimize disk space usage on the database tables used by the conversation repository.

Procedure

  1. Log in to Linux on the EPM server which is hosting the conversation repository that requires purging or optimization.

    If you are an Avaya Services representative, and use Avaya Enterprise Linux, the Avaya Service accounts will not be available after the Avaya Enterprise Linux upgrade. The Avaya Service accounts will be available through EASG configuration during the Experience Portal upgrade.

    • Log on to the local Linux console as root.

    • Or log on remotely as a non-root user and then change the user to root by entering the su - root command.

  2. Navigate to the Support/VP-Tools directory in the Experience Portal installation directory.
  3. Enter the cd $AVAYA_HOME/Support/Security-Tools command. $AVAYA_HOME is an environmental variable pointing to the name of the installation directory specified during the Experience Portal software installation.

    The default value is /opt/Avaya/ExperiencePortal.

  4. Enter the bash PurgeConversationsLocalDB command followed by one of the following parameters:

    • -p to purge all conversations in the repository.

    • -a application-name to purge all conversations for the specified application name.

    • –v to perform a vacuum full command to recover or reuse disk space occupied by the updated or deleted rows. This option is not required if you have used the -p option.

    The system might take some time to execute the script depending on the number of conversations in the repository tables. If the script runs successfully, it returns a message stating that the operation completed without any errors. Otherwise, the script returns a message stating the errors.