Online roll-out with table partitioning in InfoSphere Warehouse

Improve the availability of your warehouse data

From the developerWorks archives

Naresh Chainani, Liping Zhang, Steve Pearson, and Srinivasa Santhanam

Date archived: January 12, 2017 | First published: October 27, 2011

Starting with IBM® DB2® for Linux®, UNIX®, and Windows® V9.7.1, the table partitioning feature is enhanced with support for online roll-out using detach. With online roll-out, queries continue to access the partitioned table while one or more partitions of the table are being detached using the ALTER TABLE DETACH PARTITION command. Learn how online detach improves the availability of the warehouse and discover some best practices for leveraging and monitoring the new behavior. A stored procedure is provided to help database administrators to script the post-detach processing on the target table. The article also demonstrates how the same procedure can be used to simulate synchronous detach behavior in certain application scenarios. We conclude with frequently asked questions related to detach.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, Big data and analytics
ArticleID=767819
ArticleTitle=Online roll-out with table partitioning in InfoSphere Warehouse
publish-date=10272011