Re: committment control and file changes

Record not re-read after the change rolled back?

On Wed, May 30, 2012 at 4:49 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

I agree, but I am arguing with other pgmrs here who swear that chgs to LF's don't roll back, but chgs to the based-on PF will roll back.

I would like someone on this BBS to explain how that is possible??



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Wednesday, May 30, 2012 5:25 PM
To: Midrange Systems Technical Discussion
Subject: Re: committment control and file changes

If a logical is just a SQL View and an SQL Index in one object and the
physical file it is based on is rolled back, why wouldn't the view and
index over the physical have the same values? It is just a projection
of the physical file.

On Wed, May 30, 2012 at 4:14 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

Yes, but...

If a PF is journaled, will a record update to a LF (based on that PF) roll back under CM in the same manner that an update to the PF would?

Thanks for response!

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Wednesday, May 30, 2012 5:00 PM
To: Midrange Systems Technical Discussion
Subject: Re: committment control and file changes

Joel

Have you looked at the help text of STRCMTCTL? It mentions some
requirements - among them, the file which will be processed under
commitment control must be journaled. There is NO journaling of LFs - or
of OPNQRYF or anything other than PFs, as far as files go.

OPNQRYF is not a real file - it is a virtual access path, one could say
- no data contained therein, only a PATH to the data, known as an ODP or
open data path.

Likewise, LFs are only an access path.

You should also look at the STRJRNPF command - more information there.

You should also look at the COBOL reference to see how to specify using
commitment control on a file - in RPG it is on an F-spec - I don't know
the equivalent.

It's all in the manuals at Infocenter - this is a pretty big topic, much
going on around what might seem a simple question!!

HTH
Vern

On 5/30/2012 3:16 PM, Stone, Joel wrote:

Physical file changes under commitment control can be rolled back for errors.

Do Logical files behave the same way ie the underlying PF would roll back the same way that direct PF updates would?  Or are there some restrictions on LF's that would cause programmers to use the LF to read the PF by primary key and update the PF directly?

Do OPNQRYF's behave the same way as PF's also?  Ie will the based-on PF roll back on an error while under commitment control?

Does the file output method matter?  Ie if a file is opened as OUTPUT vs UPDATE would both of these behave the same ?  ie rollback on error under CC?

Some pgmrs here claim that PF updates roll back nicely, whereas LF updates do NOT roll back.  Is this possible?  (assuming all files are journalled properly and such)

Thanks!





______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


________________________________________________________________________
This inbound email has been scanned for all viruses by the MessageLabs SkyScan
service.
________________________________________________________________________

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


________________________________________________________________________
This inbound email has been scanned for all viruses by the MessageLabs SkyScan
service.
________________________________________________________________________

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.