The maximum number of connections to Oracle is something set in Oracle, not in DataStage.
Sweet talk your DBA with a request to increase the maximum but, if I were the DBA, you would need to have a very good case. Can you not run fewer jobs at the same time? Maybe do some of your extractions ahead of time into staging areas (Data Sets)?
DataStage Connections Issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia