DS created database connections

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
simc
Premium Member
Premium Member
Posts: 16
Joined: Wed Jul 22, 2015 12:10 pm

DS created database connections

Post by simc »

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
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

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?
Post Reply