Alter log file table settings

Available with Standard or Advanced license.

Enterprise geodatabases use log file tables to maintain lists of selected records. Records are written to log file tables for later use by the application in the following situations:

• A client creates a selection set of a specific size (100 records in ArcMap; 1,000 records in ArcGIS Pro; 1,000 records if ObjectIDs are requested from a feature service).
• You reconcile or post to a versioned geodatabase.
• A client application checks out data for disconnected editing.

Enterprise geodatabases in Microsoft SQL Server use session log files created in the temporary database (tempdb) of the SQL Server instance by default. For a description of the default log file table configuration and other log file table options in SQL Server, see Log file table options for geodatabases in SQL Server.

As the geodatabase administrator, you can connect to the geodatabase in ArcGIS for Desktop and run the Configure Geodatabase Log File Tables tool to change log file table settings, or run a Python script that does the same thing.

Run the Configure Geodatabase Log File Tables tool

If you need to change the log file table configuration for your enterprise geodatabase, you can run the Configure Geodatabase Log File Tables tool. This tool can be found in the Geodatabase Administration toolset of the Data Management toolbox.

1. Open the Configure Geodatabase Log File Tables tool.

   You can use the Search window to find the tool or browse to it in the Geodatabase Administration toolset of the Data Management toolbox.

2. Specify the database connection you created in the previous section.
3. Choose the log file table options you want to set for your geodatabase.
4. Click OK to run the tool.

Use ArcPy functions

You can create a connection to the geodatabase using the CreateDatabaseConnection_management function and run the ConfigureGeodatabaseLogFileTables_management function directly from a Python window, or create and run a script that contains them both.

To run directly from a Python window, follow these steps:

1. Open a Python window.
2. Run CreateDatabaseConnection_management, connecting as the geodatabase administrator. Save the user name and password with the file.

   import arcpy
   arcpy.CreateDatabaseConnection_management("c:\arcgis\connections", "mygdb.sde", "SQL_SERVER", "citadel","DATABASE_AUTH", "sde", "t7gw0dw", "SAVE_USERNAME", "geodata")
   

3. Run ConfigureGeodatabaseLogFileTables_management to change what type of log file tables are used to cache selection sets.

   In this example, the geodatabase will be using session-based log file tables owned by the geodatabase administrator. There will be 50 log file tables owned by the geodatabase administrator.

   import arcpy
   input_database = "c:\\connections\\mygdb.sde"
   log_file_type = "SESSION_LOG_FILE"
   log_file_pool_size = 50
   arcpy.ConfigureGeodatabaseLogFileTables_management(input_database,log_file_type,log_file_pool_size)