ArcGIS Server Banner

Configuring a DB2 database to support XML columns

Configuring a DB2 database to support XML columns
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About configuring a DB2 database to support XML columns

Note:This topic was updated for 9.3.1.

NOTE: Not supported for ArcSDE for DB2 on z/OS.

ArcSDE XML columns require the DB2 Net Search Extender be installed. Once this is installed and registered with the database and your geodatabase is created and configured, you create the ArcSDE XML columns, create text indexes, and set up a metadata service user account.

After everything is set up, you need to maintain the text index and text tag indexes.

These steps are described in the following sections.

How to configure a DB2 database to support XML columns

Install and configure the Net Search Extender

  1. Install the Net Search Extender by following the instructions in the IBM documentation to install the DB2 Net Search Extender for the release of DB2 you are using.

    2. NOTE: If you upgrade your DB2 database, you will need to upgrade your Net Search Extender as well. Instructions for this migration can be found at the DB2 site. The minimum supported version of the Net Search Extender for ArcGIS 9.3 is v8.1 fix pack 14.

  2. Follow the instructions in the IBM documentation to verify the extender has been installed and is working properly.

  3. Enable the database for Net Search Extender. You do this in the same way that you enable a database for Spatial Extender. This can be accomplished either by using the control center or by issuing DB2 commands at the operating system's command prompt. A database only needs to be enabled once before the first ArcSDE XML column is created in that database.

See Also

  • Configuring a database to support XML columns
  • XML columns in the geodatabase