How to fix a SQLCODE=-148 in a RC/Migrator strategy with a clone table?.
Article ID: 104031
CA RC Compare for DB2 for z/OSCA Database Analyzer for DB2 for z/OSCA Fast Unload for DB2 for z/OSCA Fast Check for DB2 for z/OSCA Fast Index for DB2 for z/OSCA Fast Load for DB2 for z/OSCA Rapid Reorg for DB2 for z/OS
A RC/Migrator Compare strategy generated the following ALTER statements to add a column to a clone table.
ALTER TABLE ... DROP CLONE; ALTER TABLE ... ADD ... to add the column. ALTER TABLE ... ADD CLONE ... to add again the clone table. This last ALTER statement was wrong and it created an SQLCODE = -148, the versioning has to be removed with a Reorg Utility after the ALTER TABLE ... ADD statement to add the column.