The database migration process using MBDT consists of the following steps:
- Create a destination database and schemas using tools provided by your DBMS vendor.
- Catalog an ODBC Data Source Name to the new target database.
- Unload data and the LOAD control statement from z/OS DB2 with DSNUTILB UNLOAD.
- Using
Enterprise Server, create an
enterprise server instance with Mainframe Subsystem Support (MSS) that also supports JCL applications.
- Configure your
enterprise server instance by creating an ODBC XAR, and MBDT aliases.
- Copy the LOAD control statement to the MBDT loxL machine.
- Copy and catalog the unloaded DB2 data on the MBDT local machine.
- Using SQLTP2, execute DDL to create the tables in the new target database.
- Load the DB2 data into the new target database with SQLUTB, using the LOAD card generated on the mainframe.
- Using SQLTP2, execute DDL to create the DB2 constraints and indexes in the new target database.