On 21-Feb-2014 13:18 -0800, CRPence wrote:
On 21-Feb-2014 12:27 -0800, Gord Hutchinson wrote:
Is this a recent change? I was always under the impression that
you could only use one journal in a commitment definition.
FWiW: Beyond the doc links offered in the above quoted message
[though snipped above, so refer to
> for those
links], see this additional doc link for a consideration about
difference in operation between _same journal_ and otherwise:
IBM i 7.1 Information Center -> Database -> Programming -> Database
programming -> Managing database files -> Recovering and restoring your
database -> Recovering data in a database file -> Ensuring data
integrity with commitment control
_Usage notes: Commitment control_
You can open logical files for output under commitment control when
underlying physical files are journaled to different journals. ...
However, the checks for violations are deferred if a record change
affects underlying physical files that are journaled to the same
journal. If the record change affects underlying physical files that are
not journaled to the same journal, and it causes a duplicate key or
referential constraint violation, an error will occur during the
input/output operation. ...