What is the maximum size that can be specified when creating an XML column in a DB2 table?
-
No size is specified
-
The buffer pool size
-
The page size for the table space
-
The extent size for the table space
When creating an XML column in DB2, no size specification is required or allowed. XML data is stored internally in a parsed hierarchical format, and DB2 manages the storage automatically. The buffer pool size, page size, and extent size are table space storage attributes, not column-level specifications for XML data.
DB2 XML columns are declared simply as type XML with no length or size specification, unlike VARCHAR or CHAR columns. This is because XML documents are stored internally in a specialized hierarchical format (XML storage objects) rather than as fixed- or variable-length character data, so a byte-size limit doesn't apply the same way.