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
Enterprise Developer,
from the
Start menu, or
from the command line.