So I’m trying to change the size of a column in DB2. Nothing fancy, just expand a varchar from 100 to 200 and in DB2 Control Center I get the following message:
The current column attribute change may take some time to complete, as it requires re-creating the table, loading the data, and restoring the dependencies.
This table is approximately 0.00390625 Mb in size. The new table will be created before the existing table is removed.
Click ‘Related Objects…’ for more detail.
I find it crazy that MySQL can do this in a heartbeat and a commercial database like DB2 needs to jump through the hoops of dropping, backing up data, recreating data, deleting the backup and God knows what else.