IIS-CONN-DB2-00950W DB2 diagnostic record limit (32767 records) exceeded. Native error codes and messages for the failing rows that exceed the limit cannot be provided.

Explanation

DB2 connector writes input data rows in batches. The size of these batches is defined by the Array Size property, for example 2000 rows, or 50000 rows. While processing the batches, DB2 database might report errors with native error code and message. However, native error codes and messages are provided only for the first 32767 error records in a batch. If this limit is exceeded, the remaining errors are listed but with no details.

User response

To get all error details, define smaller batch size to be processed by setting the Array Size property to less than 32767.