Altering implicitly created XML objects

You can alter implicitly created XML objects; however, you can change only some of the properties for an XML object.

Procedure

Begin general-use programming interface information.To alter implicitly created XML objects:

Determine the restrictions on the XML object that you want to change.
The following table provides information about the properties that you can or cannot change for a particular XML object.
Option Description
XML table space You can alter the following properties:Start of change
  • BUFFERPOOL (16 KB buffer pools only)
  • COMPRESS
  • PRIQTY
  • SECQTY
  • GBPCACHE
  • USING STOGROUP
  • ERASE
  • LOCKSIZE (The only possible values are XML and TABLESPACE.)
  • SEGSIZE
  • DSSIZE
  • MAXPARTITIONS
End of change

XML table space attributes that are inherited from the base table space, such as LOG, are implicitly altered if the base table space is altered.
XML table The ALTER TABLE ALTER PARTITION statement is not supported if the table contains an XML column.
Index You cannot alter the following properties:
  • CLUSTER
  • PADDED
  • ADD COLUMN.
End general-use programming interface information.