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.