|
Db2/z Schema Evolution |
Scroll |
•Requires Db2 V12
•Sends Metadata Updates to Apply side
1.Replicator dynamically changes target JSON/AVRO to match altered table
2.Apply Engine with DDL will stop if incompatible with altered table
•Supported Alter Events
1.Add Column
2.Drop Column
3.Rename Column
4.Alter Column Length
5.Alter Column Type → Integer to DECIMAL, CHAR to VARCHAR, etc.
6.Create Table (allows for preregister of tables that have not yet been created)
7.Drop Table
8.Rename Table
•Requires DATA CAPTURE CHANGES on Two (2) Catalog Tables
1.SYSIBM.SYSTABLES
2.SYSIBM.SYSCOLUMNS
