Efficient Technique for Archiving Data Stored in Database Tables
Original Publication Date: 2004-Feb-27
Included in the Prior Art Database: 2004-Feb-27
DB2 databases containing data considered to be inactive can be moved, or archived, to DB2 archive tables or to archive flat files. It is imperative that the archiving process be done efficiently and in a timely manner. The need to reduce the potential of data loss during the archiving process requires the time between the insert of the inactive data into the archive table and the removal from its source table be done as close together as possible as well as a single unit of work. To satisfy these requirements a cursor on the result set of a database query on the tables containing inactive data is used.