Using Amazon RDS for Db2 and IBM Db2 LUW as a target for Amazon DMS - Amazon Database Migration Service
Limitations when using Db2 LUW as a targetEndpoint settings
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Using Amazon RDS for Db2 and IBM Db2 LUW as a target for Amazon DMS

You can migrate data to an Amazon RDS for Db2 or an on-premises Db2 database from a Db2 LUW database using Amazon Database Migration Service (Amazon DMS).

For information about versions of Db2 LUW that Amazon DMS supports as a target, see Targets for Amazon DMS.

You can use Secure Sockets Layer (SSL) to encrypt connections between your Db2 LUW endpoint and the replication instance. For more information about using SSL with a Db2 LUW endpoint, see Using SSL with Amazon Database Migration Service.

Limitations when using Db2 LUW as a target for Amazon DMS

The following limitations apply when using Db2 LUW database as a target for Amazon DMS. For limitations on using Db2 LUW as a source, see Limitations when using Db2 LUW as a source for Amazon DMS.

  • Amazon DMS only supports Db2 LUW as a target when the source is either Db2 LUW or Db2 for z/OS.

  • Using Db2 LUW as a target doesn't support replications with full LOB mode.

  • Using Db2 LUW as a target doesn't support the XML datatype in the full load phase. This is a limitation of the IBM dbload utility. For more information, see The dbload utility in the IBM Informix Servers documentation.

  • Amazon DMS truncates BLOB fields with values corresponding to the double quote character ("). This is a limitation of the IBM dbload utility.

Endpoint settings when using Db2 LUW as a target for Amazon DMS

You can use endpoint settings to configure your Db2 LUW target database similar to using extra connection attributes. You specify the settings when you create the target endpoint using the Amazon DMS console, or by using the create-endpoint command in the Amazon CLI, with the --ibm-db2-settings '{"EndpointSetting": "value", ...}' JSON syntax.

The following table shows the endpoint settings that you can use with Db2 LUW as a target.

Name Description

KeepCsvFiles

If true, Amazon DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting..

LoadTimeout

The amount of time (in milliseconds) before Amazon DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).

MaxFileSize

Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.

WriteBufferSize

The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).