Good morning,
I have an executable called DataExport (not that the name means much), but anyhow, it is a job that runs to call oracle stored procs which then export data out to a text file. Depending on which export is calling the DataExport, different stored procs are run. Exports 1, 2 and 3 all succeed in that the last thing DataExport does is once the file has completely come out of Oracle and is in the text file, the DataExport program moves the file to an Output folder.
The problem I am encountering is that Exports 4 & 5 produce very large files and take significantly longer (721499383 bytes in about 40 minutes compared with 75564 in about 2 minutes) and they don't ever get moved to the Output folder. I have put tracing into the executable to see what it is doing at the very end and there is nothing to indicate why it doesn't complete the job of moving the file to the Output folder. Here, for example, are the last four lines of the trace:
Code:
SVEInputTableClass::Setting field data. Getting next record
SVEInputTableClass::GetNextRecord. Getting next record
SVEInputTableClass::Setting field data. Getting next record
SVEInputTableClass::GetNextRecord. Getting next record
Prior to that are thousands of those exact same lines. So the question becomes, is there any setting in AIX that kills a pid or stops a pid if it hits a certain limit of memory or diskspace?