ArcGIS Server Banner

Log file tables in a geodatabase in Informix

Log file tables in a geodatabase in Informix
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note:This topic was updated for 9.3.1.

A geodatabase uses log file tables to store lists of table rows.

See Log file configuration options for details on log file tables.

Log file tables in ArcCatalog and ArcMap

You will not see log file tables in ArcCatalog or ArcMap. However, you will cause log file tables to be created and populated when you make a selection in ArcMap that returns a set of more than 100 features.

Log file tables in an Informix DBMS

When you first install ArcSDE and create your geodatabase in Informix, the default log file configuration uses shared ArcSDE log files. Shared log files are shared by all sessions that connect as the same user. So if you have multiple users connecting with the same user account, all those sessions will be inserting and deleting records from the same log file data table. The log files are created the first time a selection set of 100 or more records is created using ArcGIS.

Which log file tables you see in your geodatabase depends on which log file configuration is used. If you use the default shared log files, two tables per DBMS user ID are created and stored in the schema of that DBMS user—sde_logfiles and sde_logfile_data. Once created, these tables remain in the geodatabase; however, all log file entries are deleted when the connecting application deletes all its log files.

ArcSDE shared log file tables in Informix

If you alter your log file configuration to use session-based log files, you will see the sde_logfiles, sde_logfile_data, and session<sde_id> tables in the geodatabase. These tables will be created in the schema of the user whose session caused the tables to be created. Although created, the sde_logfile_data table is not populated. The sde_logfiles and sde_logfile_data tables remain in the geodatabase, and the sde_logfiles table is truncated when the connecting application disconnects. The session<sde_id> table is truncated when the connecting application no longer needs the log file records (for ArcMap, this means there is no longer a selection set), and the table is dropped when the session disconnects.

ArcSDE session log file tables in Informix

If you use stand-alone log files, for each selection set above the selection threshold made by a session, a new sde_logdata<sde_id>_<#> table is created for each layer. The sde_logfiles and sde_logfile_data tables are also created per session, but the sde_logfile_data table isn't populated. Both of these tables are created in the schema of the user who caused them to be created.

ArcSDE stand-alone log file tables in Informix

The sde_logdata<sde_id>_<#> tables are truncated when the connecting session no longer needs the log files, and the tables are dropped when the session disconnects. The sde_logfiles table is truncated when the connecting application disconnects.

The sde_logfile_pool table is created and stored in the schema of the ArcSDE administrator when the geodatabase is created. If you use a pool of stand-alone or session-based log files owned by the ArcSDE administrator, this table will be used, plus sde_logpool_<table_Id> tables will be created in the geodatabase. The number of sde_logpool_<table_id> tables created depends on the number you specify for the LOGFILEPOOLSIZE in the server_config table. In the example below, LOGFILEPOOLSIZE is set to 10; therefore, sde_logpool tables 1 through 10 are created.

All the tables created for pools of log files are created in the ArcSDE administrator's schema.

A pool of ArcSDE log file tables in Informix

NOTE: If MAXSTANDALONELOGS is set to a number greater than 0, and a user that has CREATE TABLE permissions creates a selection set that exceeds the threshold for log files to be created, a stand-alone log file table will be created in that user's schema.

The following are the definitions for the tables used for ArcSDE log files. Informix prefaces the table names with the name of the user in whose schema the table is stored.

sde_sde_logfile_pool

The sde_sde_logfile_pool table contains the list of business table records that are part of each log file. This table is created when the geodatabase is created.


Field Name Field Type Description
table_id Int Identifies the log file pool table.

NOT NULL.
sde_id Int Identifies which sde connection is currently using the given log file pool table.

The sde_id is a reference to the sde_id column of the process_information table. If sde_id is NULL, it means this log file pool table is not currently in use.

sde_sde_logpool_<table_id>

The sde_sde_logpool_<table_id> table can be checked out by users and stores either stand-alone or session-based log files. The <table_id> is the sequence number. These tables are only present if you are using pools of log files owned by the ArcSDE administrator.


Field name Field type Description
logfile_data_id Int Identifies the log file to which the row ID belongs.

New logfile_data_ids are assigned whenever a log file is truncated to avoid expensive delete operations.

The logfile_data_id is a reference to the log file metadata in sde_logfiles.

NOT NULL.
sde_row_id Int The row ID or shape ID of the business table row being logged; log files can log either row IDs or shape IDs.

NOT NULL.

<user_name>_sde_logdata<sde_id>_<#>

The <user_name>_sde_logdata<sde_id>_<#> table contains the list of business table records that are part of a stand-alone log file. <sde_id> denotes the session ID and <#> denotes the stand-alone log file sequence.


Field name Field type Description
sde_row_id Int The row ID or shape ID of the business table row being logged; log files can log either row IDs or shape IDs.

<user_name>_sde_logfile_data

The <user_name>_sde_logfile_data table contains the list of business table records that are part of each log file.


Field name Field type Description
logfile_data_id Int Identifies the log file to which the row ID belongs.

New logfile_data_ids are assigned whenever a log file is truncated to avoid expensive delete operations.

Deleted values in sde_logfile_data are also marked deleted by assigning a different logfile_data_id value.

The logfile_data_id is a reference to the log file metadata in sde_logfiles.
sde_row_id Int The row ID or shape ID of the business table row being logged; log files can log either row IDs or shape IDs.

<user_name>_sde_logfiles

The <user_name>_sde_logfiles table contains the log file metadata.


Field name Field type Description
logfile_name Varchar(255) A unique user-defined (or application-defined) name for the log file.

NOT NULL.
logifle_id Int Uniquely identifies the log file.

Primary key.

NOT NULL.
logfile_data_id Int Identifies the log file to which the row ID belongs.

New logfile_data_ids are assigned whenever a log file is truncated to avoid expensive delete operations.

NOT NULL.
registration_id Int The registration ID of the business table for which IDs are being logged in this log file.

NOT NULL.
flags Int A bitmask of values that indicate properties of the log file.
session_tag Int A unique identifier for a connection's session, which allows a given ArcSDE connection to purge all temporary log files belonging to its session, for example.
logfile_data_db Varchar(32) The name of the database in which the table that's holding the IDs for this log file is stored.

logfile_data_owner Varchar(32) The name of the owner of the table that's holding the IDs for this log file.

logfile_data_table Varchar(32) The name of the table that is holding the IDs for this log file.

This could be the traditional sde_logfile_data, or a log pool table, a session table, or a stand-alone sde_logdata<SDE_ID>_<#> table.
column_name Varchar(32) The name of the column in the business table that is being logged.

Generally, this is the row ID or shape ID, but you can also specify an arbitrary integer column to be logged.

<user_name>_sde_session<sde_id>

The <user_name>_sde_session<sde_id> table is created when you are using session-based log files. This table is used to track log file records when a connected session creates a selection set that exceeds the application threshold (100 records in ArcMap). The <user_name>_sde_session<sde_id> table is dropped when the session disconnects.


Field name Field type Description
logfile_data_id Int Identifies the log file to which the row ID belongs.

New logfile_data_ids are assigned whenever a log file is truncated to avoid expensive delete operations.

The logfile_data_id is a reference to the log file metadata in sde_logfiles.

NOT NULL.
sde_row_id Int The row ID or shape ID of the business table row being logged; log files can log either row IDs or shape IDs.

NOT NULL.

Log file tables in an XML document

Log file tables are not stored in XML documents. This means if you export your geodatabase schema to an XML workspace document, after you import the schema, log file tables will get re-created the next time users create a selection set that exceeds the log file threshold.