|
Log file keywords |
|
| Release 9.3 |    |
NOTE: Applies to geodatabases created with an ArcGIS Server Enterprise license only
Log file configuration keywords in the DBTUNE table are used to control the storage of ArcSDE log file tables. You can create log file keywords for particular users so that whenever the user creates a selection set that leads to the creation of ArcSDE log file tables, the settings for that user's log file keyword are used. You create user-specific log file keywords in the format LOGFILE_<user_name>. For example, if you want to create a log file configuration keyword for user Moe, use the keyword LOGFILE_Moe. If the connecting user name is not Moe and it does not have its own user-specific log file keyword, the LOGFILE_DEFAULTS keyword is used. Creating a log file configuration keyword for each user allows you to store the different users' log files on separate devices. Most ArcSDE geodatabases function well using the LOGFILE_DEFAULTS storage parameters supplied with the installed dbtune.sde file. However, for applications that make heavy use of log files, such as ArcGIS Desktop, it may help performance to spread the log files across the file system.NOTE: If you create user-specific log file keywords, there is no need to include a UI_TEXT parameter. The user does not specify his or her log file keyword when the data is created; rather, the system searches for the keyword that matches the connected user name when log file tables need to be created.
Parameters of log file keywordsFor the creation of shared log file tables, the LD_STORAGE and LF_STORAGE parameters control the storage of the SDE_LOGFILE_DATA and SDE_LOGFILES tables. The LF_INDEXES parameter defines the storage of the indexes of the SDE_LOGFILES table, while the LD_INDEX_DATA_ID and LD_INDEX_ROWID parameters define the storage of the SDE_LOGFILE_DATA table. If you have configured the server to use session-based or stand-alone log files in addition to shared log files, ArcSDE uses a different set of storage parameters when it creates the session-based and stand-alone log file tables. The SESSION_STORAGE parameter defines the storage of the session-based and stand-alone log file tables. The SESSION_INDEX parameter defines the storage of the session-based and stand-alone log file table indexes. Consult the following topics to see the default parameters for the LOGFILE_DEFAULTS keyword for each database management system. LOGFILE DEFAULTS for DB2 LOGFILE DEFAULTS for Informix LOGFILE DEFAULTS for Oracle LOGFILE DEFAULTS for PostgreSQL LOGFILE DEFAULTS for SQL Server