MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2012

Re: Tracing Physicial File R/W Actions



fixed

This is a really a good question but I'm not sure... I hope the trigger is
not called on a rollback...

If you allow Trigger on rollback, than you are not sure that you will
really do a rollback.


On Thu, Sep 13, 2012 at 2:12 PM, <rob@xxxxxxxxx> wrote:

Does a trigger get called on a rollback?


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: Karl <k.mainville@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 09/13/2012 02:07 PM
Subject: Re: Tracing Physicial File R/W Actions
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Hi Brian,

Look at this.


http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Faddpftrg.htm

Add Physical File Trigger (ADDPFTRG)The trigger program can be specified
to
be called before or after a change operation occurs so this could help you
to find the job that is deleting your records.

I never used this command so I can't give you any trigger code example.
Maybe someone else have a sample program ?

Good luck.



On Thu, Sep 13, 2012 at 1:47 PM, Brian Piotrowski <
bpiotrowski@xxxxxxxxxxxxxxx> wrote:

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!

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







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact