IDUG NA 2025

Databases keep growing.  Many applications do not need the older data at certain age, which could vary from a few days to a few years.  Reducing the DB size can not only save storage, but also the backup/restore time, and more importantly improves the database performance, in most cases.  But, DELETE/REORG has always been a nightmare to DBAs, specially on large databases.  This presentation demonstrates a working system which purges the older data from DB2 databases, FAST (in seconds/minutes), with NO System down, NO DELETE/REORG involvement, which is pretty much independent of the database size.  The system also provides the option of old–data–archive before purging.