Following is the paragraph from IBM DPF redbook:
You can use the REDISTRIBUTE DATABASE PARTITION GROUP statement with the DISTFILE option if the distribution of the distribution key values is skewed and you want uniform distribution. In this case, you must specify a
distribution map file and provide it with the DISTFILE option.
My Question:
Does the author mean to say, during the "Redistribu tion process using Distfile option" DB2 will use a different hash function to generate hash values which have same probability (equal no.of distribution keys mapped to each hash value) and redistribute the rows accordingly among the db partitions? If not, can you please explain what is happening in the background during "redistribu te database process with DISTFILE option".
You can use the REDISTRIBUTE DATABASE PARTITION GROUP statement with the DISTFILE option if the distribution of the distribution key values is skewed and you want uniform distribution. In this case, you must specify a
distribution map file and provide it with the DISTFILE option.
My Question:
Does the author mean to say, during the "Redistribu tion process using Distfile option" DB2 will use a different hash function to generate hash values which have same probability (equal no.of distribution keys mapped to each hash value) and redistribute the rows accordingly among the db partitions? If not, can you please explain what is happening in the background during "redistribu te database process with DISTFILE option".