Bulk load issue with varchar field ?
Posted: Fri Feb 22, 2013 2:55 pm
We are having a problem with the bulk load option of Db2 connector stage in a partitioned database environment.
If the data type of the primary key is Varchar then it's not loading all the records and just loads records from one of the nodes.
FYI...Database is partitioned in 2 nodes.
Simplified Job design is : Seq file TO Transformer To DB2 Connector stage.
It loads all the records only If I change the execution mode to sequential.
Anyone have seen this issue ?
If the data type of the primary key is Varchar then it's not loading all the records and just loads records from one of the nodes.
FYI...Database is partitioned in 2 nodes.
Simplified Job design is : Seq file TO Transformer To DB2 Connector stage.
It loads all the records only If I change the execution mode to sequential.
Anyone have seen this issue ?