This article provides guidance on validating database schema objects after migrating from IBM Db2 z/OS to Amazon RDS for MySQL or Amazon Aurora MySQL-Compatible Edition.

• Schema validation is critical to ensure all database objects migrated successfully
• Provides SQL queries to compare Db2 z/OS and MySQL for schemas, tables, views, primary keys, foreign keys, indexes, triggers, procedures, and functions
• AWS SCT creates extension packs (aws_db2z/OS_ext and aws_db2z/OS_ext_data) that should be verified
• Includes both summary-level and detail-level validation queries for each object type
• Addresses migration considerations like data type conversions and indexing strategy differences
• Covers handling of unsupported Db2 objects like aliases, sequences, and materialized query tables
• Queries should run during non-business hours due to potential performance impact on large databases

The post offers practical SQL validation queries to identify missing or incorrectly migrated database objects, helping ensure migration accuracy and target database integrity.