Subject | Read only - read committed Transaction Settings |
---|---|
Author | Alan |
Post date | 2010-02-04T23:11:29Z |
As far as I am aware, if I choose
ReadOnly with Isolation Committed (Read Committed)
in the IB_Transaction properties, I have selected the non blocking, least impact (as far as garbage collection impact is concerned) transaction setting.
I obviously don't need to write anything but I want this transaction to be longer than other transactions but I do not want it to hold back the transaction advancement.
IBO says (Table Locking!!!) and (No Rec Version !!!!) as warnigns on the other isolation levels.
So - assuming this is correct, what does this translate to in TPB settings?
isc_tpb_read, isc_tpb_consistency ?
or isc_tpb_read, isc_tpb_read_committed?
or some other combo
thanks
Alan
ReadOnly with Isolation Committed (Read Committed)
in the IB_Transaction properties, I have selected the non blocking, least impact (as far as garbage collection impact is concerned) transaction setting.
I obviously don't need to write anything but I want this transaction to be longer than other transactions but I do not want it to hold back the transaction advancement.
IBO says (Table Locking!!!) and (No Rec Version !!!!) as warnigns on the other isolation levels.
So - assuming this is correct, what does this translate to in TPB settings?
isc_tpb_read, isc_tpb_consistency ?
or isc_tpb_read, isc_tpb_read_committed?
or some other combo
thanks
Alan