Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Detach of partition and the data is still in the original ..

  
   Database Help (Home) -> DB2 RSS
Next:  Kernel parameters for db2 v8.2 on Solaris 10  
Author Message
Justin

External


Since: Feb 07, 2008
Posts: 15



(Msg. 1) Posted: Wed Oct 08, 2008 12:08 pm
Post subject: Detach of partition and the data is still in the original table
Archived from groups: comp>databases>ibm-db2 (more info?)
Do I have to set integrity or refresh the table in order to complete
the "detach of the partition"?

 >> Stay informed about: Detach of partition and the data is still in the original .. 
Back to top
Login to vote
Justin

External


Since: Feb 07, 2008
Posts: 15



(Msg. 2) Posted: Wed Oct 08, 2008 12:29 pm
Post subject: Re: Detach of partition and the data is still in the original table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Never mind. Set integrity nor a refresh is required.

I made an error.

On Oct 8, 3:08 pm, Justin <kfw....DeleteThis@hotmail.com> wrote:
> Do I have to set integrity or refresh the table in order to complete
> the "detach of the partition"?

 >> Stay informed about: Detach of partition and the data is still in the original .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Updating Partition Key with Before Trigger - We are looking at the possibility of using a before trigger to provide the value for the partitioning key of a table. It strikes me as something that would not work, but I have been surprised before. Does anyone know whether this is allowed with DB2 8....

Partition an existing table? - Can I partition an existing table? I have a table which has started growing at a very fast pace and would like to partition it. Thanks. Cheers, San.

Range partition overlap - What is the syntax to overlap partitions? Lets assume I want a year split amount 4 months (3 partitions for a year) and later adding an additional set of partitions for every 6 months. Plus giving us the option to detach old partitions. For example:..

Force index cleanup after detaching partition? - DB2 V9.5 LUW, Is there any way that one can force Asynchronous index cleanup (AIC) after detaching a partition in a range partitioned table? Thanx in advance /Lennart

Add a DB2 database partition in different drive - Hi, I would like to add a DB2 database partition in different drive eg: existing DB partition drive H, now we need to add drive J please help me on this, looking for the earliest reply regards sathish 65 96724662 basissathish at aol dot com
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]