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