CRPence on Thursday, May 22, 2014 4:07 PM wrote:
On 22-May-2014 15:43 -0500, Justin Taylor wrote:
I just noticed that my journal receivers have started capturing
before images for updates. I'm not sure what changed to cause
this, but I'd like to change it back. I checked CHGJRN, but I
can't see any setting there. Can someone point me in the right
<<SNIP>> When Commitment Control is active for an UPDATE of a
database file row, the Before-image will appear irrespective the
IMAGES() setting, in order to enable recovery [ROLLBACK] instead
of only applying forward changes [i.e. COMMIT].
I think you hit on it. I went through the journal receivers to
see what tables had before images and they're all ones with CASCADE
triggers. I imagine that falls into the same category as commitment
control (i.e. it ignores the PF setting and does both).
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact