Online reorg of table with XML colums

sysdba1 · #1 (**permalink**) 04-24-12, 15:53

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

Thanks,
Ram

ARWinner · #2 (**permalink**) 04-24-12, 16:22

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

honeee · #3 (**permalink**) 04-25-12, 02:11

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.

sathyaram_s · #4 (**permalink**) 04-25-12, 04:40

Quote:

Originally Posted by honeee

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 ?

Internet Services

Web Development

Digital Marketing

Consumer Tech