DSXchange

I had a talk with my DBA and he has shown that there is no limit restrictions from his end. Also, meanwhile I created one more Datastage project (project_2) in Dev env and copied the job from project_1 to project_2. I am able to run the job in both projects at same time without any error (utilizing ...

Paul,

Yes your are correct I am doing a partitioned read with 8 nodes. My datastage job is having 20 Oracle connectors pointing to same database. So how can I figure out the problem that oracle is not allowing more connections (steps would be helpful)?

Sorry.We are not in a grid.

If it was problem with the listener or TNS entry, then it shouldn't have worked when number of nodes is 8. In my case, the job is running successfully when node count is 8,only when the node count is more OR when I run multiple jobs, then only i'm facing the issue.

Hi , I've got average Datastage skills. So below issue which i'm facing may be a silly one. I'm getting the below error when I'm increasing the number of nodes or run multiple jobs. When number of nodes is 8, the job is running fine. But once I increase the number of nodes to 10 or when I run multip...