Disable a column if you need to update a DAD file for the XML column, or if you want to delete the XML column or the table that contains the column. After the column is disabled, you can re-enable the column with the updated DAD file, delete the column, or other tasks. You can disable a column by using the XML Extender administration wizard or using the DB2 command shell.
When the XML Extender enables an XML column, it:
Important: If you drop a table with an XML column, without first disabling the column, XML Extender cannot drop any side the tables associated with the XML column, which might cause unexpected results.
Ensure that the XML column to be disabled exists in the current DB2 database.
Use the following steps to disable XML columns:
To disable an XML column, enter the following command:
Syntax:
dxxadm disable_column |
---|
>>-dxxadm---disable_column---dbName---tbName---colName--------->< |
Parameters:
Example: The following example disables a column using the DB2 command shell. The DAD file and XML document can be found in Appendix B, Samples.
dxxadm disable_column SALES_DB sales_tab order
In this example, the column ORDER is disabled in the table SALES_DB.SALES_TAB.
When the column is disabled, the side tables are dropped.