-
Book Overview & Buying
-
Table Of Contents
IBM DB2 9.7 Advanced Administration Cookbook
In this recipe, we will perform data redistribution on database partitions 3 and 4. For the method, we will use the default uniform distribution.
Now that we have added partitions 3 and 4 to partition group NAVDATAGRP and the corresponding containers to the NAV_TBLS and NAV_INDX table spaces, the next logical step should be to redistribute data on all existent partitions.
Internally, DB2 9.7 uses a distribution mechanism based on a partition map, which is actually an array containing 4,096 entries for backward compatibility. It can be extended to 32768 by setting the DB2_PMAP_COMPATIBILITY registry variable to OFF. The distribution map is generated and associated internally with a database partition group when is created. Every partition defined on a database partition group is mapped inside this array in a round-robin fashion.
We will generate a distribution map once before data redistribution for database...
Change the font size
Change margin width
Change background colour