We have a single job where we have multiple stages to load datasets into Oracle 10.
Individually each one of these pairs of stages will run, but when we get 50 in a single job we get this fatal error :
main_program: APT_PMListenerPort: socket() call failed: Too many open files
We can run a job with 10 pairs of dataset to Oracle stages.
We are very new to DataStage and are wondering if there is a configuration setting somewhere that we need to tweak.
Thanks,
main_program: APT_PMListenerPort: socket() call failed: Too
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Check with your Oracle DBA to determine the maximum number of Oracle listeners that have been configured. This will be a hard upper limit for your (system-wide) number of simultaneous connections.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: main_program: APT_PMListenerPort: socket() call failed:
Hi sd,sd wrote:We have a single job where we have multiple stages to load datasets into Oracle 10.
Individually each one of these pairs of stages will run, but when we get 50 in a single job we get this fatal error :
main_program: APT_PMListenerPort: socket() call failed: Too many open files
We can run a job with 10 pairs of dataset to Oracle stages.
We are very new to DataStage and are wondering if there is a configuration setting somewhere that we need to tweak.
Thanks,
were you able to resolve this issue?