IIS-CONN-DB2-00678E You must set the partition type to the Db2 connector when loading to a partitioned database


The partition type was not set to Db2 connector when loading data into the partitioned database.

Typically this error occurs when the Usage > Write mode property is set to Bulk load and the target database has more than one partition, but the Partition type property (on the Partitioning tab) is not set to Db2 connector. If there is a mismatch between the data partitioned by the Db2 connector and the target database, Db2 discards the data.

User response

Set the Partition type property to Db2 connector to ensure that the data is loaded properly in the partitioned database.