Personal tools
You are here: Home DB2 DB2 EEE How to extract and display the partitioning/distribution map
Navigation
Log in


Forgot your password?
 
Document Actions

How to extract and display the partitioning/distribution map

db2gmap

To to extract and display the partitioning/distribution map for a partition group you have to use the command below:

db2gpmap
<-d [DatabaseName]>
<-g [PartitionGroup]>
<-m [MapFileName]>
<-t [TableName]>
<-h>

 

 

Example:

To generate a partitioning (distribution) map for a partition group named PG_123 in a database named TEST and write it to a file named PG_123map.txt, you would execute a db2gpmap command that looks something like this:

db2gpmap -d TEST -g PG_123 -m PG_123map.txt


And, assuming the partition group named PG_123 spans three database partitions, the first eight lines of the output file produced (PG123map.txt) would look like this:

1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3

(The upper-left corner corresponds to the partition ID at element 0 of the partitioning map. The map is read by moving from left to right and down, line-by-line.)


Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls