Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Symptoms

Consider the following scenario in Microsoft Host Integration Server 2013:

  • You have a receive location that is configured to use the Microsoft BizTalk Adapter for DB2.

  • You configure the BizTalk Adapter for DB2 to include specific DB2 SET statements (for example, SET CURRENT PATH 'TESTLIB') in the DB2 SET Registers property.


In this scenario, the DB2 SET commands are not passed to the remote IBM DB2 database server.

Cause

The BizTalk Adapter for DB2 did not support passing DB2 SET commands when these commands were used with a receive location. The DB2 SET Registers feature was originally added to the BizTalk Adapter for DB2 for a specific scenario that occurs when the DB2 Adapter is used with a Solicit-Response send port.

Resolution

Install Cumulative 2 Update (CU2) for Microsoft Host Integration Server 2013. When CU2 is installed, DB2 SET statement support is implemented for the receive ports. 

Cumulative update information

The fix that resolves this problem is included in Cumulative Update 2 for Microsoft Host Integration Server 2013.

The binary that is affected is Microsoft.HostIntegration.Adapters.MsDb2.Runtime.dll.

Status

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×