468,110 Members | 1,893 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,110 developers. It's quick & easy.

pureXML support in DPF

In Information Center it says;
"Restrictions 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.

May 16 '07 #1
2 1501
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
May 16 '07 #2
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

May 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Aditya Ivaturi | last post: by
3 posts views Thread by Chris Hope | last post: by
5 posts views Thread by shaun.mostashari | last post: by
5 posts views Thread by NormaJean Sebastian via DBMonster.com | last post: by
4 posts views Thread by Juan T. Llibre | last post: by
reply views Thread by maism_mca | last post: by
3 posts views Thread by Mark A | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.