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 "redistribu te 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
1  4540 
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.c om> wrote in message news:21******** *************** ***@posting.goo gle.com...
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 "redistribu te 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: EggHead |
last post by:
Hi all,
I am trying to implement Drag and Drop with my TreeView Control. The problem is, when I click on a node, drag it, and drop it to other node. The dropped node does not hold the drop postion. It moves to the top of the nodes.
BTW, I am using VB6.0 here.
here is the codes
------------------
Private Sub TreeView1_OLEDragDrop(Data...
|
by: Wang, Jay |
last post by:
Hello, all,
I would like to enable some text between <SPAN
url="http://www.testserver.com/">WORD TO BE DRAGGED </SPAN>. I put some
javascript and it will extract http://www.testserver.com/ from the the span
element when I select the whole text in the SPAN and drag it.
However, I want to drag it without have to select the words between the...
|
by: Norbert Heidbüchel |
last post by:
Hi all,
I have read a lot of postings and web pages about drag and drop
and treeviews, but could not find an answer to my problem. Sorry, if I
missed something.
I am trying to drag and drop treenodes defined by myself and
don't understand, how to get the nodes data in the dragdrop event.
I'm not very experienced in .NET and for sure there...
|
by: ramyach |
last post by:
Hi friends,
I need to write a parallel code in 'C' on the server that is
running SGI Irix 6.5. This server supports MIPS Pro C compiler. I don't
have any idea of parallel C languages. I looked into few posts in this
group. I could make out that there are several languages for parallel
programming and parallel C is one of them. I need to know...
|
by: Terry Olsen |
last post by:
My first time using TreeViews. I have TreeView1 set up to display my
directory structure just like Windows Explorer. I can drag & drop files and
folders over to TreeView2. I can re-arrange the structure in TreeView2
(putting files in different folders and such...like you do when you create a
structure for burning a CD).
I have two...
| | |
by: Visu |
last post by:
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...
|
by: kidelectric |
last post by:
The issue I am having is that I would like to be able to drag-and-drop div elements that have rounded corners.* Since these elements will be dynamically created (including background color), I could not use the "standard" rounded corner method of sliced images for the corners (since that would only allow a certain color to match)
I tried using...
|
by: Archanak |
last post by:
Hi,
I am using 2-level CSS Drop Down Menu in my perl/CGI program.
here is the code.
#!c:/perl/bin/perl.exe
use CGI qw(:standard);
|
by: mjm2114 |
last post by:
Hi there,
I have a question on a naive implementation of a parallel MT that I've
done using the fortran version of MT19937ar.f posted in Prof.
Matsumoto's website. (http://www.math.sci.hiroshima-u.ac.jp/~m-mat/MT/
MT2002/emt19937ar.html)
First, I setup a KISS RNG (Marsaglia, 1999)
in the master node and seed it. I then use the first 4...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
