MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2012

AW: Tracing Physicial File R/W Actions



fixed

All changed made by a trigger are rolled back, if:
1. Commitment Control is started with the default commitment scope *ACTGRP
and the trigger is running in the same activation group as the program that
modified the base table. (That's why it is recommended to create trigger
programs with Activation Group *CALLER)
2. Commitment Control is started with commitment scope *JOB. Data are rolled
back independent of the activation group in which the trigger program is
performed.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von rob@xxxxxxxxx
Gesendet: Thursday, 13.9 2012 20:12
An: Midrange Systems Technical Discussion
Betreff: Re: Tracing Physicial File R/W Actions

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.







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