Articles & Content


Stop the growth of very large table and make ZERO application changes - C07

Topic: 2012 NA

Subtopic: DB2 for LUW

The method includes automating the partitioned table maintenance, including monthly addition of new partition and the monthly detach and export of the oldest partition to another database. Thus making the OLTP production database 80% smaller. This allowed us to return to daily backups of production and shorten recover time from database failures.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.