DB2 database handler

The DB2 database handler is used in BizDataX Designer for handling (masking) DB2 databases.

Table of contents
Installation
Settings
DB2 specific settings
Client-side parallelism

Installation

To install the DB2 database handler add the BizDataX.Databases.DB2 NuGet package to the solution.

Once installed, it provides a way to configure a restartability store settings in App.config file.

Settings

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:

DB2 specific settings

Extends Setting Description Data type
.WithRange Partitions Sets ranges defined by DB2 range-partitioned and list-partitioned tables.

Client-side parallelism

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.