Configure Geodatabase Log File Tables (Data Management)

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})

Parameter	Explanation	Data 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_FILE —Use 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_FILE —Use 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 the ArcGIS 10.5 and ArcGIS Pro 1.4 releases.	Boolean

Derived Output

Name	Explanation	Data 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

Current Workspace

Licensing information

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