Summary
The Configure Geodatabase Log File Tables tool allows you to alter 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 against enterprise geodatabases.
Only the geodatabase administrator can run the Configure Geodatabase Log File Tables tool.
Syntax
ConfigureGeodatabaseLogFileTables_management (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 log file table configuration. The connection must be made as the geodatabase administrator. | Workspace |
log_file_type [log_file_type,...] | The type of log file tables you want the geodatabase to use.
| 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) |
| Boolean |
Code sample
ConfigureLogFileTables 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)
ConfigureLogFileTables example 2 (stand-alone Python script)
Geodatabases in SQL Server use session-based log file tables created in the TempDB database by default. If you changed from the default setting, you can use this script to change back to using session logfiles in TempDB.
# 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 = "SESSION_LOG_FILE"
log_file_pool_size = 0
use_tempdb = TRUE
# Process: Diagnose Version Metadata
arcpy.ConfigureGeodatabaseLogFileTables_management(input_database,log_file_type,log_file_pool_size,use_tempdb)
ConfigureLogFileTables example 2 (stand-alone Python script)
Geodatabases in IBM DB2, IBM Informix, Oracle, and PostgreSQL use shared log files by default. If you changed from the default setting and want to change back, you can run the following script. You could also run this script to change to a geodatabase in SQL Server to use shared log file tables, though this is not the recommended setting for SQL Server.
# 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: Diagnose Version Metadata
arcpy.ConfigureGeodatabaseLogFileTables_management(input_database,log_file_type,log_file_pool_size)
Environments
Licensing information
- ArcGIS Desktop Basic: No
- ArcGIS Desktop Standard: Yes
- ArcGIS Desktop Advanced: Yes