CS is the best one to choose for most applications. You should choose it at
bind time on your packages. The dynamic sql packages
use CS and sometimes escalate to RS.



Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"Stephane
Paquette "
<db2udbdba-ezmlms To
hield-x91780387.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

05/28/2004 11:00 Subject
AM Isolation level










Hi,

I need advices on the best practice using isolation level.
In Oracle there is no choice and in DB2 UDB (813) there are several
choices.

From what I have read, Cursor Stability seems to match what we are used to
with Oracle.

Is it a good practice to specify it at database creation ?
Any specific advices on dealing with that ?


Thanks

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 poste 7470 stephane.[Email address protected]
<mailto:stephane.[Email address protected]



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]



DB2 & UDB email list listserv db2-l LazyDBA home page