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

Werner Schuetz

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=153183
ArticleTitle=Conveniently create new versions of your database objects
publish-date=08102006