DB2 DBTUNE configuration parameters |
|
Release 9.3 |
Configuration keyword | Parameters |
---|---|
DATA_DICTIONARY | B_STORAGE MVTABLES_MODIFIED_TABLE STATE_LINEAGES_TABLE STATES_TABLE VERSIONS_TABLE XML_INDEX_TAGS_TABLE (Does not apply to DB2 for z/OS) |
DEFAULTS | A_STORAGE AUX_STORAGE B_STORAGE BLK_STORAGE BND_STORAGE D_STORAGE MAX_CACHED_CURSORS RAS_STORAGE XML_DOC_STORAGEXML_IDX_STORAGE (Does not apply to DB2 for z/OS) |
LOGFILE_DEFAULTS | LD_STORAGE LF_STORAGE SESSION_INDEX SESSION_STORAGE |
NETWORK_DEFAULTS | A_STORAGE B_STORAGE D_STORAGE |
NETWORK_DEFAULTS::DESC | A_STORAGE B_STORAGE D_STORAGE |
TOPOLOGY_DEFAULTS | A_STORAGE B_STORAGE D_STORAGE |
TOPOLOGY_DEFAULTS::DIRTYAREAS | A_STORAGE B_STORAGE D_STORAGE |
TERRAIN_DEFAULTS | A_STORAGE B_STORAGE D_STORAGE |
TERRAIN_DEFAULTS::EMBEDDED | A_STORAGE B_STORAGE D_STORAGE |
Parameter name | Description | Values | Notes |
---|---|---|---|
A_INDEX_ROWID | Adds table object ID column index storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
A_INDEX_SHAPE | Adds table spatial column index storage definition | See your DB2 documentation for CREATE INDEX parameters. | Does not apply to DB2 for z/OS |
A_INDEX_STATEID | Adds table sde_state_id column index storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
A_INDEX_USER | Adds table index storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
A_STORAGE | Adds table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
AUX_STORAGE | Raster AUX table storage definition | See your DB2 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 DB2 documentation for CREATE INDEX parameters. | |
B_INDEX_SHAPE | Business table spatial column index storage definition | See your DB2 documentation for CREATE INDEX parameters. | Does not apply to DB2 for z/OS |
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 DB2 documentation for CREATE INDEX parameters. | |
B_INDEX_USER | Business table user index storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
B_RUNSTATS | Default value for RUNSTATS | YES(default for DB2 on Linux, UNIX, and Windows) or NO (default for DB2 z/OS) | |
B_STORAGE | Business table and raster attribute table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
BLK_BLOB_OPTION | Storage configuration properties of BLOB columns in the raster BLK table | LOGGED NOT COMPACT (default for DB2 on Linux, UNIX, and Windows) or LOGGED COMPACT or NOT LOGGED COMPACT or NOT LOGGED NOT COMPACT | The default value for this parameter in DB2 for z/OS is blank, and it should remain blank. For DB2 for Linux, UNIX, or Windows, set to NOT LOGGED COMPACT. Setting this parameter to any other value can take up a lot more table space when loading raster data. |
BLK_INDEX_COMPOSITE | Raster BLK table composite column index storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
BLK_STORAGE | Raster BLK table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
BLOB_OPTION | Storage configuration properties of the BLOB column | LOGGED NOT COMPACT (default for DB2 on Linux, UNIX, and Windows) or LOGGED COMPACT or NOT LOGGED COMPACT or NOT LOGGED NOT COMPACT | The default value for this parameter in DB2 for z/OS is blank, and it should remain blank. |
BLOB_SIZE | Size of BLOB column | > 0 and < 2G 1M If BLOB_OPTION is set to LOGGED, BLOB size cannot be larger than 1G. (DB2 recommends logged BLOB columns not be larger than 10M.) | |
BND_STORAGE | Raster BND table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
CLOB_OPTION | Storage configuration properties of the CLOB column | LOGGED NOT COMPACT (default for DB2 on Linux, UNIX, and Windows) or LOGGED COMPACT or NOT LOGGED COMPACT or NOT LOGGED NOT COMPACT | The default value for this parameter in DB2 for z/OS is blank, and it should remain blank. |
CLOB_SIZE | Size of CLOB column | > 0 and < 2G 32K If CLOB_OPTION is set to LOGGED, CLOB column cannot be larger than 1G. (DB2 recommends logged LOB columns not be larger than 10M.) | |
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 DB2 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 DB2 documentation for CREATE INDEX parameters. | |
D_STORAGE | Deletes table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
LD_INDEX_DATA_ID | SDE_logfile_data storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
LD_INDEX_ROWID | SDE_logfile_data table SDE_ROWID column index storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
LD_STORAGE | SDE_logfile_data table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
LF_INDEXES | SDE_logfiles table column indexes storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
LF_STORAGE | SDE_logfiles table storage definition | See your DB2 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 DB2 documentation for CREATE INDEX parameters. | |
MVTABLES_MODIFIED_TABLE | Mvtables_modified table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
RAS_STORAGE | Raster RAS table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
SESSION_INDEX | ArcSDE session-based and stand-alone log file indexes storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
SESSION_STORAGE | ArcSDE session-based and stand-alone log file tables storage definition | See your DB2 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 | |
STATES_INDEX | States table storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
STATES_LINEAGES_TABLE | State_lineages table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
STATES_TABLE | States table storage definition | See your DB2 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 | |
VERSIONS_INDEX | Versions table index storage definition | See your DB2 documentation for CREATE INDEX parameters. | |
VERSIONS_TABLE | Versions table storage definition | See your DB2 documentation for CREATE TABLE parameters. | |
XML_DOC_LOB_SIZE | Defines the size of the XML documents in the xml_doc column of the sde_xml_doc<n> table | 1 M | Does not apply to DB2 for z/OS |
XML_DOC_STORAGE | Storage clause for sde_xml_doc<n> table | See your DB2 documentation for CREATE TABLE parameters. | Does not apply to DB2 for z/OS |
XML_DOC_UNCOMPRESSED_TYPE | When the XML_DOC_MODE parameter is set to UNCOMPRESSED, the XML_DOC_UNCOMPRESSED_TYPE parameter determines the storage format for XML documents | Since XML_DOC_MODE is set to COMPRESSED by default, the XML_DOC_UNCOMPRESSED_TYPE parameter is not present by default. Possible values are BLOB, CLOB, or NCLOB | Does not apply to DB2 for z/OS |
XML_DOC_VAL_LOB_SIZE | Defines size of the XML document in the xml_doc_val column of the sde_xml_doc<n> table | 1 M | Does not apply to DB2 for z/OS |
XML_IDX_FULLTEXT_CCSID | Text index Coded Character Set Identifier (CCSID); specify the CCSID of the documents if the text documents are stored as binary. | Consult your DB2 documentation for valid CCSID values. | Does not apply to DB2 for z/OS |
XML_IDX_FULLTEXT_IDXDIRECTORY | Path to text index directory | Value depends on your directory | Does not apply to DB2 for z/OS |
XML_IDX_FULLTEXT_LANGUAGE | The language used for linguistic analysis when building the text index on the contents of the xml_doc_val column in the sde_xml_doc<n> table and the text_tag column of the sde_xml_idx<n> table | There is no default value set for this parameter. Consult your DB2 documentation for valid language settings. | Does not apply to DB2 for z/OS |
XML_IDX_FULLTEXT_UPD_COMMIT | Index update commit_count | AUTOMATIC or an integer greater than 0 (If set to 0, no commits are performed.) Consult your DB2 documentation for more information on the COMMIT_COUNT option. | Does not apply to DB2 for z/OS |
XML_IDX_FULLTEXT_UPD_FREQUENCY | Index update frequency | Number of days and hours index is to be updated There is no default value set for this parameter. | Does not apply to DB2 for z/OS |
XML_IDX_FULLTEXT_UPD_MINIMUM | Minimum number of new or edited documents before full text index is updated | There is no default value set for this parameter. If the value is left blank, the index will be updated for all additions/edits made during the update frequency. | Does not apply to DB2 for z/OS |
XML_IDX_FULLTEXT_WKDIRECTORY | Path to text index working directory | Value depends on your directory | Does not apply to DB2 for z/OS |
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 DB2 documentation for CREATE INDEX parameters. | Does not apply to DB2 for z/OS |
XML_IDX_INDEX_ID | Storage clause for the xmlix<n>_id index on the ID column of the xml_idx<n> table | See your DB2 documentation for CREATE INDEX parameters. | Does not apply to DB2 for z/OS |
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 DB2 documentation for CREATE INDEX parameters. | Does not apply to DB2 for z/OS |
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 DB2 documentation for CREATE INDEX parameters. | Does not apply to DB2 for z/OS |
XML_IDX_STORAGE | Storage clause for sde_xml_idx<n> table (the index table of an XML column) | See your DB2 documentation for CREATE TABLE parameters. | Does not apply to DB2 for z/OS |
XML_INDEX_TAGS_INDEX | Storage clause for xml_indextags_pk index of the sde_xml_indexes table | See your DB2 documentation for CREATE INDEX parameters. | Does not apply to DB2 for z/OS |
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 DB2 documentation for CREATE TABLE parameters. | Does not apply to DB2 for z/OS |
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 register operation of the sdetable or sdelayer commands. The SDE.TABLE_REGISTRY system table maintains a list of the currently registered tables.
The B_INDEX_SHAPE parameter only applies to DB2 for Linux, UNIX, and Windows, and it holds the storage configuration of the spatial column index that ArcSDE creates when a spatial column is added to a business table. This index is created by the ArcSDE C API function SE_layer_create. This function is called by ArcGIS when it creates a feature class and by the add operation of the sdelayer command. The B_INDEX_TO_DATE parameter specifies the storage for the index R<registration_id>_sde_todate. This index is created when archiving is enabled on a business table, and is used when updating the history table during an archive operation.NOTE: XML parameters do not apply to geodatabases on DB2 for z/OS. Additionally, if you do not use XML columns and XML documents in your geodatabase in DB2 on Linux, UNIX, or Windows, you don't need to configure these parameters.
DB2 XML parameters include the following: XML_INDEX_TAGS_TABLEXML_INDEX_TAGS_INDEXXML_DOC_STORAGEXML_DOC_LOB_SIZEXML_DOC_VAL_LOB_SIZEXML_DOC_MODE (not present by default)XML_DOC_UNCOMPRESSED_TYPEXML_IDX_STORAGEXML_IDX_INDEX_IDXML_IDX_INDEX_TAGXML_IDX_INDEX_DOUBLEXML_IDX_INDEX_STRINGXML_IDX_FULLTEXT_UPD_FREQUENCYXML_IDX_FULLTEXT_UPD_MINIMUMXML_IDX_FULLTEXT_UPD_COMMITXML_IDX_FULLTEXT_IDXDIRECTORYXML_IDX_FULLTEXT_WKDIRECTORYXML_IDX_FULLTEXT_LANGUAGEXML_IDX_FULLTEXT_CCSID There are two XML parameters in the DATA_DICTIONARY keyword's parameter list, XML_INDEX_TAGS_TABLE and XML_INDEX_TAGS_INDEX. The XML_INDEX_TAGS_TABLE parameter specifies in which table space the SDE_XML_INDEX_TAGS system table and its indexes, xml_indextags_ix1 and xml_indextags_ix2, will be created. If you want to specify a separate table space for these objects, you must uncomment the XML_INDEX_TAGS_TABLE parameter and provide an existing table space name prior to creating your geodatabase. Similarly, the value for the XML_INDEX_TAGS_INDEX parameter, which specifies how the xml_indexes_pk index of the SDE_XML_INDEXES will be stored, must also be altered before you create the geodatabase. The XML_DOC_STORAGE, XML_DOC_LOB_SIZE, and XML_DOC_VAL_LOB_SIZE parameters specify storage for the SDE_XML_DOC<n> table. XML_DOC_STORAGE defines the storage of the table itself, XML_DOC_LOB_SIZE specifies the size of the XML documents in the xml_doc column in the table, and XML_DOC_VAL_LOB_SIZE defines the size of the XML documents in the xml_doc_val column. If you want to store XML documents in an uncompressed state, you need to add the XML_DOC_MODE parameter to the DBTUNE table and set it to UNCOMPRESSED. If you want your XML documents to be stored as uncompressed most of the time, add this parameter and value to the DEFAULTS keyword list. If you want to store only some XML documents in an uncompressed format, create a custom configuration keyword and add the XML_DOC_MODE parameter to it and set it to UNCOMPRESSED. In some cases, XML documents can be quite large even in their compressed state (4 or more MB); therefore, it is unlikely you will want to set the XML_DOC_MODE parameter to UNCOMPRESSED in the DEFAULT keyword's parameter list. The XML_DOC_MODE parameter works in concert with the XML_DOC_UNCOMPRESSED_TYPE parameter. If you set XML_DOC_MODE to UNCOMPRESSED in any keyword's parameter list, you must also set the XML_DOC_UNCOMPRESSED_TYPE parameter in the same keyword. The XML_DOC_UNCOMPRESSED_TYPE parameter defines the storage format to be used for the uncompressed XML documents. The XML_IDX_STORAGE specifies storage for the index table of an XML column, sde_xml_idx<n>. The parameters XML_IDX_INDEX_ID, XML_IDX_INDEX_TAG, XML_IDX_INDEX_DOUBLE, and XML_IDX_INDEX_STRING define the storage for different indexes on columns in the sde_xml_idx<n> table. XML_IDX_INDEX_ID specifies storage for the xmlix<n>_id index on the ID column, XML_IDX_INDEX_TAG specifies storage for the xmlix<n>_tg index on the tag_id column, XML_IDX_INDEX_DOUBLE defines storage the xmlix<n>_db index on the double_tag column, and XML_IDX_INDEX_STRING defines the storage for the xmlix<n>_st index on the string_tag column. The XML_IDX_FULLTEXT_UPD_FREQUENCY, XML_IDX_FULLTEXT_UPD_MINIMUM, and XML_IDX_FULLTEXT_UPD_COMMIT parameters define when the full text index is updated. XML_IDX_FULLTEXT_UPD_FREQUENCY specifies the number of days and hours between updates to the full text index. XML_IDX_FULLTEXT_UPD_MINIMUM indicates the minimum number of new or edited documents that can be added to the full text index before it is updated. XML_IDX_FULLTEXT_UPD_COMMIT is set to a number (the commit count) that defines when interim commits occur. For example, if you set the commit count to 1, each transaction is committed. If you set the commit count to 50, a commit is made after 50 transactions. The XML_IDX_FULLTEXT_IDXDIRECTORY parameter indicates the path to directory that contains the text index. XML_IDX_FULLTEXT_WKDIRECTORY specifies the path to the working directory for the text index. The XML_IDX_FULLTEXT_LANGUAGE parameter specifies the language to be used for linguistic analysis when building the text index on the contents of the xml_doc_val column in the sde_xml_doc<n> table and the text_tag column of the sde_xml_idx<n> table. You should set the XML_IDX_FULLTEXT_CCSID parameter, which specifies the Coded Character Set Identifier (CCSID) of the documents, if your text documents are stored in binary format. An additional note about indexingBy default, when XML documents are stored in an XML column in a geodatabase in DB2, the text indexes associated with the column will not be automatically updated to include text from the new documents. Until the text indexes have been updated, any XML documents that have not been indexed can't be found by a search. ArcSDE does not provide any utilities that can be used to manually trigger updates to an XML column's text indexes. For XML columns associated with an ArcIMS Metadata Service, ArcIMS provides configuration options and a command-line utility can be used to update the text indexes. DB2 has a known limitation for the Net Search Extender that affects how documents published to an ArcSDE XML column are indexed. Only a user with DB2ADM privileges can update the text indexes. The user who owns the XML column must either be granted DB2ADM privileges to support text index updates, or a user who does have the appropriate privileges must perform the updates. One solution for this problem is to set the XML_IDX_FULLTEXT_UPD_FREQUENCY parameter in the SDE_dbtune table to set a schedule in the database for updating the text index. If, for instance, you want all documents that were added or updated during the day to be indexed each night, you should not specify a minimum number of documents with the XML_IDX_FULLTEXT_UPD_MINIMUM parameter. For information about how to set the XML_IDX_FULLTEXT_UPD_FREQUENCY and XML_IDX_FULLTEXT_UPD_MINIMUM parameters in the SDE_dbtune table, see the documentation for DB2 Net Search Extender. You should set appropriate values for these parameters before creating an XML column. See the ArcIMS Help for information about the options provided by ArcIMS for updating text indexes. See Configuring a DB2 database to support XML columns for more information on using XML columns in your geodatabase.#COMMENT "This keyword is used by ArcSDE to create log file tables for all users logged in as editor"