RC/Migrator for DB2 for Z/OS : ALTER TABLE DROP COLUMN Support

Products

• RC Compare for DB2 for z/OS
• RC/Migrator for DB2 for z/OS
• RC/Update for DB2 for z/OS

Issue/Introduction

I want to drop a column of a table with RC/Update alteration or a RC/Migrator strategy.

However, a DROP TABLE is generated instead of ALTER TABLE ..  DROP COLUMN ...

Environment

Release: R19 and R20
Component: RCM

Resolution

Ensure that there are no DB2 restrictions for dropping the column, e.g. if the containing table space is not a universal table space.

See a complete list here:

ALTER TABLE

 (search for ‘A column cannot be dropped if any of the following conditions are true’)

This ability was introduced in R19 release:

ALTER TABLE DROP COLUMN Support

Note that in RC/Migrator , a column is signified to be dropped when editing the table in question and a "D" delete line command is used inside the strategy to delete the column.

The Analysis then decides based on the DB2 rules for the associated tablespace type and other analysis settings if it will utilise a ALTER TABLE DROP COLUMN statement or it may just drop and recreate the table.