DB2 Table Partitioning — Get Moving!
Table partitioning was introduced in DB2 9.7. Since then many improvements have been made around table partitioning regarding local indexes, data roll in and roll out and utility operations at the table and index level. With table partitioning, available in DB2 10.5 for you WSE folks out there, you can now use table partitioning. Because of the single index reorg capability and other table high availability features. I’ll be posting an article soon here regarding Maximization of DB2 10.5 Table Partitioning Capabilities. Stay tuned! Check out this 9.7 article on how to get moving with table partitioning.
http://www.ibm.com/developerworks/data/library/techarticle/dm-1006tablepartitioning/
Leave a Comment