Table attributes are verified during the realization of the template to ensure that proper replication can be performed on that database.
表属性是在实现模板期间验证的,以确保在该数据库上能执行正确的复制。
Then wait for the next replication cycle, and check the target table.
然后等待下一个复制周期,并检查目标表。
It is a read-only target table that includes only those columns defined in the subscription-set member (which is the definition of the replication set).
它是只读的目标表,只包括定义在订阅集成员(它是复制集的定义)中的列。
While the CCD target table does not automate the replication of data to unsupported target databases, it does expose the data for consumption by a user application.
虽然CCD目标表不能自动将数据复制到不受支持的目标数据库中,但是它通过用户应用程序暴露数据。
With SQL replication, you create a configuration that specifies each table in the database that you want to replicate.
通过SQL复制,您可以创建一个配置,其中指定了您希望复制的每一个数据库表。
Also, before setting up replication in DB2, you will want to ensure that every database table has a primary key or unique index.
此外,在DB 2中创建复制之前,您会希望保证每一个数据库表都具有一个主键或惟一索引。
You can choose to set up replication automatically when you create a new table through a grid.
当您通过一个网格新建一个表时,可以选择自动设置复制。
However, DB2 replication requires a key or index to uniquely identify rows in a table.
然而,DB 2复制要求使用一个主键或惟一索引来区分一个表中的记录。
If replication is not possible, you can still populate an associated spatial table using the nickname as the source, and join the two in a combined view.
如果不可能设置复制,那么仍然可以使用昵称作为源来填充相关联的空间表,并在组合视图中联结这两者。
Note: All other types of alter operations can be executed directly against a replication table using a SQL alter statement.
注意:通过使用SQLalter语句,可以直接对复制表执行所有其他类型的alter操作。
By default, templates set up replication for full rows of tables (all the columns in the table), because they are designed to facilitate setting up large-scale replication environments.
默认情况下,模板为表的整行(表中所有的列)设置复制,因为模板本身就是设计用来方便设置大规模复制环境的。
Whenever replication detects a conflict, the SQL for the conflict is logged in a table.
只要复制检测到冲突,则冲突的SQL就会记录到一个表中。
The described mechanism ensures a continuous replication of data from the IWH.EDITION to the WIP_FULL_ARCHIVE table, and provides a complete history of the entire life of each edition.
但其描述机制确保了将数据连续地从IWH.EDITION复制到 WIP_FULL_ARCHIVE表,并且提供了每个版本整个生存期的全部历史记录。
After replication is enabled, you can verify the target table values.
在启用复制之后,可以检查目标表值。
Similarly, before applying replication data, a target server first converts replication data that is in mastered dictionary format to the local table dictionary format.
类似地,在应用复制数据之前,目标服务器首先将主字典格式的复制数据转换为本地表字典格式。
To help with replication ER requires that the table have a primary key defined.
要实现更好的复制,ER要求表定义一个主键。
Table 1 compares supported source and target platforms for SQL replication and Q replication.
表1比较了SQL复制和Q 复制的所支持的源平台和目标平台。
In addition, if you are using data replication, the CAPTURE program can write the updates recorded in the logs to the change table.
此外,如果您使用数据复制,CAPTURE程序可以将日志中所记录的更新写到更改表。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
确信服务器有足够的锁资源数,用以修改相关的删除表和复制表。
Drop the column from the replication table.
从复制表删除列。
You can now rename a replicated column, table, or database while Enterprise Replication is active.
当EnterpriseReplication活动时,可以重命名复制列、表或数据库。
External table data files are excluded from all forms of replication.
外部表数据文件不能进行任何形式的复制。
When altering the delete table, Enterprise Replication performs these four steps.
当修改删除表时,EnterpriseReplication执行以下四步。
Recommendation: Use the "no load" option for nicknames with referential integrity constraints and load the target table outside of the replication administration tools.
推荐:为带有参照完整性约束的别名使用“noload”选项,并在复制管理工具外部装入目标表。
There are two ways to alter a replication table.
有两种方法可以用来修改复制表。
Utilities: The Replication Alert Monitor and table differencing and reconciliation utilities (asntdiff and asntrep) are supported for non-DB2 targets.
实用程序:针对非 DB2目标支持ReplicationAlertMonitor 以及表求差 ( differencing )和调和 (reconciliation ) 实用程序(asntdiff 和asntrep)。
To attach a fragment to a replication table.
为了将一个分段附加到一个复制表上。
Before attempting an alter operation against a replication table, consider the following.
在尝试对一个复制表执行alter操作时,考虑以下方面。
Attaching a fragment to a replication table.
将一个分段附加到一个复制表上。
Note: Enterprise Replication does not allow dropping a column from a replicated table when one or more replicate definitions refer to the column being dropped.
注意:当一个或多个复制定义引用被删除的列时,EnterpriseReplication不允许从一个复制表中删除一列。
应用推荐