Re: commitment control and actgrp's

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Just to clarify...

Commitment control is commitment control in Db2 for i.

Doesn't matter if you are using RPG's op-codes, SQL or a mix of both.

The only real difference is that if you issue an SQL DML statement, and
there is no currently active commitment definition, then the system starts
one automatically.

In other words, when using SQL, the STRCMTCTL is run automatically if
needed.

Charles



On Wed, Jun 5, 2024 at 9:23 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx> wrote:

> so pretty basic question (unfortunately I don't know the answer)
>
> in db2 commitment control (not sql), if a commitment control boundary is
> started, and a file in a different actgrp is attempted to be
> written/updated/deleted, will an error occur?
>
> In other works, does nonSQL commitment control carry across actgrps?
>
> When I say nonSQL I mean STRCMTCL command starts the cc and it is not
> defined at the sql tables cc definition.
>
> tia
>
> Jay
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.