ArcGIS Help 10.2 - Customizing the dbtune.sde file before creating a geodatabase in DB2 on z/OS

Alter the dbtune.sde file found in the DatabaseSupport\DB2zOS folder in your ArcGIS client installation directory on Windows operating systems to point your database subsystem.

The dbtune.sde file populates the DBTUNE geodatabase system table with keywords, parameters, and values that control the physical storage of tables in the database. For IBM DB2 databases on z/OS, it is important that you edit this file prior to running the Enable Enterprise Geodatabase geoprocessing tool to specify in which database certain tables will be created.

Steps:

Locate and open the dbtune.sde file in the DatabaseSupport\DB2zOS folder in the installation directory of your ArcGIS client.
Uncomment and change these configuration string values under the DATA_DICTIONARY keyword to indicate in which database you want specific geodatabase system tables created. The following are suggested settings. The database named SDEDBR00 is the database that will store the geodatabase repository tables.
```
B_STORAGE "IN DATABASE SDEDBR00"
MVTABLES_MODIFIED_TABLE "IN DATABASE SDEDBR00"
STATES_TABLE "IN DATABASE SDEDBR00"
STATE_LINEAGES_TABLE "IN DATABASE SDEDBR00"
VERSIONS_TABLE "IN DATABASE SDEDBR00"
XML_INDEX_TAGS_TABLE "IN DATABASE SDEDBR00"
```
Make sure the BLOB_OPTION and CLOB_OPTION parameters under the DEFAULTS keyword are set to be empty strings.
Uncomment and change these configuration string values under the DEFAULTS keyword to indicate in which database you want specific objects related to user-defined data to be created. The following are suggested settings. The database named SDEDBU00 is the database that will store user-defined data within the database subsystem.
```
 AUX_STORAGE "IN DATABASE SDEDBU00"
 A_STORAGE "IN DATABASE SDEDBU00"
 BLK_STORAGE "IN DATABASE SDEDBU00"
 BND_STORAGE "IN DATABASE SDEDBU00"
 B_STORAGE "IN DATABASE SDEDBU00"
 D_STORAGE "IN DATABASE SDEDBU00"
 RAS_STORAGE "IN DATABASE SDEDBU00"
```
Uncomment and change these configuration string values under the LOGFILE_DEFAULTS keyword to indicate in which database you want log file tables to be created.
```
 LD_STORAGE "IN DATABASE SDEDBU00"
 LF_STORAGE "IN DATABASE SDEDBU00"
 SESSION_STORAGE "IN DATABASE SDEDBU00"
```
Save and close the dbtune.sde file.

Customizing the dbtune.sde file before creating a geodatabase in DB2 on z/OS

Related Topics