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 if exported to a text file from the DBTUNE table using the sdedbtune command. The sdedbtune command is installed with the ArcSDE application server installation.

To provide storage information for those parameters that don't have values, provide either a table space name (DB2 for Linux, UNIX, and Windows) or database subsystem name (DB2 for z/OS). See your DB2 documentation for the correct syntax when creating a table or index.

You can alter the values in the exported text file then use the sdedbtune command to import the altered values, or you can use the alter operation with the sdedbtune command to change the value of one parameter at a time. See the ArcSDE Administration Command Reference installed with the ArcSDE application server and Altering the contents of the DBTUNE table for instructions.

DB2 for Linux, UNIX, and Windows

##LOGFILE_DEFAULTS
LD_INDEX_DATA_ID     ""
LD_INDEX_ROWID	     ""
LD_STORAGE	 ""
LF_STORAGE	 ""
SESSION_STORAGE   ""
SESSION_INDEX   "" 
SESSION_TEMP_TABLE   "0" 
END

DB2 for z/OS

LD_INDEX_DATA_ID     ""
LD_INDEX_ROWID	     ""
LD_STORAGE	     ""
LF_STORAGE	     ""	
SESSION_STORAGE     ""
SESSION_INDEX        "" 
SESSION_TEMP_TABLE   "0" 
END