Re: when was the last modification to a files data? -- MIDRANGE-L

Thanks Luis, I have a saved copy of Rob's post that I made back in 2009.
Saved it along with so much other stuff from this list that I've never been
able to put into practice but still makes good readin. The problem I'm
trying to solve is in production. I have no access to the lpar and no way
of modifying anything. I have had the right to place a couple of CPYF as
my BEFORE and AFTER on a test machine. Feel like I'm living in the stone
age. Same tools available.

2012/7/23 Luis Rodriguez <luisro58@xxxxxxxxx>

Dave,

Could you solve your problem? I was thinking that, if there is a pressing
need to get more info and journaling is not allowed, you could create some
small SQL triggers (AFTER INSERT and/or AFTER UPDATE) that would write, to
a control file, things like key fields and a timestamp. After your
debugging is finished, just disable and or delete them.

FWIW, Rob's post can be found here:
http://archive.midrange.com/midrange-l/200908/msg00887.html

Best Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--

On Fri, Jul 20, 2012 at 1:04 PM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

Thanks, Luis, Vern
I believe I have the post you mentioned saved somewhere. But its only
interest is personal for me. There'd be little chance of journaling
being used with our CMS (current management situation:-))

2012/7/20 Luis Rodriguez <luisro58@xxxxxxxxx>:
> Dave,

If some changes, say, the TEXT description of the file, the last

modified

date changes, although the data records by themselves haven't been

modified.

If possible, I would suggest, as other have done, the use of journals.

Some

time ago Rob Berendt wrote a real nice post that expressed in a very

nice

and succinct way the use of journaling. If interested I can dig it for

you,

as I'm sure I have it archived somewhere (it really was a nice intro,

and I

wanted to show it to my coworkers)

Best Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--

On Fri, Jul 20, 2012 at 11:28 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

Thanks all, I'm seeing a last modification time at 01:07:15 this
morning, yet the jobs I'm interested in finished before that time. Can
I be sure that this means another job modified the data in the file or
could this mean something else? Unfortunately, we have no
journalization and there's not even any kind of timestamp.

2012/7/20 Charles Wilt <charles.wilt@xxxxxxxxx>:

Yes, at the bottom..

Member List
Source Creation Last Change
Deleted
Member Size Type Date Date Time
Records Records
CUSTOMP 48275456 07/09/10 04/12/12 15:07:29
208796 342

HTH,
Charles

On Fri, Jul 20, 2012 at 9:17 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

Hi,

Have a file produced by an overnight job J from a file PF1. Its
records should correspond with a report generated in overnight job

K,

also from the file PF1. But they don't. There are several other

jobs

that run between jobs J and K. I'm pretty sure that PF1 is not the
same when job K runs as it was in job J. Does DSPFD have any way of
telling when the last record was added or modified in PF1?
Thanks
--
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.

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