ArcGIS Server Banner

DB2 DBTUNE configuration parameters

DB2 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 a DB2 database, parameter name–configuration string pairs are used by ArcSDE to do the following:

There are many parameters in the dbtune.sde configuration file for DB2 that should be uncommented and their values altered prior to creating the ArcSDE geodatabase repository. If you do not uncomment and provide storage information for these parameters prior to creating the geodatabase, you will receive warning messages for each parameter in the sde_setup.log file. If you do not uncomment and provide storage information for the DATA_DICTIONARY parameters in a DB2 for Linux, UNIX, and Windows database, tables will be created in the default table space. If you do not uncomment and provide storage information for the parameters in a DB2 for z/OS database, the geodatabase will not be functional because tables will be created in the wrong database in the subsystem.

The parameters, grouped by keyword, include the following:


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

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


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 0

1 = 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.

Functional descriptions of parameters

See Also

  • DBTUNE configuration parameter name-configuration string pairs
  • DBTUNE configuration keywords
  • The dbtune file and the DBTUNE table