View a markdown version of this page

⭐ Must Read: dms/latest/userguide/schema conversion db luw postgresql.html - Kapook Update 2025

IBM Db2 for LUW to Amazon RDS for PostgreSQL conversion settings

The IBM Db2 for LUW to Amazon RDS for PostgreSQL conversion path has no pair-specific conversion settings other than the target engine version. The following section describes that setting.

DMS Schema Conversion also provides common settings that apply to every conversion path. Examples include the severity level for action-item comments in converted SQL and the option to use generative AI for conversion. For those settings, see Common conversion settings.

You can configure the target engine version using the AWS Management Console or the ModifyConversionConfiguration API operation. To find the current value, call DescribeConversionConfiguration first.

The following setting shows the AWS Management Console label. The API and AWS CLI parameter name appears in parentheses. Use the parameter name when configuring the setting with the API or AWS CLI.

Target engine version (DB2LUW_TO_POSTGRESQL_target_engine_version)

Specifies the PostgreSQL major version feature set that DMS Schema Conversion targets for conversion. The value 15 targets the features of PostgreSQL 15 and later versions. The value 14 targets the features of PostgreSQL 14. Your target database can run a later version than the value you choose. For example, you can specify 15 for a PostgreSQL 16 target. This setting is stored in the top-level Conversion version section, as shown in the following example.

{
  "Conversion version": {
    "DB2LUW_TO_POSTGRESQL_target_engine_version": "15"
  }
}

Type: String (14 | 15)

Default: 15