Chapter 7. Database Change Management, Schema Evolution, and Database Definition On Demand
In Chapters 5 and 6 we examined how to create useful and efficient DB2 database objects. After we create databases, table spaces, tables, indexes, and so on, we build application programs to access the DB2 data and move everything into production. Eventually, we will need to change the database to meet changing business needs.
Historically, one of the biggest causes of database downtime has been to accommodate changes being made to DB2 database structures. This is so because many of the most common changes required of DB2 objects were not supported with simple
ALTERs. Instead, ...