You must configure data sources before you create a data migration project. To migrate data from or to a DB2 LUW database, you must create the DB2 LUW database as the source or destination data source. This topic describes how to create a DB2 LUW database as a data source in OceanBase Migration Service (OMS).
Procedure
Log on to the OMS console.
In the left-side navigation pane, click Data Source Management.
On the Data Sources page, click New Data Source in the upper-right corner.
In the New Data Source panel, select DB2_LUW for Data Source Type.
Specify the following parameters.
Parameter Description Data Source Identifier The name of the data source. The name must be 1 to 32 characters in length and can contain Chinese characters, digits, and case-sensitive letters. Region Select the region where the data source resides from the drop-down list. The region is the value you set for the cm_regionparameter when you deploy OMS.
Notice:- This parameter is displayed only when multiple regions are available.
- Make sure that the regions specified for the data source and configured in OMS are the same. Otherwise, the migration and synchronization performance may 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. Username The name of the DB2 LUW database user for data migration or synchronization. We recommend that you create a separate database user for the migration or synchronization task. Password The password of the database user. DB Name The name of the DB2 LUW database. Schema Name (optional) The schema name of the DB2 LUW database. This parameter is optional. If you do not specify this parameter, all schemas on which you have the read privilege can be migrated. Remarks (optional) Additional information about the data source. Click Test Connection to test the network connection between OMS and the source database.
After the connection test succeeds, click OK.