Microsoft KB Archive/278242

= DB2OLEDB Provider Incorrectly Maps Isolation Levels =

Article ID: 278242

Article Last Modified on 3/10/2004

-

APPLIES TO


 * Microsoft OLE DB Provider for DB2
 * Microsoft OLE DB Provider for DB2

-



This article was previously published under Q278242



SYMPTOMS
If the Microsoft OLE DB Provider for DB2 parameter for Default Isolation Level is set to Cursor Stability (CS), it could be incorrectly mapped by the provider as Repeatable Read (RR) on DB2. This may lead to the incorrect type of locks being held on the DB2 tables, which may cause unexpected behavior.



RESOLUTION
To resolve this problem, obtain the latest service pack for SNA Server 4.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

215838 How to Obtain the Latest SNA Server Version 4.0 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Microsoft SNA Server version 4.0 SP2 and 4.0 SP3.

This problem was first corrected in SNA Server 4.0 Service Pack 4.

Additional query words: DB2OLEDB MAINFRAME MVS OS/390 DB2/MVS THREAD sp2 sp3

Keywords: kbbug kbfix kbsna400presp4fix kbqfe kbsna400sp4fix KB278242

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.