DB2 9.7 – Minimize planned outages when making changes to your database objects

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.

This entry was posted in DB2 9.7, Techie Tips and tagged , , . Bookmark the permalink.