We recently worked on a support case where a customer was using the Data Access Tool (DAT), which is included with Host Integration Server and the Microsoft OLE DB Provider for DB2 that is included in SQL Server Feature Packs, We often suggest that you use the DAT to create the connection string (UDL) that is used to connect to your IBM DB2 systems and then to run the Sample Query to the connection string to see if you are able to make a basic query without error.

In this case, the data returned by the Sample Query was incomplete.

The Sample Query issues a query against the SYSTABLES table in DB2. SYSTABLES is a system catalog tables that contains information about each table that is defined in the database. When you run the Sample Query in the DAT, it sends a query to DB2 to get a list of the tables that are defined in the Schema that is specified in the connection string.

To read the complete post, please visit Stephen Jackson’s Blog : http://blogs.msdn.com/b/sjackson/archive/2013/01/08/missing-data-when-querying-ibm-db2-tables-due-to-code-page-issues.aspx