|
View previous topic :: View next topic
|
| Author |
Message |
ksikdar
New User
Joined: 30 Jun 2006
Posts: 13
|
|
|
|
Hi all,
How can we change the isolation level??? |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
You need to provide more info. |
|
| Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006
Posts: 771
Location: Germany
|
|
|
|
Hi !
Use the CHANGE ISOLATION LEVEL Command.
This changes the way that DB2 isolates data from other processes while a database is being accessed.
Isolation level changes are not permitted while connected to a database with a type 1 connection. The back end process must be terminated before isolation level can be changed
Regards, UmeySan |
|
| Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark
|
|
|
|
| If you are asking about the programs executed in the batch jobs. You can change the ISOLATION parameter while during BIND. If your question is related to DB2 LUW then i dont have any idea about that. Thanks |
|
| Back to top |
|
|
|
|
