Replication with Infosphere CDC : Tools and utilities : SQL stored procedures for data aging and refresh
  
SQL stored procedures for data aging and refresh
The stored procedures included in the solidDB® package enable automating data aging and refreshes.
The Aging procedure deletes rows in a solidDB® database based on user-defined aging rules. The Aging procedure can be activated at solidDB® startup so that it performs automatic data aging in the background.
The Refresh stored procedure enables you to start a refresh programmatically from an application, without interacting with an IBM InfoSphere CDC instance.
See also
Using the Aging stored procedure
Using the Refresh stored procedure
Example: Automating data aging for bidirectional subscriptions
Tools and utilities