The LOGFILE_DEFAULTS keyword in Informix

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 from the dbtune table using the sdedbtune command. You can alter the setting for these parameters using the sdedbtune command, which is installed with the ArcSDE application server. See Altering the contents of the DBTUNE table and the ArcSDE Administration Command Reference installed with the ArcSDE application server for instructions.

##LOGFILE_DEFAULTS
LF_STORAGE                    "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
LF_INDEXES                    "FILLFACTOR 90"
LD_STORAGE                    "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
LD_INDEX_DATA_ID              "FILLFACTOR 90"
LD_INDEX_ROWID                "FILLFACTOR 90"
SESSION_STORAGE               "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
SESSION_INDEX                 "FILLFACTOR 90"
SESSION_TEMP_TABLE            "0"
END