View a markdown version of this page

IBM Db2 for z/OS to Amazon RDS for Db2 conversion settings - Amazon Database Migration Service
Example: Configure IBM Db2 for z/OS to Amazon RDS for Db2 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).

IBM Db2 for z/OS to Amazon RDS for Db2 conversion settings

Important

DMS Schema Conversion does not provide a Amazon Web Services Management Console experience for the IBM Db2 for z/OS to Amazon RDS for Db2 conversion path. You cannot create or configure these migration projects in the Amazon Web Services Management Console, so you configure every setting on this page with the Amazon CLI or the Amazon Database Migration Service API. Because there is no Amazon Web Services Management Console for this conversion path, each setting is identified only by its API and Amazon CLI parameter name, not by a Amazon Web Services Management Console label.

The following settings apply when the source is IBM Db2 for z/OS and the target is Amazon RDS for Db2. Configure these settings using the ModifyConversionConfiguration API operation or the Amazon CLI.

This topic covers settings specific to the IBM Db2 for z/OS to Amazon RDS for Db2 conversion path. In addition to these settings, DMS Schema Conversion provides settings that apply to all source and target pairs, such as 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.

When you use the API or Amazon CLI, specify conversion path settings under the section name DB2ZOS_TO_DB2LUW. To find which section names your project uses, call DescribeConversionConfiguration first and update only the sections present in the response.

ConvertNumberToBigint

Specifies whether DMS Schema Conversion maps IBM Db2 for z/OS numeric columns without explicit precision to BIGINT.

  • false — Numeric columns are mapped to the default numeric type on the target.

  • true — Numeric columns without explicit precision are mapped to BIGINT. Use this when these columns hold integer values and you want the most efficient integer type.

Type: Boolean (true | false)

Default: false

SchemaNameTemplate

Controls how the target schema name is generated from the IBM Db2 for z/OS database and schema names.

API/CLI value Generated target schema name
DB_SCHEMA database_schema. Use when migrating multiple databases to the same target instance to avoid name collisions.
DB database
SCHEMA schema. Use when migrating a single database and you want clean schema names without a database prefix.

Type: String (enum)

Default: DB_SCHEMA

You configure these settings with the JSON format that the API and Amazon CLI require, as shown in the following example.

Example: Configure IBM Db2 for z/OS to Amazon RDS for Db2 settings

The following example sets SchemaNameTemplate for the DB2ZOS_TO_DB2LUW section.

{
  "DB2ZOS_TO_DB2LUW": {
    "SchemaNameTemplate": "SCHEMA"
  }
}