Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737

    Unanswered: Read Only Restrictions on HADR Standby

    Currently (9.7.4) there is no support for PureXML or LOB data columns when the HADR standby is enabled for Read-Only access. Has anyone heard any rumors about if and/or when these restrictions may be lifted in future fixpacks or releases?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Sorry Marcus. A bit off topic.

    Does the ROS allow read of in-line lobs and xml ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't know if there is any distinction between regular XML/LOB and those that are defined with inline sizes. I kind of doubt it since it would then be dependent on the actual size of the data in the column and whether it was entirely contained within the inline size.

    Here is the doc:

    "The following data cannot be queried: XML, large object (LOB), long field (LF), a distinct type based on one of these data types, and structured type columns. Attempts to query these data types will receive an error (SQL1773N Reason Code 3)."

    The above information and other restrictions can be found here:
    Reads on standby restrictions - IBM DB2 9.7 for Linux, UNIX, and Windows
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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