pureXML support in DPF

[Sam Durai]

In Information Center it says;
"Restrictio ns on database partitions
- The use of any features of the native XML data store will prevent
future use of the database partitioning feature available with DB2
Enterprise Server Edition.
- An XML column or XML schema repository (XSR) object cannot be
defined in a table of a database with more than one database partition
defined.
- If a database is defined with a single database partition and
includes XML columns or XSR objects, then a new database partition
cannot be added."

It looks like you can create XML datatype in DPF but cannot use any of
DPF advantages...

Doesn't this mean pureXML datatype is NOT supported on DPF?

What exactly is "prevent future use of the database partitioning
feature" mean?

Thanks in advance.

[Serge Rielau]

Sam Durai wrote:

Doesn't this mean pureXML datatype is NOT supported on DPF?

Correct

What exactly is "prevent future use of the database partitioning
feature" mean?

It means you can't cheat and create n XML column and later add a second
database partition.

Teh demand for XML in the warehouse is surprisingly high, so it's
reasonable to assume that this limitation won't last forever.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[peteh]

What exactly is "prevent future use of the database partitioning
feature" mean?

Hi Sam;
It is true that an XML-enabled database cannot use DPF. You will
actually get a warning during the install process that tells you that
selecting the XML configuration will "prevent future use of the
database partitioning feature" - i.e. DPF.

Pete H