Hi,

We have 1 job running on our production which recieves file through ftp from a mainframe machine and initiates sql loader. But everytime, the sql loader goes inactive after inserting few thousand records..precisely 20k..while the file ftped has around 6-7 million records.


has any1 faced anything like this?

Would it be...the loader is being called before the ftp is complete...i tested to run sql loader while the ftp is on..it still loads..without any problem..:-(