Informix DBTUNE configuration parameters |
|
Release 9.3 |
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 01 = 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:
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:
|
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.
NOTE: ArcSDE registers all tables that it creates. Tables not created by ArcSDE can also be registered with the sdetable or sdelayer commands. The table_registry system table maintains a list of the currently registered tables.
NOTE: If you do not use XML columns and XML documents in your geodatabase, you do not need to configure these parameters.
XML configuration parameters are used to specify storage information for the tables and indexes used to track and store XML documents. There are three XML configuration parameters specific to Informix that must have proper values specified for them for full-text indexing and metadata services to function correctly: XML_IDX_FULLTEXT_TYPE, XML_IDX_FULLTEXT_PARAMS, and XML_IDX_FULLTEXT_STORAGE. The XML_IDX_FULLTEXT_TYPE parameter specifies the secondary index access method provided by the full-text search DataBlade Module you are using. When using the Excalibur Text Search (ETX) DataBlade Module, the value for this parameter should be specified as follows:XML_IDX_FULLTEXT_TYPE "etx"
XML_IDX_FULLTEXT_TYPE "bts"
XML_IDX_FULLTEXT_PARAMS "CHAR_SET='ISO',PHRASE_SUPPORT='MAXIMUM'"
XML_IDX_FULLTEXT_PARAMS "delete='deferred'"
XML_IDX_FULLTEXT_STORAGE "sbspace2"
XML_IDX_FULLTEXT_STORAGE "bts_extspace"
CREATE INDEX xmldoc1_txt ON sde_xml_doc1 (xml_doc_val etx_clob_ops)
USING etx ( CHAR_SET='ISO',PHRASE_SUPPORT='MAXIMUM' ) IN sbspace2
CREATE INDEX xmldoc1_txt ON sde_xml_doc1 (xml_doc_val bts_clob_ops)
USING bts ( delete='deferred' ) IN bts_extspace
XML_DOC_LOB_STORAGE "<SBLOBspace name>"
XML_DOC_VAL_LOB_STORAGE "<SBLOBspace name>"
XML_IDX_TEXT_TAG_STORAGE "<SBLOBspace name>"
XML_INDEX_TAGS_TABLE "IN <DBspace name> EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
XML_INDEX_TAGS_INDEX "FILLFACTOR 90 IN <DBspace name>"
XML_DOC_STORAGE "IN <DBspace name> EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
XML_IDX_STORAGE "IN <DBspace name> EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
XML_IDX_INDEX_ID "FILLFACTOR 90 IN <DBspace name>"
XML_IDX_INDEX_TAG "FILLFACTOR 90 IN <DBspace name>"
XML_IDX_INDEX_DOUBLE "FILLFACTOR 90 IN <DBspace name>"
XML_IDX_INDEX_STRING "FILLFACTOR 90 IN <DBspace name>"
#COMMENT "This keyword is used by ArcSDE to create log file tables for all users logged in as editor"