Database Migration Services for DB2 LUW

Objective: Migrate existing database to DB2 for Linux, UNIX, and Windows.

The DB2 Universal Database Migration Services engagement is designed to provide your organization with assistance, support, and skills transfer during version to version or platform to platform migration of your existing database environment to DB2 for Linux, Unix, and Windows.

This service engagement involves a phased approach to database migration. First your organization's development and/or test database environment is migrated to DB2 followed by your organizations user acceptance and/or production environments. Finally, database client machines will need to be upgraded as well.

Background Information

Planning for a database migration is an important aspect that should not be overlooked. Simple version to version database migration involves upgrading the database management system (DBMS) software and migrating the database objects such as tables, indexes, and views. The database software is upgraded using the installation program provided with the DB2. The software also provides two methods of migrating the database depending on the version of the pre-migrated database.

The process of migrating a database simply creates the database without taking advantage of features available with DB2 such as table spaces, containers, check constraints, and triggers that may not have been available in previous versions of DB2.

In many cases migrating to a newer version of DB2 requires exporting and importing database objects to take advantage of new database functionality and upgraded hardware. In addition to leveraging these features it is also very important to reevaluate both the Database Manager (instance) and Database configuration parameters after major changes to the system.



Copyright © 1998 - 2019 Ten Digit Consulting, LLC | All rights Reserved