468,316 Members | 2,029 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

redistribute nodegroup

DB2 v7.2 EEE on AIX

I am trying to redistribute the data for a table that is skewed and
wondering if the output of db2gpmap is optimized or is it just
displaying the current information? I also read some where that LOAD
can be used in analyze mode?

Is there a way to redistribute just one table in the nodegroup? I have
mutiple tables in a nodegroup and i don't see any commands other than
REDISTRIBUTE NODEGROUP

Thanks
Visu

Apr 13 '06 #1
4 1906
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

Apr 13 '06 #2
Thanks for the info Shashi.

Do you know if there is a way to re-distribute just one table and not
all tables in the node group

Apr 13 '06 #3
Ian
Visu wrote:
DB2 v7.2 EEE on AIX

I am trying to redistribute the data for a table that is skewed and
wondering if the output of db2gpmap is optimized or is it just
displaying the current information? I also read some where that LOAD
can be used in analyze mode?

Is there a way to redistribute just one table in the nodegroup? I have
mutiple tables in a nodegroup and i don't see any commands other than
REDISTRIBUTE NODEGROUP


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.

Apr 14 '06 #4
Thanks Ian. I bielieve the option of validating the partitioning key
and re-loading the data will be the best choice for me.

Apr 14 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Merak | last post: by
1 post views Thread by Cleyton | last post: by
1 post views Thread by Shawn | last post: by
1 post views Thread by adebiasio | last post: by
6 posts views Thread by Dylan Copeland | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.