Drop the column from the replication table.
从复制表删除列。
To attach a fragment to a replication table.
为了将一个分段附加到一个复制表上。
Attaching a fragment to a replication table.
将一个分段附加到一个复制表上。
There are two ways to alter a replication table.
有两种方法可以用来修改复制表。
Using the CDR command line interface, set the replication table to alter mode.
使用CDR命令行界面,将复制表设为alter模式。
Directly issue the alter statement against the replication table. For example.
直接对复制表发出alter语句。
Using the CDR command line interface, unset the replication table from alter mode.
使用CDR命令行界面,关闭复制表的alter模式。
Before attempting an alter operation against a replication table, consider the following.
在尝试对一个复制表执行alter操作时,考虑以下方面。
Note: All other types of alter operations can be executed directly against a replication table using a SQL alter statement.
注意:通过使用SQLalter语句,可以直接对复制表执行所有其他类型的alter操作。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
确信服务器有足够的锁资源数,用以修改相关的删除表和复制表。
Otherwise, the deleted row is moved from replication table to the associated delete table, which might cause problems for the subsequent alter operation on the replicated table.
否则,被删除的行将被从复制表转移到相关的删除表,这样会给随后对复制表的alter操作带来问题。
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.
然后等待下一个复制周期,并检查目标表。
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.
如果不可能设置复制,那么仍然可以使用昵称作为源来填充相关联的空间表,并在组合视图中联结这两者。
Before putting replication data into the send queue, the source server first converts the data from the local table dictionary format to the master replicate dictionary format.
在将复制数据放入到发送队列之前,源服务器首先将数据从本地表字典格式转换为主复制字典格式。
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程序可以将日志中所记录的更新写到更改表。
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.
外部表数据文件不能进行任何形式的复制。
应用推荐