Tutorial: Mainframe Batch Database Tools (MBDT)

Takes you step by step through the process of migrating a mainframe-based DB2 table on the mainframe to a local SQL Server using Mainframe Batch Database Tools (MBDT).

Assumptions

This tutorial is written from the perspective that all of the following items are true. Specific instructions for setting up your environment to adhere to these assumptions is found in the Before you begin section that follows:

  • Windows File Explorer is set to show file names and extensions.
  • Windows User Account Control (UAC) is turned off.
  • You are running the latest version of Enterprise Developer.
  • For mainframe connectivity, you have a TN3270 terminal emulator installed, which is configured to connect to your mainframe.
    Note: This tutorial uses Rumba+ Desktop as the terminal emulator, but you may adapt the tutorial to suit your terminal emulator of choice.
  • You have installed and can access a supported version of Microsoft SQL Server.
  • Visual Studio is started on your local machine.
  • Your parent project directory is c:\tutorials\MBDT. If you choose to use an alternative parent project directory, adjust the instructions accordingly.
  • You have addressed all of the items in the Before you begin section below.

Before you begin

Before beginning, be sure you have addressed each of the following items:

Enterprise Server Security
In this release, the Enterprise Server security features are enabled by default. Tutorials that use enterprise server regions, however, assume that Enterprise Server security is not configured. To work though this tutorial unchanged, you need to disable any configured Enterprise Server security. See To Disable the Default Enterprise Server Security Configuration for details.
Important: Micro Focus does not recommend disabling the security permanently. Re-enable it as soon as possible after completing tutorials. See To Recreate the Default Enterprise Server Security Configuration. For more information, see also After Installing > Enterprise Server Security Considerations.
Set Windows File Explorer options
These tutorials assume that your Windows File Explorer options are set to use the Details layout, and to show file name extensions. See your Windows documentation for more information.
Turn off Windows User Account Control (UAC)
Depending on the Windows UAC setting on your machine, HCOSS exhibits different behavior for some features. The differences in behavior are dependent on things such as whether or not you are logged in as a standard user or an administrator, whether or not you are a member of the Windows Administrators group, and how you start the HCOSS user interface. These tutorials assume that you have turned UAC off by setting it to Never notify. See your Windows documentation for details.
Create a parent project directory
Create a directory in which to store the project files imported or created while completing this tutorial, which cites a parent project directory of c:\tutorials\MBDT.
Start Visual Studio
If you need instructions to get Visual Studio started on your local machine, see To start Visual Studio.
Note: If Visual Studio prompts you on startup to select an initial action, click Continue without code.

Sequence

To complete this tutorial, progress through these topics in the order presented here. The bottom of each topic provides Next topic and Previous topic navigational links to help you proceed in the proper sequence:

  1. Set Up the HCO_Test SQL Server Database
    Guides you through the steps required to create the HCO_Test SQL Server database, create a schema in the database where you can place your migrated DB2 tables, and create a connection to the database.
  2. Prepare Mainframe Data
    Provides instructions for using DB2 on the mainframe to unload mainframe data and execute the LOAD control statement.
  3. Build the ODBC XA Switch Module
    Guides you through the process of configuring your machine to build the ODBC XA switch module used in these tutorials, and then building the module.
  4. Set Up the JCL1 Project
    Provides step-by-step instructions to create the JCL1 Visual Studio project and configure it to use with this tutorial.
  5. Set Up the DSNUTILS Enterprise Server Region
    Walks you through the steps required to create the JCL-enabled DSNUTILS enterprise server region.
  6. Download and Catalog DB2 Data
    Guides you through the steps required to copy the LOAD control statement from the mainframe to your Windows machine using Enterprise Developer Mainframe Access Drag and Drop, and to copy the unloaded DB2 data to your Windows machine using the Mainframe Access command-line tools.
  7. Migrate the Database
    Provides step-by-step instructions to complete the migration of the DB2 database to your SQL Server database by using a Visual Studio JCL project and Mainframe Batch Database tools.
Parent topic: Mainframe Tutorials
Related tasks
To start an Enterprise Developer command prompt as an administrator
To start Visual Studio
To start the ODBC Data Source Administrator