ArcGIS Server Banner

Informix DBTUNE configuration parameters

Informix DBTUNE configuration parameters

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Configuration parameters, which are stored in the parameter_name column of the dbtune table, identify the database object to be configured or denote a specific setting. Their corresponding values, which are stored in the config_string column of dbtune, identify how the object or setting will be configured. The parameters and their configuration strings are grouped together in the dbtune table by configuration keywords. Keyword/Parameter_name combinations are unique, but most parameter_names are not and are reused under a number of different keywords throughout the dbtune table.

Valid values for the parameter_names column are fixed; you cannot invent new parameter_names. Likewise, the config_strings accept only certain numeric values or SQL strings. In most cases, these strings are appended to SQL CREATE TABLE and CREATE INDEX statements.

In geodatabases stored in an Informix database, parameter name–configuration string pairs are used by ArcSDE to do the following:

The following table is an alphabetic list of all the possible configuration parameters that can be used in a geodatabase in Informix. Following that is a more in-depth explanation of the parameters grouped by their functionality.


Parameter name Description Values
A_INDEX_ROWID Adds table object ID column index storage definition See your Informix documentation for CREATE INDEX parameters.
A_INDEX_STATEID Adds table sde_state_id column index storage definition See your Informix documentation for CREATE INDEX parameters.
A_INDEX_USER Adds table index storage definition See your Informix documentation for CREATE INDEX parameters.
A_STORAGE Adds table storage definition See your Informix documentation for CREATE TABLE parameters.
AUX_STORAGE Raster AUX table storage definition See your Informix documentation for CREATE TABLE parameters.
B_INDEX_ROWID Business table object ID column index and raster rowid index R<N>_SDE_ROWID_UK storage definition See your Informix documentation for CREATE INDEX parameters.
B_INDEX_TO_DATE Storage parameter info for creating the index R<registration_id>_sde_todate, which is used when updating the history table during an archive operation See your Informix documentation for CREATE INDEX parameters.
B_INDEX_USER Business table user index storage definition See your Informix documentation for CREATE INDEX parameters.
B_RTREE Business table R-tree index storage definition See your Informix documentation for CREATE INDEX parameters.

The default value in DBTUNE is blank; therefore, the Informix default is used. Consult your Informix documentation for this value.
B_STORAGE Business table and raster attribute table storage definition See your Informix documentation for CREATE TABLE parameters.
BLK_INDEX_COMPOSITE Raster BLK table composite column index storage definition See your Informix documentation for CREATE INDEX parameters.
BLK_LOB_STORAGE Allows you to specify a storage location for raster block data See your Informix documentation for CREATE TABLE parameters.
BLK_STORAGE Raster BLK table storage definition See your Informix documentation for CREATE TABLE parameters.
BND_STORAGE Raster BND table storage definition See your Informix documentation for CREATE TABLE parameters.
COMMENT Line used for comments Can place any comment up to 2048 characters
D_INDEX_DELETED_AT Deletes table sde_deleted_at column index storage definition See your Informix documentation for CREATE INDEX parameters.
D_INDEX_ STATE_ROWID Deletes table sde_states_id and sde_deletes_row_id column index storage definition See your Informix documentation for CREATE INDEX parameters.
D_STORAGE Deletes table storage definition See your Informix documentation for CREATE TABLE parameters.
LD_INDEX_DATA_ID Sde_logfile_data storage definition See your Informix documentation for CREATE INDEX parameters.
LD_INDEX_ROWID Sde_logfile_data and sde_logpool<sde_id> tables' sde_rowid column index storage definition See your Informix documentation for CREATE INDEX parameters.
LD_STORAGE Sde_logfile_data and sde_logpool<sde_id> tables' storage definition See your Informix documentation for CREATE TABLE parameters.
LF_INDEXES Sde_logfiles table column indexes storage definition See your Informix documentation for CREATE INDEX parameters.
LF_STORAGE Sde_logfiles table storage definition See your Informix documentation for CREATE TABLE parameters.
MAX_CACHED_CURSORS Maximum number of cached cursors 0 or higher

0 = disabled

80
MVTABLES_MODIFIED_INDEX Mvtables_modified index storage definition See your Informix documentation for CREATE INDEX parameters.
MVTABLES_MODIFIED_TABLE Mvtables_modified table storage definition See your Informix documentation for CREATE TABLE parameters.
RAS_STORAGE Raster RAS table storage definition See your Informix documentation for CREATE TABLE parameters.
S_STORAGE Represents a "smart blob sbspace" See your Informix documentation for CREATE TABLE parameters.
SESSION_INDEX ArcSDE session-based and stand-alone log file indexes storage definition See your Informix documentation for CREATE INDEX parameters.
SESSION_STORAGE ArcSDE session-based and stand-alone log file tables storage definition See your Informix documentation for CREATE TABLE parameters.
SESSION_TEMP_TABLE Controls whether or not log files get created in tempdb 1 or 0

1 = create in tempdb

0 = don't create in tempdb

Though present, is not used in Informix databases
STATES_INDEX States table storage definition See your Informix documentation for CREATE INDEX parameters.
STATES_LINEAGES_TABLE State_lineages table storage definition See your Informix documentation for CREATE TABLE parameters.
STATES_TABLE States table storage definition See your Informix documentation for CREATE TABLE parameters.
UI_NETWORK_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of network configuration Description up to 2048 characters
UI_TERRAIN_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of terrain configuration Description up to 2048 characters
UI_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of associated noncomposite configuration keyword Description up to 2048 characters
UI_TOPOLOGY_TEXT User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of topoology configuration Description up to 2048 characters
USE_EXCLUSIVE_LOCKING Use Exclusive Locking during ArcSDE compress TRUE or FALSE
VERSIONS_INDEX Version index storage definition See your Informix documentation for CREATE INDEX parameters.
VERSIONS_TABLE Versions table storage definition See your Informix documentation for CREATE TABLE parameters.
XML_DOC_LOB_STORAGE Storage and access information for XML documents in the xml_doc column of the sde_xml_doc<n> table Provide the name of a Smart BLOB space where the LOB data will be stored, "<SBLOBspace_name>"
XML_DOC_STORAGE Storage clause for sde_xml_doc<n> table See your Informix documentation for CREATE TABLE parameters.
XML_DOC_VAL_LOB_STORAGE Storage and access information for the XML document content in the xml_doc_val column of the sde_xml_doc<n> table Provide the name of a Smart BLOB space where the LOB data will be stored, "<SBLOBspace_name>"
XML_IDX_FULLTEXT_PARAMS A comma-separated list of secondary access method parameter-value pairs as required by the DataBlade Module you are using: either Excalibur TextSearch (ETX) or Basic Text Search (BTS). There is no default value set for this parameter.

If you are using the Excalibur Text

Search (ETX) DataBlade Module, settings such as the following would be used:

CHAR_SET='ISO',PHRASE_SUPPORT='MAXIMUM'

Consult the Excalibur Text Search DataBlade Module User's Guide for valid character set and phrase support settings and what they mean.

When using the Basic Text Search (BTS) DataBlade Module, an example setting is as follows:
delete='deferred'

XML_IDX_FULLTEXT_STORAGE Indicates the Smart BLOB space or Extspace in which the text index will be stored When using the ETX DataBlade Module, specify the name of a logged SmartBLOB space in which the ETX full-text index will be created. For further details, see the ETX DataBlade Module documentation.

When using the BTS DataBlade Module, specify the name of an Extspace in which the BTS full-text index will be created. For further details, see the BTS DataBlade Module documentation.
XML_IDX_FULLTEXT_TYPE The type of text index used If you are using the ETX DataBlade Module, set to etx. If using the BTS DataBlade Module, set this parameter to bts.
XML_IDX_INDEX_DOUBLE Storage clause for the xmlix<n>_db index on the double_tag column of the sde_xml_idx<n> table See your Informix documentation for CREATE INDEX parameters.
XML_IDX_INDEX_ID Storage clause for the xmlix<n>_id index on the ID column of the xml_idx<n> table See your Informix documentation for CREATE INDEX parameters.
XML_IDX_INDEX_STRING Storage clause for xmlix<n>_st index on the string_tag column of the sde_xml_idx<n> table See your Informix documentation for CREATE INDEX parameters.
XML_IDX_INDEX_TAG Storage clause for the xmlix<n>_tg index on the tag_id column of the sde_xml_idx<n> table See your Informix documentation for CREATE INDEX parameters.
XML_IDX_STORAGE Storage clause for sde_xml_idx<n> table (the index table of an XML column) See your Informix documentation for CREATE TABLE parameters.
XML_IDX_TEXT_TAG_STORAGE Storage and access information for the contents of the text_tag column in the sde_xml_idx<n> table (the index table of an XML column) Provide the name of a Smart BLOB space where the LOB data will be stored, "<SBLOBspace_name>"
XML_INDEX_TAGS_INDEX Storage clause for xml_indextags_pk index of the sde_xml_indexes table See your Informix documentation for CREATE INDEX parameters.
XML_INDEX_TAGS_TABLE Storage clause for sde_xml_index_tags table and the xml_indextags_ix1 and xml_indextags_ix2 indexes on the tag_name and tag_alias columns, respectively See your Informix documentation for CREATE TABLE parameters.

NOTE: For the XML parameters, <n> refers to the xml_column_id associated with a specific XML column.

Functional descriptions of parameters

See Also

  • DBTUNE configuration parameter name-configuration string pairs