The LOGFILE_DEFAULTS keyword in DB2

The LOGFILE_DEFAULTS keyword contains parameters to specify the storage of ArcSDE log file tables. If custom logfile keywords are not created, the settings in the LOGFILE_DEFAULTS keyword are used to specify storage for log file tables for all connecting users.

Tip:

See Custom configuration keywords for information on creating custom keywords.

The following are the default log file parameters as they would appear in the dbtune.sde file. To provide storage information for the parameters that are commented out, uncomment them by removing the pound sign (#) and provide either a table space name (DB2 for Linux, UNIX, and Windows) or database subsystem name (DB2 for z/OS). Uncomment and set these parameters in the dbtune.sde file prior to creating the geodatabase. If you do not alter the values prior to geodatabase creation, you can use the sdedbtune command to set them after the geodatabase is set up. See Altering the contents of the DBTUNE table after it is created for instructions.

DB2 for Linux, UNIX, and Windows

##LOGFILE_DEFAULTS
LD_INDEX_DATA_ID     ""
LD_INDEX_ROWID	     ""
#LD_STORAGE	 "IN <TABLESPACE>"
#LF_STORAGE	 "IN <TABLESPACE>"
#SESSION_STORAGE   "IN <TABLESPACE>"
#SESSION_INDEX   "" 
SESSION_TEMP_TABLE   "0" 
END

DB2 for z/OS

LD_INDEX_DATA_ID     ""
LD_INDEX_ROWID	     ""
#LD_STORAGE	     "IN DATABASE <DATABASE NAME>"
#LF_STORAGE	     "IN DATABASE <DATABASE NAME>"
#SESSION_STORAGE     "IN DATABASE <DATABASE NAME>"
#SESSION_INDEX        "" 
SESSION_TEMP_TABLE   "0" 
END