Note: This is a technology preview feature only. It is being made available to allow you to test and provide feedback on this new capability; however, this feature is not intended for production use and it is not supported as such. Furthermore, Micro Focus does not guarantee that this feature will be delivered at a GA level and if it is, then the functionality provided might differ considerably from this technology preview.
The database migration process using MBDT consists of the following steps:
- Create a destination database and schemas using tools provided by your DBMS vendor.
- Create an ODBC connection to the new target database using the Manage Connections tool or ODBC Data Source Administrator.
- Unload data and the LOAD control statement from mainframe DB2 with SQLUTB UNLOAD.
- Using
Enterprise Server, create an
enterprise server instance with Mainframe Subsystem (MSS) that supports JCL applications.
- Configure your
enterprise server instance by creating MBDT aliases.
- Using
Micro Focus
Mainframe Access (MFA) Drag and Drop, copy the LOAD control statement to the Windows machine where MBDTs are to be executed.
- Copy and catalog the unloaded DB2 data on your Windows machine using MFA batch import.
- Using the SQLTP2xx utility, execute DDL to create the tables in the new target database.
- Load the DB2 data into the new target database with the SQLUTBxx utility, using the LOAD card generated on the mainframe.
- Using the SQLTP2xx utility, execute DDL to create the DB2 constraints and indexes in the new target database.
