MBDT Configuration Utility

The MDBT Configuration Utility enables you to configure options for the following tools:

SQLTP2 - Database Selection
Enables you to specify how to handle dynamic SQL statements during migration.
HCOSS
For SQL Server databases in which dynamic SQL statements are z/OS DB2 statements. This option is required when you are using HCOSS to migrate the database and your code contains z/OS DB2 CREATE SCHEMA statements.
Agnostic
Default. For SQL Server, DB2 LUW, Oracle, and PostgreSQL databases in which dynamic SQL statements are specific to the DBMS vendor specifications.
SQLUTB - Commit
To specify the issuing of single or multiple commit statements during a LOAD operation. The default is a single commit issued after all records have been loaded.

We recommend that you use the single commit to provide optimal performance. However, if DBMS logging or other such issues are a concern, you might prefer the multiple commit. For the multiple commit, you also specify a batch size (number of rows). During the LOAD operation, a commit is issued each time the batch size has been reached.

You can run the MBDT Configuration Utility from Visual Studio, from the Start menu, or from the command line.