IBM Books

XML Extender Administration and Programming

Disabling XML collections

Disabling an XML collection removes the record in the XML_USAGE table that identify tables and columns as part of a collection. It does not drop any data tables. You disable a collection when you want to update the DAD and need to reenable a collection, or to drop a collection.

You can disable an XML collection through the XML Extender administration wizard, using the dxxadm command with the disable_collection option, or using the XML Extender stored procedure dxxDisableCollection().

Using the administration wizard

Use the following steps to disable an XML collection.

  1. Set up and start the administration wizard. See Starting the administration wizard for details.
  2. Click Work with XML Collections from the LaunchPad window to view the XML Extender collection related tasks. The Select a Task window is displayed.
  3. Click Disable an XML Collection and then Next to disable an XML collection. The Disable a Collection window is displayed.
  4. Type the name of the collection you want to disable in the Collection name field.
  5. Click Finish to disable the collection and return to the LaunchPad window.

From the DB2 command shell

To disable an XML collection, enter the dxxadm command:

Syntax:
dxxadm disable_collection
>>-dxxadm---disable_collection---dbName---collection-----------><
 

Parameters:

dbName
The name of the database.

collection
The name of the XML collection. This value is used as a parameter for the XML collection stored procedures.

Example:

dxxadm disable_collection SALES_DB sales_ord


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]