I was recently asked what changes , if any, we made to the DB2 utilities when we used them to run against our 10 TB fact table during our testing?
First off, to make sure we didn’t run into any issues with DFSORT storage allocations for very large sorts, we did make one slight change to DFSORT’s dynamic storage adjustment (or DSA) feature. The larger your file size, and in our case we were going to sort 9 billion rows or 10 TB of data, the more storage DFSORT will consume.
Continue reading »
Well over a year ago (Feb 2011) I blogged about the addition of the PARALLEL keyword that was made available on the REORG TABLESPACE LIST utility control statement. (See “APAR Friday: Another great REORG enhancement” )
As a result of the group of fixes mentioned in the above blog post, a single execution of REORG happens with a list of partitions. It does happen in parallel; that’s good news. However, sometimes, someone may want to still run the list of partitions serially… one partition at a time……. Continue reading »
Last year DB2 changed the REORG to allow ranges to be specified. However, this change had REORG processing these groups of ranges serially… when one range finished, the next range started. So Db2 was changed to do the ranges in parallel…… Continue reading »
I started writing this up a few days ago and got distracted. Since it’s Friday, I thought I would make it an installment of my APAR Friday series… although that was not the original intent. Originally, I just though this was a cool enhancement that’s going to make someone’s life just a touch easier….. Continue reading »