If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Online reorg of table with XML colums

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Posts: 33
Online reorg of table with XML colums

Does DB2 allow to run an online reorg on a table with XML Columns or LOB's in any DB2 version ?

Thanks,
Ram
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Posts: 4,098
From the manual (V9.5):

Code:
INPLACE
    Reorganizes the table while permitting user access.

    In place table reorganization is allowed only on nonpartitioned and non-MDC tables with type-2 indexes, but without extended indexes and with no indexes defined over XML columns in the table. In place table reorganization can only be performed on tables that are at least three pages in size.
So as long as there is no index on the XML columns, I would say yes.

Andy
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Apr 2012
Posts: 1
help me in this query

HI All,
I want a details like diff b/w 1st and 2nd maximum dates should be greater than 90 days. I am able to write 1st max greater than 2nd max date, but I have to add 90 days also. how to add given date to 90 days?? I want see those records, please help me.
Reply With Quote
  #4 (permalink)  
Old
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,649
Quote:
Originally Posted by honeee View Post
HI All,
I want a details like diff b/w 1st and 2nd maximum dates should be greater than 90 days. I am able to write 1st max greater than 2nd max date, but I have to add 90 days also. how to add given date to 90 days?? I want see those records, please help me.
How is this related to the original post ?
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On