DB2 9.7 - Minimize planned outages when making cha
Author: DB2 Geek Get free access to the entire library
Don't have an account?
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.
If you have any questions or comments about this knowledge base article then please use the contact us form to get in touch