Re: commitment control and actgrp's

I just described it horribly

Jay

On Fri, Jun 7, 2024 at 10:34 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

yes Charles - completely aware of that - thanks for noting

Jay

On Wed, Jun 5, 2024 at 11:46 AM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

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.

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