Adding a new configuration to the Database Cleanup utility

To add a new configuration to the Database Cleanup utility, use the following syntax as a reference. For example, object o1 consists of table R1, which contains the following columns: col1, col2, lastupdate, and col3. To configure the Database Cleanup utility to delete all objects with col1 > 10, and where lastupdate is n days ago:

where ? is replaced by the -days parameter from the following command line. The 'no' indicates that the name parameter is not used in the statement. The 'yes' indicates that the -days parameter is used in the statement. 'obsolete' describes the cleanup type for object o1. You can use other words, but you must use the same word in the -type argument when you invoke the Database Cleanup utility.

Example

To invoke the Database Cleanup utility to clean the records which have been in existence for two days from the new table, type the following:

Feedback