Log file tables in a geodatabase in Informix |
|
Release 9.3 |
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_poolThe 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. |
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. |
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. |
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. |
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. |
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. |