Skip To Content

Configure Geodatabase Log File Tables

Summary

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

Usage

  • 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.

Syntax

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

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.

Workspace
log_file_type

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.
String
log_file_pool_size
(Optional)

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.

Long
use_tempdb
(Optional)

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

Boolean

Derived Output

NameExplanationData Type
out_workspace

The updated input workspace.

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

arcpy.ConfigureGeodatabaseLogFileTables_management(
    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
arcpy.ConfigureGeodatabaseLogFileTables_management(
    input_database, log_file_type, log_file_pool_size)

Environments

Licensing information

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

Related topics