Re: General ideas on researching deleted records

[Charles Wilt <charles.wilt@xxxxxxxxx>]

SQL would seem to be the most likely cause...

Guessing you don't journal your files...

If SQL was the cause, you may find evidence in the SQL Plan cache in IBM i
Navigator.

Charles

On Wed, May 13, 2015 at 3:43 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

> HI This is a general and long shot question.
>
> It seems we have lost 2 days of invoices from a particular file.
>
> How to research what caused this?
>
> Developers are the primary suspects of course or rather process of elim.
> while most
> devs would never do some of these I am trying to see what may have happened
> and how to locate any logs of these: by all means let me know if my
> thinking is completely
> wrong and how it should be looked for.
>
> MY thinking is records get deleted by a dev if there is
>
> 1.any program (rpg/cl ?)  that outputs to that file
> 2. A Cpyf to that file, overlaying blanks i guess.
> 3. command but a dltf would be halted bec logicals exist.
> 4. Upddta. this shop uses upddta a lot, not just developers. but then it
> has to be F23 and a lot of those.
>
> Thank you for any concrete info I acknowledge this is a fuzzy topic if this
> is fully off topic please remove.
>
> Thank you,
> Joe
> --
> 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.
>
>