Configure Geodatabase Log File Tables (Data Management)

Summary

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

Usage

  • This tool only functions with enterprise geodatabase version 10.9.0.2.7 or earlier in IBM Db2 or enterprise geodatabase version 10.7.0.2.3 or earlier in Oracle.

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

Parameters

LabelExplanationData Type
Input Database Connection

A database connection (.sde file) to the enterprise geodatabase where the log file table configuration will be changed. The connection must be made as the geodatabase administrator.

Workspace
Log File Type

Specifies the type of log file tables the geodatabase will use.

  • Session log fileSession-based log file tables for selection sets will be used. Session-based log file tables are dedicated to a single session and may contain multiple selection sets.
  • Shared log fileShared log file tables for selection sets will be used. Shared log file tables are shared by all sessions that connect as the same user.
String
Number of pooled session-based log file tables to be owned by the administrator
(Optional)

The number of tables included in the pool that the geodatabase will use if a pool of session-based log file tables owned by the geodatabase administrator is used.

Long
Create session-based log file tables in the TempDB database (Microsoft SQL Server only)
(Optional)

This parameter is no longer applicable in any supported ArcGIS release.

Boolean

Derived Output

LabelExplanationData Type
Updated Input Workspace

The updated input workspace.

Workspace

arcpy.management.ConfigureGeodatabaseLogFileTables(input_database, log_file_type, {log_file_pool_size}, {use_tempdb})
NameExplanationData Type
input_database

A database connection (.sde file) to the enterprise geodatabase where the log file table configuration will be changed. The connection must be made as the geodatabase administrator.

Workspace
log_file_type

Specifies the type of log file tables the geodatabase will use.

  • SESSION_LOG_FILESession-based log file tables for selection sets will be used. Session-based log file tables are dedicated to a single session and may contain multiple selection sets.
  • SHARED_LOG_FILEShared log file tables for selection sets will be used. Shared log file tables are shared by all sessions that connect as the same user.
String
log_file_pool_size
(Optional)

The number of tables included in the pool that the geodatabase will use if a pool of session-based log file tables owned by the geodatabase administrator is used.

Long
use_tempdb
(Optional)

This parameter is no longer applicable in any supported ArcGIS release.

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 for older geodatabases 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)

Environments

Licensing information

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

Related topics