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, ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.