ArcSDE XML columns in Informix

ArcSDE 10 and higher release geodatabases in Informix use ArcSDE XML columns in the geodatabase system tables. ArcSDE XML columns require the Informix database to be configured to use one of the IBM Informix full-text search extensions: either the Basic Text Search (BTS) DataBlade module or the Excalibur Text Search (ETX) DataBlade module.

Recommended configurations

Informix 11.70

If you are using Informix 11.70, Esri recommends a default configuration that makes use of the BTS DataBlade module as specified by the following three DBTUNE parameters:

Parameter

Default value

XML_IDX_FULLTEXT_TYPE

"bts"

XML_IDX_FULLTEXT_PARAMS

"delete='deferred'"

XML_IDX_FULLTEXT_STORAGE

""

In addition, before creating a geodatabase, be sure that the Informix server SBSPACENAME configuration parameter specifies the name of a logged smart BLOB space. There is no need to register the BTS DataBlade module in the Informix database since Informix 11.70 supports automatic registration of built-in DataBlade modules.

Informix 11.50

If you are using Informix 11.50, the same default configuration is recommended as listed in the previous section. However, before creating a geodatabase, you must register the BTS DataBlade module in the Informix database and be sure that the Informix server SBSPACENAME configuration parameter specifies the name of a logged smart BLOB space.

The BTS v2.0 DataBlade module is bundled with IBM Informix server versions 11.50 and higher. For further information on configuration of the BTS DataBlade module, review the user guide and release notes for that product.

Additional configurations

ArcSDE for Informix continues to support the use of the ETX DataBlade module as the full-text search extension used by ArcSDE XML columns.

If you are upgrading an existing ArcSDE 9.3, 9.3.1, or 10 geodatabase for Informix that was configured to use the ETX DataBlade module, your installed configuration will continue to work.

Esri does not recommend configuring a new ArcSDE for Informix geodatabase to use the ETX DataBlade module as the full-text search extension supporting ArcSDE XML columns.

Related Topics

3/13/2015