Symptoms
In Microsoft Host Integration Server 2010, you use the Managed Provider for DB2 to call a stored procedure in order to insert GRAPHIC data as parameter into a DB2-defined GRAPHIC column. However, when the size of the data to be inserted is smaller than the size of the defined GRAPHIC column, the inserted data is padded either with Null values or with random data.
Cause
This issue is caused by an incorrect handling of the parameter.
Resolution
The fix that resolves this problem is included in Cumulative Update 10 for Host Integration Server 2010.
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 the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.
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, contact 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, go to the following Microsoft website:
http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
Note 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.
Prerequisites
To apply this hotfix, you must have cumulative update package 9 for Microsoft Host Integration Server 2010 installed. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2897923 Cumulative Update 9 for Host Integration Server 2010 is available
