DB2 Database Migration Process

Use HCOSS to migrate the DB2 databases from your mainframe to SQL Server (2008) databases that run on Windows.

The basic process is as follows:

1. Install prerequisite third-party software, including:
   • Microsoft .NET Framework 4.0.
   • SQL Server 2008 Enterprise Edition or Developer Edition, including Microsoft SQL Server Management Studio.
   • Microsoft OLE DB Provider for DB2 for SQL Server 2008. This is generally available as part of a SQL Server 2008 Feature Pack download.
   Note: If you intend to develop applications on your local machine, but deploy applications to a SQL Server database on a remote machine, install SQL Server Native Client 10.x for ODBC connectivity on your local machine instead of installing SQL Server 2008. For information on configuring a remote machine, see the topic Deploying to a Remote SQL Server.
2. Get your mainframe user ID, password, network address and port, and the catalog and package collection names from your DBA.
3. Run the Data Access Tool that comes with the OLE DB provider, and use it to:
   • Create a new data source to connect to the mainframe
   • Test the connection
   • Create the packages used by the provider
   • Run the sample query
4. Create a destination SQL Server database using Microsoft SQL Server 2008 SQL Server Management Studio.
5. Create a connection to your SQL Server database using the Manage Connections tool.
6. Extract the DB2 schemas from your mainframe DB2 database to a local or shared directory using the Extract Schema tool.
7. Optionally assess the data migration by viewing and editing the information in the schema extract file created by the Extract Schema tool.
8. Define a list of extracted DB2 schema objects that you want to migrate to the SQL Server database using the Define Lists tool.
9. Create an SQL script to create the DB2 schema objects in the new SQL Server database using the Generate DDL tool.
10. Populate the SQL Server database with the selected schema objects from the DB2 database using the Transfer Data tool.
11. Verify the results of the transferred data using the Compare Data tool.