RE: Tracing Physicial File R/W Actions

Hmm - that brings up an interesting question.
Does the rollback appear on the journals?

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill


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


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Brian Piotrowski <bpiotrowski@xxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion (midrange-l@xxxxxxxxxxxx)"
<midrange-l@xxxxxxxxxxxx>,
Date: 09/13/2012 01:47 PM
Subject: Tracing Physicial File R/W Actions
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Hi All,

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
physical file?

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?

Thankee-sai!

/b;

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Brian Piotrowski
Assistant Mgr. - I.T.
Simcoe Parts Service, Inc.
Ph: 705-435-7814 x343
Fx: 705-435-5029
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
http://www.simcoeparts.com

Please consider the environment. Don't print this e-mail unless you really
need to.

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
you!