ca_replication_conf

Formerly NCEPCONF. Hold the configuration on tables such as which table needs replication, how much of it needs replication and in what direction.

Column Name Column Datatype Column Null Option Column Comment
replication_conf_uuid byte(16) not null UUID of an replication configuration definition
table_name nvarchar(255) with null Name of a MDB table
job_uuid byte(16) with null This field contains the uuid for a DSM Replication Job. Normally there will be only one replication job that handle all the replication between the enterprise and the domains.
direction integer with null Replication direction

1=from mother to this domain, 2=from this domain to mother

domain_collection integer with null Domain collection
job_domain_id integer with null Will be used in this version for the Engine because it is still running on AM Job structures
job_id integer with null Will be used in this version for the Engine because it is still running on AM Job structures
creation_user nvarchar(64) with null Database user or component/process that created the record
creation_date integer with null Creation date/Time
last_update_user nvarchar(64) with null Database user or component/process that updated the record
last_update_date integer with null Last Change Date/Time
version_number integer with null Last version number
enterprise_uuid byte(16) not null UUID of the enterprise domain
domain_uuid byte(16) not null UUID of the domain
replication_order integer not null Order of the replication ( sequence)
primary_keys nvarchar(255) with null List of primary keys, Additional where clause that can separate data from within a table, if only some needs replicated
replication_column_filter nvarchar(255) with null Filtering of columns
where_clause nvarchar(255) with null Additional where clause that can separate data from within a table, if only some needs replication.
unlink_where_clause nvarchar(255) with null Unlink information

Product Name: Unicenter Desktop and Server Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
replication_conf_uuid ca_replication_status replication_conf_uuid
replication_conf_uuid ca_replication_status replication_conf_uuid


Copyright © 2006 CA. All rights reserved.