The pathname to the database-utility script is:

/< product-directory >/tools/db-utility/database-utility.pl

To run the script, follow these steps:

Step

Action

1

Open a command prompt and navigate to /< product_directory >/tools/ db-utility/.

For example:

cd /opt/smart-ncm/tools/ db-utility/

2

Run the database-utility.pl script using the following syntax:

./database-utility.pl <COMMAND> <TYPE> <ARGUMENTS> Where <COMMAND> is archive, delete, purge, prune, retain, or restore.Where <TYPE> is auditHistory, events, jobs, latestRAAuditTrail, or revisions.Where <ARGUMENTS> contains the required arguments defined below.