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.
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.