Symptoms
In a Microsoft Host Integration Server 2010 environment, you try to provoke an SQL error message. When the error message includes more than one diagnostic value in the SQL Communication Area (SQLCA), the Microsoft OLE DB Provider for DB2 parameters are not populated correctly.
For example, when you try to provoke SQLCODE -803, the SQL error message may resemble the following:AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN INDEX SPACE XPEI01?00001A6E04 CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X''
However, the SQL error message SQLCODE -803 should resemble the following:
AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace_name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X record_id
Resolution
Cumulative update information
The fix that resolves this issue is included in cumulative update package 6 for Host Integration Server 2010. For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2752426 Cumulative update package 6 for Host Integration Server 2010
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.