Article ID: 239458 - View products that this article applies to.
This article was previously published under Q239458
BUG #: 55057,55058,55480 (SQLBUG_70)
While replicating to subscribers running DB2 using the Microsoft OLEDB provider, certain datatypes are mapped incorrectly and nullability is not preserved. Also, when replicating to DB2 subscribers on MVS systems, the distribution agent fails with this error:
SQLCODE: -601 SQLSTATE: 42710
A SQL error has occurred. Please consult the documentation for your specific DB2 version for a description of the associated Native Error and SQL State.
SQLCODE: -302 SQLSTATE: 22001
The value of the input variable or parameter is invalid or too large for the target column or target value.
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.
If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.
Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language. The English version of this fix should have the following file attributes or later:
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the above files may also contain additional files.
File name Platform -------------------- s70722i.exe Intel s70722a.exe Alpha
Specific symptoms encountered due to this bug are: