Conveniently create new versions of your database objects
New functions for maintaining schemas and altering tables in DB2 9 for Linux, UNIX, and Windows
From the developerWorks archives
Date archived: January 12, 2017 | First published: August 10, 2006
Do you want to duplicate your database objects grouped by a schema in order to create a test system on a new database? Do you wish to create a new version of your objects within the same database? Or do you need to alter your tables by dropping columns, altering data types, or changing the nullability attribute of a column? DB2 9 for Linux, UNIX, and Windows® introduces some nice extensions like the ADMIN_COPY_SCHEMA procedure, the DB2MOVE utility with the COPY action and some ALTER TABLE statement enhancements. These new functions make it very convenient to create new copies of a database schema and its associated database objects.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.