The DB2 database handler is a part of the Ekobit.BizDataX.Databases.DB2 NuGet package which has to be installed before the handler can be used. It is used by the BizDataX Designer.
| Table of contents |
|---|
| Installation |
| Settings |
| DB2 specific settings |
| Client-side parallelism |
The installation of the database handlers is described in more detail in the installation guide.
Once installed, it provides a way to configure a restartability store settings in App.config file.
The settings are set in Package.xaml file for each handler, inside the iterator blocks.
Settings are constructed using Fluent Handler API.
Oracle extends those setting with some database specific options:
| Extends | Setting | Description | Data type |
|---|---|---|---|
.WithSegments |
ByPartitions |
Sets ranges defined by DB2 range-partitioned and list-partitioned tables. |
By default, BizDataX only uses server-side parallelism.
To set the level of client-side parallelism, in the Package.xaml file click on a Masking engine, in the Properties pane find MaxParallelIterators and set it to the desired number.
The optimal number of iterators should be close to the physical CPU core count.
BizDataX Documentation © Built by Ekobit. All rights reserved.
https://www.ekobit.com/ https://bizdatax.com/ https://bizdatax.com/support/