Hmm - that brings up an interesting question.
Does the rollback appear on the journals?
Programmer/Analyst, Direct Response
"If you're going through Hell, keep going" - Winston Churchill
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, September 13, 2012 1:56 PM
To: Midrange Systems Technical Discussion
Subject: Re: Tracing Physicial File R/W Actions
Yes, check the journals and journal receivers. One question, are they forgetting to COMMIT transactions? I once wrote a program that forgot that. Hey, data's there! Sign off, data's gone!? Didn't commit, so it did a rollback.
Back before you started journalling, programs would blow if you tried to update them with SQL and you didn't change the default to not use commitment control. Now you're journalling. So you don't get that message. But you also aren't committing your transactions. So it rolls them back.
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
Kendallville, IN 46755
From: Brian Piotrowski <bpiotrowski@xxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion (midrange-l@xxxxxxxxxxxx)"
Date: 09/13/2012 01:47 PM
Subject: Tracing Physicial File R/W Actions
Sent by: midrange-l-bounces@xxxxxxxxxxxx
We have a physical file that we are having problems retaining data. For
some reason, data is being written to the system, but at random times it
will delete a random amount of records.
All of the programmers swear that it's nothing they have created that is
deleting the records. So with that said, is there any type of a
trace/audit that would show me all of the read/writes performed on a
We tried to set up a monitor in Navigator, but it doesn't appear to have
worked. Anybody else have a clue on how to track changes in a PF?
Assistant Mgr. - I.T.
Simcoe Parts Service, Inc.
Ph: 705-435-7814 x343
Please consider the environment. Don't print this e-mail unless you really
The information contained in this communication is confidential and
intended only for the use of those to whom it is addressed. If you have
received this communication in error, please notify me by telephone
(collect if necessary) and delete or destroy any copies of it. Thank