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).