Built-in DB2 LUW driver support plugin

For instructions on how to enable/disable Drop Constraints, Drop Indexes, and Drop Triggers on DB2 LUW jobs, see API Calls for Managing Masking Job Driver Support Tasks.

Unlike other database platforms, DB2 does not support disabling constraints, indexes, or triggers. Therefore, this plugin has Drop Constraints, Drop Indexes, and Drop Triggers tasks.

Tasks

For in-place jobs:

1. Drop Constraints drop and re-create constraints on masked columns only.

2. Drop Indexes drop and re-create indexes on masked columns only (except for indexes automatically generated by DB2 LUW to support a primary key or unique constraint, those are dropped by Drop Constraints).

3. Drop Triggers drop and re-create triggers on tables with masked columns only.

For on-the-fly jobs, the tasks will execute on all columns and tables in the ruleset.

Task Execution Order

The order of task execution for built-in driver support plugins is fixed/unmodifiable.

The order of the tasks is as follows:

Pre-job:

1. Drop Constraints

2. Drop Indexes

3. Drop Triggers

Post-job (mirrored order):

1. Drop Triggers

2. Drop Indexes

3. Drop Constraints

Important Considerations

1. If masking primary key fields, use the same deterministic algorithms on primary key fields that reference each other so that referential integrity is maintained when the masking transformation completes and all constraints are re-created.

2. If dropping indexes on masked fields with constraints is desired, enable both Drop Constraints and Drop Indexes. DB2 LUW automatically creates indexes to support primary key and unique constraints. Those indexes cannot be dropped by the Drop Indexes task, but enabling Drop Constraints will allow it to drop those indexes when the constraints they support are dropped.

Known Limitations

1. If both a foreign key column and the primary key or unique column it references are not masked with the same deterministic algorithm (guaranteeing referential integrity), the job will fail due to an integrity constraint violation.

2. If masking a field that is a primary key or has a unique constraint, and Drop Indexes is the only task enabled, the job will fail. Drop Constraints must also be enabled so that it can drop the indexes DB2 LUW automatically creates to support constraints.