Database Change Management and Schema Evolution in DB2 for z/OS Version 8

Authors: 
Mullins, C.S.
Author: 
Mullins, C
Year: 
2005
Venue: 
DBAzine, 2005
URL: 
http://www.dbazine.com/db2/db2-mfarticles/mullins-onlineschema
Citations: 
0
Citations range: 
n/a

DB2 V8 begins the process of making it easier to implement database changes with fewer steps and less downtime. IBM calls the changes being made to DB2 to facilitate simpler and quicker database changes \"online schema evolution\". For example, as of V8, you can change a CHAR column to a larger size simply using ALTER. The remainder of this article will focus on the improved schema changes supported by DB2 Version 8.