AWS dms documentation change
Summary
Added support for IBM Db2 to PostgreSQL conversion paths and documented conversion limitations/error codes for these new paths
Security assessment
This change adds new database migration conversion paths and documents technical limitations during schema conversion. There is no evidence of security vulnerabilities, patches, or security features being addressed. The changes are purely about expanding supported migration scenarios and documenting conversion constraints.
Diff
diff --git a/dms/latest/userguide/schema-conversion-convert.databaseobjects.md b/dms/latest/userguide/schema-conversion-convert.databaseobjects.md index edf68ef3e..279d763f9 100644 --- a//dms/latest/userguide/schema-conversion-convert.databaseobjects.md +++ b//dms/latest/userguide/schema-conversion-convert.databaseobjects.md @@ -79,0 +80,8 @@ Supported conversion paths: + * IBM Db2 for Linux, UNIX and Windows (LUW) to Amazon RDS for PostgreSQL + + * IBM Db2 for Linux, UNIX and Windows (LUW) to Amazon Aurora PostgreSQL + + * IBM Db2 for z/OS to Amazon RDS for PostgreSQL + + * IBM Db2 for z/OS to Amazon Aurora PostgreSQL + @@ -223,0 +232,41 @@ SAP ASE (Sybase ASE) to Amazon RDS for PostgreSQL and SAP ASE (Sybase ASE) to Am +IBM Db2 for Linux, UNIX and Windows (LUW) to Amazon RDS for PostgreSQL and IBM Db2 for Linux, UNIX and Windows (LUW) to Amazon Aurora PostgreSQL | 4506 | PostgreSQL doesn't support view definition that contains set operations at the top level | All occurrences except limitations +4523 | PostgreSQL doesn't support inserting into query | All occurrences except limitations +4524 | PostgreSQL doesn't support returning values before calculation in insert statement | All occurrences except limitations +4526 | PostgreSQL doesn't support the %s function | All occurrences except limitations +4527 | PostgreSQL doesn't support updating with data using query | All occurrences except limitations +4528 | PostgreSQL doesn't support returning values before calculation in update statement | All occurrences except limitations +4529 | PostgreSQL doesn't support returning old values in update statement | All occurrences except limitations +4531 | PostgreSQL doesn't support INCLUDE columns | All occurrences except limitations +4532 | PostgreSQL doesn't support INCLUDE columns in insert statement | All occurrences except limitations +4533 | PostgreSQL doesn't support quantity restriction of rows in update statement | All occurrences except limitations +4534 | PostgreSQL doesn't support deleting with data using query | All occurrences except limitations +4536 | PostgreSQL doesn't support quantity restriction of rows in delete statement | All occurrences except limitations +4537 | PostgreSQL doesn't support period-specification clause | All occurrences except limitations +4538 | PostgreSQL doesn't support outer-table-reference | All occurrences except limitations +4539 | PostgreSQL doesn't support continue-handler clause | All occurrences except limitations +4541 | PostgreSQL doesn't support modules | All occurrences except limitations +4549 | PostgreSQL doesn't support `GOTO` statement | All occurrences except limitations +4556 | PostgreSQL error code type is not a number and is incompatible with the number type variables | All occurrences except limitations +4558 | PostgreSQL doesn't support the typed view | All occurrences except limitations +4559 | PostgreSQL doesn't support the `MERGE` statement | All occurrences except limitations +4572 | PostgreSQL doesn't support functions that return a row with using type methods | All occurrences except limitations +4573 | PostgreSQL doesn't support methods invocation | All occurrences except limitations +4575 | PostgreSQL doesn't support CREATE GLOBAL TEMPORARY TABLE without name of schema or with name of schema - SESSION | All occurrences except limitations +4583 | Unable to convert system objects | All occurrences except limitations +4597 | PostgreSQL does not have functionality similar to UTL_MAIL module | All occurrences except limitations +4598 | PostgreSQL does not have functionality similar to UTL_SMTP module | All occurrences except limitations +4605 | DMS SC can't convert unsupported clauses in MERGE statements | All occurrences except limitations +4606 | DMS SC can't convert MERGE statements that include unsupported clauses | All occurrences except limitations +4612 | PostgreSQL does not support special-register functionality | All occurrences except limitations +9996 | Internal Converter error occurred | All occurrences except limitations +IBM Db2 for z/OS to Amazon RDS for PostgreSQL and IBM Db2 for z/OS to Amazon Aurora PostgreSQL | 8507 | PostgreSQL does not support the %s function | All occurrences except limitations +8519 | FETCH clause is not supported | All occurrences except limitations +8521 | Positioned deletes are not supported | All occurrences except limitations +8542 | PostgreSQL doesn’t support default namespaces | All occurrences except limitations +8559 | DMS SC can’t convert MERGE statements that include unsupported clauses | All occurrences except limitations +8560 | PostgreSQL doesn’t support the usage of variables or parameters in RAISE statements | All occurrences except limitations +8563 | PostgreSQL uses different format for interval data types compared to Db2 for z/OS | All occurrences except limitations +8566 | DMS SC can’t convert bulk and backward data fetching from a cursor | All occurrences except limitations +8570 | DMS SC can’t convert MERGE statements in FINAL TABLE table references | All occurrences except limitations +8581 | DMS SC can’t convert UPDATE statements that include unsupported clauses | All occurrences except limitations +9996 | Internal Converter error occurred | All occurrences except limitations