Create a DB2 LUW data source

You must configure data sources before you create a data migration project. Before you start data migration, you can add a DB2 LUW database as the source or destination data source. This topic describes how to create a DB2 LUW data source in OceanBase Migration Service (OMS).

Procedure

1. Log on to the OMS console.

2. In the left-side navigation pane, click Data Source Management.

3. On the Data Source Management page, click New Data Source in the upper-right corner.

   

4. In the New Data Source dialog box, select DB2_LUW for Data Source Type.

5. Configure the following parameters.

   Parameter	Description
   Data Source Identifier	We recommend that you set it to a combination of digits and letters. It must not contain any spaces and cannot exceed 32 characters in length. Notice The data source identifier must be globally unique in OMS.
   Region	Select the region where the data source resides from the drop-down list. The region is the value that you set for the cm_region parameter when you deploy OMS. Notice This parameter is displayed only when multiple regions are available. Make sure that the mappings between the data source and the region are consistent. Otherwise, the migration and synchronization performance can be poor.
   Host IP Address	The public IP address of the host on which the database is located.
   Port	The port number of the public IP address of the host on which the database is located.
   Database Username	The name of the DB2 LUW database user for data migration or synchronization. We recommend that you create a dedicated database user for the migration or synchronization project.
   Database Password	The password of the database user.
   DB Name	The name of the DB2 LUW database. Note When the data source serves as the source of a data migration project, you can select only migration objects in the specified database.
   Schema Name (Optional)	The schema name of the DB2 LUW database. Note If this parameter is specified, you can select only migration objects in the specified schema when the data source serves as the source of a data migration project. If this parameter is not specified, you can select all accessible schemas as the migration objects.
   Remarks (Optional)	Additional information about the data source.

   When you configure a data source, you can choose whether to select the following option: Allow OMS to automatically write heartbeat data into this instance during incremental synchronization. This resolves the problem of high latency when no business data is written in the source database.

   • If you select this option, OMS creates the drc.heartbeat table in the DB2 LUW database and updates the table to store the synchronization timestamps. This prevents OMS from displaying lengthy latency information when the source database is not processing business traffic.

     If you want to create a heartbeat table, see Create and update a heartbeat table.

   • If you do not select this option, OMS does not create the drc.heartbeat table.

6. Click Test Connection to test the network connection between OMS and the source database.

7. After the test is passed, click OK.