Delete Product Advisor statistic objects

1. cd WC_installdir/bin

   • (DB2)

     ./dbclean.sh -object pastats 
                  -type all 
                  -instancexml WC_installdir/instances/instance/xml/instance.xml 
                  -db dbname 
                  -dbuser user 
                  -loglevel loglevel
     

   • (Oracle)

     ./dbclean.sh -object pastats 
                  -type all 
                  -instancexml WC_installdir/instances/instance/xml/instance.xml 
                  -db dbname 
                  -loglevel loglevel 
                  -dbtype oracle 
                  -dbuser user 
                  -dbpasswd password 
     

     Use host:port:sid for the database name. For example, myhost:1521:mydb.

2. Examine...
   WC_installdir/instances/instance/logs/DBClean/DBClean.timestamp.log

 

Related Concepts

Database Cleanup utility