By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,377 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

ESE parallel db - how to drop a node from nodegroup

P: n/a
Dear all
I want to drop a node from a nodegroup. Can someone confirm if its
enough to redistribute a node group with a partition map which doesn't
include the node to be dropped?

I can't see any other way to drop node 3 from my setup of 5 nodes than
to make a partmap file, DNODE_tmap, formatted so
1
2
4
5
.... for 4096 lines, then do
db2 "redistribute database partition group DNODE using targetmap
DNODE_tmap "

This seems to work, but what is the "drop database partition" option
for? Is there, as I suspect a better way to do this? After I have done
the above command, the "alter database partition" command with drop
option isn't necessary.

thx for any help
Charles
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I think you are heading the in the right direction ... the redistribute command can be used not only to move the data, but also can be used to drop the partition from the system. You can also use the ALTER DATABASE PARTITION GROUP command to drop the partition once the data is moved. You can use the DROP DBPARTITIONNUM VERIFY command to ensure the partition can now be removed. For more details I refer you to the DB2 UDB V8.1 Command Reference.

Good luck!

--

Bob
Consulting I/T Specialist
IBM Toronto Lab
IBM Software Services for Data Management
[My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
"riehe" <cw***@europe.com> wrote in message news:21**************************@posting.google.c om...
Dear all
I want to drop a node from a nodegroup. Can someone confirm if its
enough to redistribute a node group with a partition map which doesn't
include the node to be dropped?

I can't see any other way to drop node 3 from my setup of 5 nodes than
to make a partmap file, DNODE_tmap, formatted so
1
2
4
5
... for 4096 lines, then do
db2 "redistribute database partition group DNODE using targetmap
DNODE_tmap "

This seems to work, but what is the "drop database partition" option
for? Is there, as I suspect a better way to do this? After I have done
the above command, the "alter database partition" command with drop
option isn't necessary.

thx for any help
Charles
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.