International Business Machines Corporation
Automatically setting an auto-purge value to multiple tables within a database

Abstract:

A computer-implemented method includes: receiving, by a computing device, a database-level auto_purge value for a database having a plurality of tables, wherein the database-level auto_purge value represents a value associated with the entire database for when data is set to be purged or deleted from the plurality of tables in the database; setting, by the computing device, the database-level auto_purge value for the database; setting, by the computing device, table-level auto_purge values for the plurality of tables included in the database based on the database-level auto_purge value; and automatically purging data in the plurality of tables based on the table-level auto_purge values.