Articles & Content

Archives

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

Topic: DB2 for LUW

Subtopic: 2012



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.