ArcGIS Desktop

  • Documentation
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Configure Geodatabase Log File Tables

  • Summary
  • Usage
  • Syntax
  • Code sample
  • Environments
  • Licensing information

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.

  • This tool can be used with geodatabases in IBM DB2, Informix, or Oracle.

Syntax

ConfigureGeodatabaseLogFileTables_management (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 log file table configuration. The connection must be made as the geodatabase administrator.

Workspace
log_file_type

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

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 Python script)

Geodatabases in IBM DB2, IBM Informix, and Oracle 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: Diagnose Version Metadata
arcpy.ConfigureGeodatabaseLogFileTables_management(input_database, log_file_type, log_file_pool_size)

Environments

  • Current Workspace

Licensing information

  • ArcGIS Desktop Basic: No
  • ArcGIS Desktop Standard: Yes
  • ArcGIS Desktop Advanced: Yes

Related topics

  • Alter log file table settings
  • An overview of the Geodatabase Administration toolset

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2017 Esri. | Privacy | Legal