-clearCommonLog

Deletes all records in the CL_CONTEXT_VALUE and CL_LOG common log tables. If you enabled debug level logging for a process app and forgot to disable it, the common log could grow significantly and you may not be able to execute any common log operations in Application Repository or SBM Composer. You can use this command to clear the common log tables in this scenario.

Important: Before you run the renew -clearCommonLog command, it is highly recommended that you stop the SBM Tomcat service first.

There are two ways to execute this command using the provided batch template files:

Run clearCL.bat:

installDir\SBM\Common\Misc\renew\renew_templates\clearCL.bat

This option clears the common log tables using the database credentials that are specified in:

installDir\SBM\Common\tomcat\server\default\conf\renew.properties

Run clearCL_dbCredentials.bat:
```
installDir\SBM\Common\Misc\renew\renew_templates\clearCL_dbCredentials.bat
```
This option clears the common log tables using the database credentials that are specified in the batch file.

Example output:

java -Dfile.encoding=UTF-8 -jar renew.jar -clearCommonLog 
-dbUsername "sa" -dbPassword "password"

WARNING: This will permanently delete all Common Logger data. Are you sure? [Y/N]:Y
Done.