Configure Geodatabase Log File Tables (Data Management)


Alters the type of log file tables used by an enterprise geodatabase to maintain lists of records cached by ArcGIS.


  • This tool can only be run on enterprise geodatabases.

  • Only the geodatabase administrator can run the Configure Geodatabase Log File Tables tool.

  • This tool can be used with geodatabases in IBM Db2.


ConfigureGeodatabaseLogFileTables(input_database, log_file_type, {log_file_pool_size}, {use_tempdb})
ParameterExplanationData Type

Provide a database connection (.sde file) to the enterprise geodatabase for which you want to change the log file table configuration. The connection must be made as the geodatabase administrator.


Specify the type of log file tables you want the geodatabase to use.

  • SESSION_LOG_FILEUse session-based log file tables for selection sets. Session-based log file tables are dedicated to a single session and may contain multiple selection sets.
  • SHARED_LOG_FILEUse shared log file tables for selection sets. Shared log file tables are shared by all sessions that connect as the same user.

If you want the geodatabase to use a pool of session-based log file tables owned by the geodatabase administrator, specify the number of tables you want included in the pool.


This parameter is no longer applicable, starting with the ArcGIS 10.5 and ArcGIS Pro 1.4 releases.


Derived Output

NameExplanationData Type

The updated input workspace.


Code sample

ConfigureGeodatabaseLogFileTables example 1 (Python window)

This script can be run from a Python window to change the log file table configuration to use session-based log file tables created in the geodatabase administrator's schema.

In this example, the log file pool is 100 tables.

import arcpy
input_database = "c:\\temp\\ProductionGDB.sde"
log_file_type = "SESSION_LOG_FILE"
log_file_pool_size = 100

    input_database, log_file_type, log_file_pool_size)
ConfigureGeodatabaseLogFileTables example 2 (stand-alone script)

Geodatabases in Db2 use shared log files by default. If you changed from the default setting and want to change back, you can run the following script:

# Description: configure geodatabase log file tables

# Set the necessary product code
import arceditor
# Import arcpy module
import arcpy

# Local variables:
input_database = "c:\\temp\\ProductionGDB.sde"
log_file_type = "SHARED_LOG_FILE"
log_file_pool_size = 0

# Process: Update log file setting
    input_database, log_file_type, log_file_pool_size)


Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes

Related topics