RE: We have a mystery

Lots of good ideas but in this case the file is only used in one process, it has not touched by anything else anywhere else on the system. It is a file we download nightly from a 3rd party as a csv, place in the ifs, use CPYFRMIMPF to move up to a DB2 work table, then read that work table in this RPG app to map and post updates to our production DB2 tables. The time between receiving the file and running the CPYFRMIMPF and calling the RPG is about 5 minutes. And just before the call to the RPG a CPYF *PRINT of the DB2 work table shows it has data. We have some other things to try tonight

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
Sent: Friday, October 06, 2017 1:41 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: We have a mystery

On 10/6/2017 1:25 PM, Mike Cunningham wrote:

No solution to the mystery yet.

OK. Assume that this CL and this RPG program are doing exactly the same thing at night and during the day. This would mean that there is something else running at night - after this CL - that is undoing / deleting / rebuilding the destination file.

What runs in the night schedule /after/ this CLP?

Conversely, is there something extra that runs during the day that is not being run at night? Maybe even a 'close of business' job that runs hours after the CLP runs?

--
--buck


--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD

________________________________
This email may contain confidential information about a Pennsylvania College of Technology student. It is intended solely for the use of the recipient. This email may contain information that is considered an “educational record” subject to the protections of the Family Educational Rights and Privacy Act Regulations. The regulations may be found at 34 C.F.R. Part 99 for your reference. The recipient may only use or disclose the information in accordance with the requirements of the Federal Educational Rights and Privacy Act Regulations. If you have received this transmission in error, please notify the sender immediately and permanently delete the email.