Customizing ArcSDE files before creating a geodatabase in DB2 on z/OS

After the ArcSDE component is installed but before the geodatabase is created, you must alter the dbtune.sde and dbinit.sde files. Optionally, you can also alter the giomgr.defs file.

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 sdesetup command to specify in which database certain tables will be created.

The dbinit.sde file defines connection information for the client.

The giomgr.defs file populates the SERVER_CONFIG table at the time of geodatabase creation. There is a commented parameter in this file, TEMP, that is used to specify the full path name to a temporary disk space directory. If left commented out, the default location for this is the temporary folder of the user logged in to the Windows machine at the time the geodatabase is created. If that location is acceptable, you do not have to uncomment and change this parameter value. If not, alter the giomgr.defs file, uncommenting the TEMP parameter and setting it to the full path name you want to use, then save the giomgr.defs file. If you do not alter this value before setting up the ArcSDE geodatabase repository, you can alter it after the geodatabase is created using the sdeconfig alter operation. See the ArcSDE administration command reference installed with the ArcSDE component of ArcGIS Server Enterprise for information on this command.

Steps:
  1. Locate the dbinit.sde file in the %SDEHOME%\etc directory (ArcSDE\db2zosexe\etc) on your Windows client computer. Add the following for the first line of the dbinit.sde file, substituting the name of your DB2 subsystem:

    set SDE_DATABASE=<DB2_subsystem_name>
    

  2. Locate and open the dbtune.sde file in the ArcSDE\db2zosexe\etc directory on your client computer.
  3. Uncomment and change these configuration string values under the DATA_DICTIONARY keyword to indicate in which database you want specific ArcSDE geodatabase system tables created. The following are suggested settings. The database named SDEDBR00 is the database that will store the ArcSDE 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"

  4. Make sure the BLOB_OPTION and CLOB_OPTION parameters under the DEFAULTS keyword are set to be empty strings.
  5. 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"
    

  6. 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"
    

  7. Optionally, open the giomgr.defs file and uncomment the TEMP parameter.
  8. Type a full path name to a temporary disk space directory on the client computer.

Related Topics


11/18/2013