If u run the db2gpmap it will give you the current P.MAP information. I
am not sure what do u mean by optimized ?
Once you get the P.MAP you can customize it and then run the
RE-DISTRIBUTE command.

cheers.....
Shashi Mannepalli

You can run db2atld can be done with MODE=ANALYZE, which will
output a new partition map that will result in even distribution
of the data.

However, you can only redistribute everything in the nodegroup,
because the partition map (pmap) applies to the entire nodegroup.

Theoretically you could create a new nodegroup / tablespace / table
and use a custom pmap -- but this would eliminate the possibility of
colocation on joins (tables being joined have to be in the same
nodegroup to qualify for colocation)

If you have 1 table that is bad, you should validate the partitioning
key that was chosen to make sure it was a good choice.