Removing data from Logging tables

To remove data from Logging tables, use the AR_PURGE_HEADERS stored procedure. It takes the cut-off date as the input parameter.

Syntax:

DB2:

call AR_PURGE_HEADERS(<cut-off date, format:'YYYY-MM-DD'>)

For example: call AR_PURGE_HEADERS('2005-10-21')

Oracle:

execute AR_PURGE_HEADERS(<cut-off date, format:'DD-MON-YY'>)

For example: execute AR_PURGE_HEADERS('21-OCT-2005')

Copyright IBM Corp. 2003, 2005