Database connections for around 200 Jobs
Moderators: chulett, rschirm, roy
Database connections for around 200 Jobs
Hi,
I have a sequencer which calls around 200 jobs in parallel. When I run the sequencer around 150 jobs are aborting due to Connect(eg. ORA-12518: TNS:listener could not hand off client connection) errors. Its not able to open more number of connections parallely. Do we need to change the hardware configurations or do we need to change the aptconfig file parameters to get rid of this error. Please advice.
Thanks
I have a sequencer which calls around 200 jobs in parallel. When I run the sequencer around 150 jobs are aborting due to Connect(eg. ORA-12518: TNS:listener could not hand off client connection) errors. Its not able to open more number of connections parallely. Do we need to change the hardware configurations or do we need to change the aptconfig file parameters to get rid of this error. Please advice.
Thanks
RK Raju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is an Oracle configuration. You need to sweet-talk your DBA into increasing the number of connections, and you'd better have some pretty convincing reasons.
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.
Jobs will need as many connections as you have DB stages. Yes, that is 'common' - what is uncommon is attempting to run 200 jobs at the same time. Unless you've ensured both your hardware and database resouces have been configured accordingly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Dear Chulett/Ray,chulett wrote:Jobs will need as many connections as you have DB stages. Yes, that is 'common' - what is uncommon is attempting to run 200 jobs at the same time. Unless you've ensured both your hardware and database resouces have been configured accordingly.
Thanks for your response. What could be possible hardware and database resources we need to configure to achieve the run of around 200 jobs in parallel.
Thanks.
RK Raju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
More, obviously.
However, maximum number of permitted connections is configured in Oracle, so you still need to convince your DBA that you need this many.
Can you not schedule your jobs differently, so that fewer connections are required at any one time? For example do some of your extraction earlier and into staging areas (Data Sets).
However, maximum number of permitted connections is configured in Oracle, so you still need to convince your DBA that you need this many.
Can you not schedule your jobs differently, so that fewer connections are required at any one time? For example do some of your extraction earlier and into staging areas (Data Sets).
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.
ray.wurlod wrote:More, obviously.
However, maximum number of permitted connections is configured in Oracle, so you still need to convince your DBA that you need this many.
Can you not schedule your jobs differen ...
We have observed that these connect errors are coming after replacing DRS stage with Oracle Enterprise stage in all the jobs(200). Will DRS stage be a better option in this case over Oracle Enterprise stage or Is our observation wrong.Please clarify.
ray.wurlod wrote:More, obviously.
However, maximum number of permitted connections is configured in Oracle, so you still need to convince your DBA that you need this many.
Can you not schedule your jobs differen ...
We have observed that these connect errors are coming after replacing DRS stage with Oracle Enterprise stage in all the jobs(200). Will DRS stage be a better option in this case over Oracle Enterprise stage or Is our observation wrong.Please clarify.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: