DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
simc



Group memberships:
Premium Members

Joined: 22 Jul 2015
Posts: 14

Points: 185

Post Posted: Thu Jul 16, 2020 11:40 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Oracle DB
Hi All, I'm getting complaints from my DBA about too many database connection being created in my jobs and slowing down the servers. I went through a number of steps that I thought might reduce this number:

- swithced processing from Parralel to Sequential
- reduced to one node in the config file

We've seen no change in the number of database connections.

Any thoughts would be appreciated.

Charles

[/img]
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1310

Points: 8608

Post Posted: Sun Jul 19, 2020 3:17 pm Reply with quote    Back to top    

are you doing a read or a write action?

Partitioned Read?

Anything in your SQL statement to pump up the connections?

Nodes in the config file will not matter. You can drop the Oracle Connector stage to sequential mode vs parallel, but, you have to look at those settings.

Is this a Multi Instance job?
Do you have a "before SQL" statement or a before job routine that is also establishing a connection?
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours