Log file tables in a geodatabase in SQL Server |
|
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 that are used for ArcSDE log files. SDE_logdata<SDE_ID>_<#>The 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. These tables are stored in the user's schema.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. 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 |
---|---|---|
table_id | int | Identifies the log file pool table. |
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. Nulls allowed. |
Field name | Field type | Description |
---|---|---|
logfile_name | nvarchar(255) | A unique user-defined (or application-defined) name for the log file. |
logifle_id | int | Uniquely identifies the log file. Primary key. |
logfile_data_id | int | Identifies the log file to which the row ID belongs. |
registration_id | int | The registration ID of the business table for which IDs are being logged in this log file. |
flags | int | A bit mask 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 | nvarchar(32) | The name of the database in which the table that's holding the IDs for this log file is stored. Nulls allowed. |
logfile_data_owner | nvarchar(32) | The name of the owner of the table that's holding the IDs for this log file. Nulls allowed. |
logfile_data_table | nvarchar(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. Nulls allowed. |
column_name | nvarchar(32) | The name of the column in the business table that is being logged. Generally, this is the row ID or shape iID, but you can also specify an arbitrary integer column to be logged. Nulls allowed. |
Field name | Field type | Description |
---|---|---|
logfile_data_id | int | Identifies the log file to which the row ID belongs. 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_data_id | int | Identifies the log file to which the row ID belongs. The logfile_data_id is a reference to the log file metadata in SDE_logfiles. Primary key. |
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. Primary key. |