Hello everyone.
We've got an ongoing issue to which I have not been able to find a solution.
We've got a process that executes an sql statement that extracts data into a temp file.
The process then does a CPYTOIMPF to create a csv file on the IFS using the data in the temp file.
When that completes, another command is run to distribute the report to users.
Every so often the IFS csv file cannot be found by the report distribution command.
When I check the timestamp of the IFS csv file, it shows that it was created before the failing command (as shown by the timestamp of the failed command in the joblog).
To address this issue, I added a five second delay before calling the distribution command, and it still fails every so often (ie. no change).
Has anyone seen this sort of behavior before? What is the solution?
Thanks in advance for any insights.
Walt
We've got an ongoing issue to which I have not been able to find a solution.
We've got a process that executes an sql statement that extracts data into a temp file.
The process then does a CPYTOIMPF to create a csv file on the IFS using the data in the temp file.
When that completes, another command is run to distribute the report to users.
Every so often the IFS csv file cannot be found by the report distribution command.
When I check the timestamp of the IFS csv file, it shows that it was created before the failing command (as shown by the timestamp of the failed command in the joblog).
To address this issue, I added a five second delay before calling the distribution command, and it still fails every so often (ie. no change).
Has anyone seen this sort of behavior before? What is the solution?
Thanks in advance for any insights.
Walt
Comment