Auto-commit for Erwin XML scanner.

Products

• Repository

Issue/Introduction

 

The extract portion of the Erwin scanner can be unacceptably slow when parsing large models. Performance can be greatly improved by use of the Auto-commit parameter.

 

 

Environment

7.2

Repository-Webstation Option
 

Resolution

You can use the Auto-commit check box on the Repository Exchange for Erwin XML scanner dialog screen to improve performance. If Auto-commit is set ON, then a commit will be performed after every statement. A DB2 PREPARE will be performed after every commit. PREPARE is the most expensive DB2 statement. However, DB2 has the capability of caching these PREPARE statements. The combination of Auto-commit and caching will greatly improve performance. To take advantage of the caching functionality, the Erwin parser must be using at least DB2Connect Version 8.1 as its ODBC driver.

The instructions for setting up caching of PREPARE statements can be found in the IBM DB2 Connect documentation. Search for the keyword "KeepDynamic".