下面的命令加载数据到目标数据库中。
The following command loads the data into the target database.
每个联邦目标数据库都需要一组控制表。
One set of control tables is needed for each federated target database.
访问目标数据库不需要执行数据整合过程。
Accessing the target database does not require the execution of a data-consolidation process.
把源和目标数据库的数据存储都分配给用户。
Assign both the datastores for your source and target databases to users.
为目标数据库添加数据存储的步骤是相同的。
Use the same steps as a guide for adding a datastore for your target database.
方法1要求目标数据库被配置为联邦数据库。
Approach 1 requires that the target database is configured as federated database.
JPA实体创建向导,它使用目标数据库计划。
JPA entity-creation wizard, which USES a target database schema.
检查目标数据库DB 2UD b中的数据。
DDL还可以回滚,但这取决于目标数据库的功能。
Based on the target database capabilities, the DDL can also be rolled back.
因此,这种方法的性能特性仅由目标数据库服务器决定。
Therefore, the performance characteristics of this approach are determined only by the target database server.
也就是说,为了成功地执行复制,需要访问目标数据库。
This means in order to perform the replication successfully, the target database needs to be accessed.
容器将用能被目标数据库接受的最低级锁定来装载数据。
The container will load the data with the weakest lock available for the targeted database.
用户名必须与目标数据库中创建表时所在的模式相匹配。
The user name must match the schema name where tables are created in target database.
使用XML配置文件为每个目标数据库定义不同的SQL。
Use XML configuration files to define different SQL for each target database.
对于本文中的示例,目标数据库服务器是DB 2UDB。
For the example in this article, the target database server is DB2 UDB.
本节概述在源数据库和目标数据库之间设置复制订阅的步骤。
This section gives an overview of the steps to set up a replication subscription between your source database and a target database.
如果目标数据库是DB2,将已配置的捕获文件绑定到db2包。
Bind the configured capture file into DB2 packages, if the target database is DB2.
但是,首先应该在目标数据库mysample中创建存储过程。
But first you should create your stored procedure in the destination database MYSAMPLE.
下面的表展示了MT K目前支持的源数据库与目标数据库的组合。
The following table shows the source and target database combinations that MTK currently supports.
LOAD_ONLY:将指定的所有表从源数据库装载到目标数据库中。
LOAD_ONLY: Loads all specified tables from the source database to the target database.
本节描述为源和目标数据库创建数据存储并把它们分配给用户所需的步骤。
This section describes the steps required to create datastores for your source and target databases and assign them to users.
方法1-在目标数据库中,使用DB2的联邦数据库机制访问源数据库。
Approach 1 - From within the target database, the source database is accessed using DB2's mechanisms for federated databases.
运行此工具需要连接目标数据库,所以必须首先创建这个数据库。
Since a database connection to the target is required to run the tool, the DB2 database must be created first.
SCHEMA_MAP允许用户在向目标数据库进行复制时对模式重新命名。
SCHEMA_MAP Allows user to rename schema when copying to a target.
Apply:该组件负责使用由抽取组件获得的增量,然后写进目标数据库。
Apply: This component is responsible for applying the changes captured by the capture component and then writing the changes to a target database.
如果源数据库和目标数据库不在同一个实例中,那么必须对源数据库进行编目。
The source database must be cataloged if it does not reside in the same instance as the target database.
针对整合目标的服务请求的事务响应时间主要由目标数据库服务器的特性决定。
The transaction response time of a service request against the consolidated target is primarily determined by the characteristics of the target database server.
在为源数据库添加数据存储之后,按照相同的步骤为目标数据库添加数据存储。
After you finish adding a datastore for your source database, use the above steps as a guide and add another datastore for your target database.
如果要从同一个逻辑模型实现多个目标数据库,那么可以使用创建新模型的选项。
The option to create a new model is good to implement multiple target databases from the same logical model.
除了用常规备份软件备份目标数据库外,我还建议再保存一份数据的纯文本副本。
In addition to backing up the target database with your normal backup software, I suggest keeping a second copy of the data in plain text.
应用推荐