To remove data from State Engine tables, use the AR_STATEENGINE_MAINTENANCE stored procedure. It takes the number of days for which you want to retain the data as the input parameter. All records before that number of days are removed from the database. The default is 7 days.
Syntax:
DB2:
call AR_STATEENGINE_MAINTENANCE(<number of days data will be retained>)
For example: call AR_STATEENGINE_MAINTENANCE(15)
Oracle:
execute AR_STATEENGINE_MAINTENANCE(<number of days data will be retained>)
For example: execute AR_STATEENGINE_MAINTENANCE(15)