DSXchange

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,

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.

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,

Hi sd,
were you able to resolve this issue?