ds_seqgetnext: Win32 error in ReadFile - Insufficient system
resources exist to complete the requested service.
in order to investigate the error we examined the memory usage and found that at the start of these 13 jobs around 11 gb of free memory is available and as the job progresses the free memory decreases steadily until the job completes. the final available memory just before the jobs completed was around 1.5 gb. after the jobs completed memory was returned to the system and free memory stood at 11 gb. i don't have the cpu usage yet, to analyze. Now i have the following questions about the memory usage.
1) why does the memory usage increase steadily as the job progresses should it not be constant, as we are processing record by record?
2) When sequential files are used as target stages, when is the data flushed to the disk from the memory? are there any parameters in datastage which control this?
And is there any thing else that i can try, to avoid the above mentioned error messages. I sometimes also get that error message when the system is not heavily loaded. Rebooting the server solves the problem.
![Smile :)](./images/smilies/icon_smile.gif)
Thanks
Dhiraj