Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: BizTalk Adapter for DB2 doesn't process Receive Location UPDATE or DELETE operations against DB2 for i


View products that this article applies to.

Symptoms

BizTalk Adapter for DB2 doesn't process Receive Location UPDATE or DELETE operations against DB2 for i, returning a SELECT result set but not committing changes to database.

↑ Back to the top


Cause

BizTalk Adapter for DB2 processes Receive Location UPDATE or DELETE on SELECT or CALL statements against DB2 for i by using NO COMMIT isolation level instead of CURSOR STABILITY isolation level. This results in no changes committed to the DB2 for i database.

↑ Back to the top


Status

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

↑ Back to the top


Resolution

This issue is fixed in the following cumulative update for Host Integration Server:

↑ Back to the top


References

Learn about the terminology that Microsoft uses to describe software updates.

↑ Back to the top


Keywords: BizTalk Adapter for DB2 doesn't process RL update or delete, CI121757, kbHotfixAuto, kbqfe, kbfix, kb

↑ Back to the top

Article Info
Article ID : 4494465
Revision : 6
Created on : 8/24/2020
Published on : 8/24/2020
Exists online : False
Views : 199