Staging propagation utility fails during propagation and is unable to locate the record that causes the failure Technote
(troubleshooting)Problem(Abstract) You notice the staging propagation utility fails during propagation and is unable to locate the record that causes the failure. Cause The staging propagation utility propagates changes from your staging database to your production database using a batch size of 100 records by default. There is an issue with the JDBC driver for DB2 versions 8.2.3 (or 8.1.10) when using batch updates.
When the "-batchsize" option is not specified for stage propagate utility, the following error might occur:
<error> The SQL batch update failed.
fail to locate the change that fails propagation
<error> The command failed to complete the propagation job.Resolving the problem This issue is resolved in DB2 version 8.2.4 (or 8.1.11) and later versions. As a workaround, modify your command line arguments for the staging propagate utility to include the option "-batchsize 0"
Document Information Current web document: http://www.ibm.com/support/docview.wss?uid=swg21257046