Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: partitioned tables and databases can not contain XML columns?

    is that true that partitioned databases (and tables) can not contain XML columns?

    I do not worry abt part. tables but we plan to migrate from v8.2 to v9.5 and start using DPF and it looks like we can not have XML columns in our tables in this case.

    Is there any way around it?

    Thanks in advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    DPF and XML columns is not yet supported up to DB2 V9.5.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Can you create a table with an XML column in a single-partition group? That might be a solution.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Nick, do you mean having a db with DPF but using XML only in non-partitioned tablespaces/tables? I guess we can find out only when we try as DB2 documentation is not very good on this subject. And that surprises me - I found this restriction in the article from DB2 magazine but in DB2 documentation.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •