******************************************************************** Product Name : DB2 XML Extender Version 7.1 for Windows PTF Number : 010507 Package Date : Mon May 7, 2001 Build Level : s010111 ******************************************************************** APARS IN 010507 =============== APAR No. Abstract -------- ------------------------------------------------------- IY15160 Memory overwrite due to UDF returning value > 4k bytes JR15353 Memory overwrite when enabling an XML collection that have more than 20 columns in a table ------- UDB V7.1 FP2, JDBC problem with passing CLOBs to STP JR15268 Last character of the XML document returned by db2xml.Content is dropped JR15824 Users are unable to log UDT XMLClob because it is defined as CLOB(2g) ------- Increase internal buffer size for SQL statement ------- SQL composition not defaulting to multi_occurrence=NO APAR IY15160 DETAILS -------------------- Problem Description: The db2xml.extractVarchar and db2xml.extractVarchars UDFs do not check that extracted element values are less than 4000 bytes, resulting in a memory overwrite. Fix Description: db2xml.extractvarchar and db2xml.extractVarchars UDFs have been modified to check that a maximum of 3999 bytes of data and a terminating NULL were returned. If the total number of bytes of the returned data and NULL terminator is greater than 4000 bytes, a DXXG001E error message is returned with SQLSTATE 38X39. APAR JR15353 DETAILS -------------------- Problem Description: When running the "dxxadm enable_collection..." command, a memory overwrite occurs if the DAD associates more than twenty text or attribute nodes with one table. Fix Description: For a given table specified in the DAD, there can now be at most 100 columns mapped to either text or attribute nodes. If more than 100 columns per table are specified, the error message "DXXG001E An internal error occured [sic]" is returned. APAR JR15268 DETAILS -------------------- Problem Description: db2xml.Content operating on a column of type db2xml.XMLClob might result in an XML document where the very last character is dropped. APAR JR15824 DETAILS -------------------- Problem Description: Users are unable to log UDT XMLCLOB because it is defined as CLOB(2G). Fix Description: Modify code to allow users to pre-create the UDT XMLCLOB as CLOB(1G) before enabling database for XML. To create UDT XMLCLOB do the following: "create distinct type db2xml.XMLCLOB as CLOB(1G)" To enable database for XML, do: "dxxadm enable_db ..."