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 MBDT toolset provides basic batch utility support for the following z/OS DB2 utilities:
- DSNTEP2
- Enables you to execute SQL DDL and DML in a target DBMS using an SQLTP2 alias.
DSNTEP2 accepts native DBMS DDL and DML syntax for DB2 LUW, Oracle, and SQL Server by default. DSNTEP2 also accepts z/OS DB2 DDL and DML syntax for SQL Server. See
MBDT Configuration Utility for details.
- DSNUTILB
- Enables you to load or unload your data to or from the target DBMS using an SQLUTB alias.
The versions of DSNTEP2 and DSNUTILB provided by
Micro Focus always use ODBC to communicate with target DBMSs. To enable ODBC support, you must define an XAR to Enterprise Server that uses the ODBC generic one-phase commit switch module. See
Generic One-phase Commit for ODBC RM Switch Module for details.
Note: We provide MBDT for DB2 LUW, SQL Server, Oracle, and PostgreSQL for Windows 32-bit and 64-bit environments.
On limited UNIX platforms, we provide 32-bit versions of MBDT for use with DB2 LUW only. See
Additional Software Requirements on Linux and UNIX for details. Additional restrictions apply as specified in this topic. Also, MBDT is supported on UNIX via command line only.
