DB2 9.7 - Minimize planned outages when making cha

Author: DB2 Geek Get free access to the entire library

Don't have an account?
Register Online

IBM DB2 9.7 introduces enhancements that allow you to make changes to the database objects while keeping these objects fully accessible to the database users during the modification. These enhancements allow database administrators to make vital changes to the database schema on the fly without any disruption to users. This article includes examples that demonstrate how to use the ALTER TABLE command to rename columns and change column data types. Other examples demonstrate how to use the ADMIN_MOVE_TABLE routine to move and modify tables while keeping them accessible.

Take a look at IBM Developerworks to view the full article.

If you have any questions or comments about this knowledge base article then please use the contact us form to get in touch