-clearEventLog

Deletes all records in the EL_EVENT, EL_EVENT_PROCSNG_DATA, EL_EVENT_SRVC_FLW_PROCSNG_DATA, EL_EVENT_SERVICE_FLOW and EL_EVENT_LOG_MESSAGE event log tables. If you have not purged the event log in some time and a large amount of records have accumulated, you might not be able to delete event log records using Application Repository. You can use this command to clear the event log tables in that scenario.

Important: Before you run the renew -clearEventLog 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:

Example output:

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

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