FIX: Invalid data is inserted into DB2 Unicode graphic columns when the DB2 provider is configured to use Host CCSID = 1208 in a Host Integration Server 2009 environment

Symptoms

In a Microsoft Host Integration Server 2009 environment, you install the fix that is described in the following article in the Microsoft Knowledge Base:

2550921 FIX: Error message when queries are submitted to DB2 for z/OS Version 7 in a Host Integration Server 2009 environment: "SQLSTATE: HY000, SQLCODE: -344"When you use a managed data provider together with Unicode graphic columns on an IBM DB2 V6R1 data source, you notice that invalid data is inserted in the columns.

For example, you set the following parameters:

SetParms.SetGraphic(cmd, 28, "", 10);
//"DNY58TME GRAPHIC(10) CCSID 13488 DEFAULT NULL , " +
SetParms.SetGraphic(cmd, 29, "101010", 10);
//"DNTORG GRAPHIC(10) CCSID 13488 DEFAULT NULL , " +
SetParms.SetGraphic(cmd, 30, "10", 10);
//"DNVERS GRAPHIC(10) CCSID 13488 DEFAULT NULL , " +
SetParms.SetGraphic(cmd, 31, "", 10);
//"DNPID GRAPHIC(10) CCSID 13488 DEFAULT NULL , " +
SetParms.SetGraphic(cmd, 32, "", 10);
//"DNUSER GRAPHIC(10) CCSID 13488 DEFAULT NULL , " +
SetParms.SetGraphic(cmd, 33, "101010", 10); 

The output you receive resembles the following when you use 1208 for the host character code set identifier (CCSID) property:

Column Name: DNY58EDIMJ Param 28 -              DataType = Graphic
Column Name: DNY58TME   Param 29 - 101010       DataType = Graphic
Column Name: DNTORG     Param 30 - 10           DataType = Graphic
Column Name: DNVERS     Param 31 - ???          DataType = Graphic
Column Name: DNPID      Param 32 -              DataType = Graphic
Column Name: DNUSER     Param 33 - 101010       DataType = Graphic 

Resolution

The hotfix that resolves this issue is included in Cumulative Update 1 for Host Integration Server 2009.

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:

2587090 Cumulative update package 1 for Host Integration Server 2009

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.