ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to fix a SQLCODE=-148 in a RC/Migrator strategy with a clone table?.
Article ID: 104031
RC Compare for DB2 for z/OSDatabase Analyzer for DB2 for z/OSFast Unload for DB2 for z/OSFast Check for DB2 for z/OSFast Index for DB2 for z/OSFast Load for DB2 for z/OSRapid 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.