In this tutorial you will see some of the new schema change features available in DB2 9.7.
These new features significantly improve and simplify the administration of objects
within a database schema.
By the end of this tutorial you will be familiar with:
Prerequisites
In order to complete this tutorial you need to make sure that the auto-revalidation (AUTO_REVAL) database configuration
parameter set to DEFERRED_FORCE. When a new database is created, AUTO_REVAL is
default to DEFERRED, that does not allow for creation of objects with errors. On the other hand, IMMEDIATE
will automatically try to revalidate all dependent objects. DEFERRED will
try to revalidate dependent objects the next time they are accessed.
Here is the command for enabling this parameter:
db2 update db cfg for <database name> using AUTO_REVAL [IMMEDIATE | DEFERRED | DEFERRED_FORCE]
This configuration parameter is dynamic, meaning that a change in its value takes effect immediately.
You do not need to restart the database.