Batch Migration Process

The database migration process using MBDT consists of the following steps:

1. Create a destination database and schemas using tools provided by your DBMS vendor.
2. Create an ODBC connection to the new target database:
   • On Windows platforms, catalog an ODBC Data Source Name to the new target database using the 32- or 64-bit ODBC Data Source Administrator, depending on the COBOL working mode of your enterprise server instance.
   • On UNIX platforms, catalog an ODBC Data Source Name to the new target database using instructions from your ODBC Driver Manager documentation.
3. Unload data and the LOAD control statement from z/OS DB2 with DSNUTILB UNLOAD.
4. Using Enterprise Server, create an enterprise server instance with Mainframe Subsystem Support (MSS) that also supports JCL applications.
5. Configure your enterprise server instance by creating an ODBC XAR and MBDT aliases.
6. Copy the LOAD control statement to the MBDT Windows or UNIX machine.
7. Copy and catalog the unloaded DB2 data on the MBDT Windows or UNIX machine.
8. Using SQLTP2, execute DDL to create the tables in the new target database.
9. Load the DB2 data into the new target database with SQLUTB, using the LOAD card generated on the mainframe.
10. Using SQLTP2, execute DDL to create the DB2 constraints and indexes in the new target database.