Charles's Host Integration Server Ramblings

The intent is to share some knowledge about Host Integration Server (HIS) that are not well documented, not well known, as well as various tidbits that come up when supporting HIS and all the various components.

What is the DB2 DRDA Resync Service?

Technorati Tags: Host Integration Server,DB2,DRDA,DTC,Transaction This is something I knew a bit...

Date: 09/18/2009

Replicating NTEXT and IMAGE data to DB2

One issue that came to us recently was on how to replicate SQL data containing NTEXT and IMAGE...

Date: 08/05/2009

WMI and Host Integration Server…

Internally and externally we get customer inquiries wanting to know how to get configuration and...

Date: 06/06/2009

Performance Testing the Microsoft OLE DB Provider for DB2 (Part 3)

In Part 1 of this series I covered testing SQL queries using the Microsoft OLE DB Provider for DB2...

Date: 06/03/2009

Performance Testing the Microsoft OLE DB Provider for DB2 (Part 2)

Technorati Tags: Data Providers,DB2,Host Integration Server,Microsoft OLE DB Provider for...

Date: 06/03/2009

Performance Testing the Microsoft OLE DB Provider for DB2 (Part 1)

Technorati Tags: DB2,SQL Server,SSIS,Microsoft OLE DB Provider for DB2,Host Integration Server,Data...

Date: 05/18/2009

DB2 Code Page Fun

A while back I had a customer who was importing data from AS/400 DB2 tables into SQL Server, using...

Date: 10/31/2008

Using PowerShell to Access DB2

Yes, PowerShell can be used to access DB2 using The Microsoft Host Integration Server Data...

Date: 10/31/2008

Importing CHAR() fields containing null values from DB2 to SQL Server via SSIS

Earlier this year, I was working with a customer who was doing a mainframe migration from DB2 to SQL...

Date: 10/30/2008