DB2 - Problem description
Problem IC97244 | Status: Closed |
THE CONNECTION ISOLATION LEVEL IS NOT PRESERVED AFTER A TRANSACTION BUT RE-SET TO THE PRODUCT DEFAULT. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
You have a .NET application that, in the connection string specifies the isolation level wanted for a connection like in: IsolationLevel=RepeatableRead; If an explicit transaction is started, with its own TX level isolation, once completed, the connection isolation level is not put back to the level specified in the connection string (RepeatableRead, in the example) but instead it becomes CommittedRead. which would be default if no isolation level was specified in the connection string. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 10. * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 Version 9.7 Fix Pack 10. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC97248 IC97249 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.10.2013 11.11.2014 11.11.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |