This topic applies only to the IBM Business Automation Workflow Advanced
configuration.

deleteAuditLog.py administrative script

Use the deleteAuditLog.py administrative script to selectively delete audit log entries for the Business Flow Manager.

Prerequisites

The following conditions must be met:

Run the script in connected mode, that is, do not use the wsadmin -conntype none option.
At least one cluster member must be running.
Include the wsadmin -user and -password options to specify a user ID that has operator authority.
If you are not working with the default profile, use the wsadmin -profileName profile option to specify the profile.

Location

The deleteAuditLog.py administrative script is in the Business Process Choreographer admin directory.

install_root\ProcessChoreographer\admin
install_root/ProcessChoreographer/admin

Syntax

install_root/bin/wsadmin.sh 
install_root\bin\wsadmin

-f deleteAuditLog.py 
       -cluster cluster_name
       ( -all | -timeUTC timestamp | -timeLocal timestamp 
              | -processtimeUTC timestamp | -processtimeLocal timestamp )
       [-slice size]

Parameters

-f: This parameter specifies the script file to run.
-cluster clusterName: The name of the cluster where Business Process Choreographer is configured. In a multicluster setup, you must specify the application cluster because that is where Business Process Choreographer is configured.
-all: Deletes all the audit log entries in the database. The deletion is done in multiple transactions. Each transaction deletes the number of entries that are specified in the slice parameter, or the default number.
-timeUTC timestamp: Use this option to specify the deletion cutoff date and time in Coordinated Universal Time (UTC). Only audit log entries that are older than the time you specify for timestamp are deleted. Its format must be: YYYY-MM-DD['T'HH:MM:SS]. If you specify only the year, month, and day, the hour, minutes, and seconds are set to 00:00:00 UTC.
-timeLocal timestamp: Use this option to specify the deletion cutoff date and local time on the server. Only audit log entries that are older than the time you specify for timestamp are deleted. Its format must be: YYYY-MM-DD['T'HH:MM:SS]. If you specify only the year, month, and day, the hour, minutes, and seconds are set to 00:00:00 local time on the server.
-processTimeUTC timestamp: Use this option to specify the deletion cutoff date and time in UTC. Only audit log entries that belong to a process that finished before the time you specify for timestamp are deleted. Its format must be: YYYY-MM-DD['T'HH:MM:SS]. If you specify only the year, month, and day, the hour, minutes, and seconds are set to 00:00:00 UTC.
-processTimeLocal timestamp: Use this option to specify the deletion cutoff date and local time on the server. Only audit log entries that belong to a process that finished before the time you specify for timestamp are deleted. Its format must be: YYYY-MM-DD['T'HH:MM:SS]. If you specify only the year, month, and day, the hour, minutes, and seconds are set to 00:00:00 local time on the server.
-slice size: Used with the -all parameter, size specifies the number of entries included in each transaction. The optimum value depends on the available log size for your database system. Higher values require fewer transactions but you might exceed the database log space. Lower values might cause the script to take longer to complete the deletion. The default value for the slice parameter is 250.