Database connections are active

suman27 · Post by **suman27** » Wed Apr 14, 2010 7:08 am

Hi,
I am reading the data from Message Queue and loading into API tables. I am calling through the sequencer and sequencer has five subjobs. There are 15 DB2 API stages used across three jobs. I have processed 1000 messages as 10 differernt loads of 100 messages each. After the successful load, I checked in the database. Almost 245 connections are still active. Number of node =1 . Since there are only 15 stages, I expected only 15 connections would be active at any point of time. Please let me know is there any configuration should be set to close the connections. Am I doing anything wrong in the setup? I could not find any similar posting earlier. Please help

ArndW · Post by **ArndW** » Wed Apr 14, 2010 7:39 am

Are all of these open connections to DB2 from DataStage and from this run? You certainly shouldn't have that many open from one DataStage run, as you've already stated with 1-node and 15 DB2 stages that is how many connections you should have. Is your Db2 partitioned?

suman27 · Post by **suman27** » Thu Apr 29, 2010 1:26 pm

ArndW wrote:Are all of these open connections to DB2 from DataStage and from this run? You certainly shouldn't have that many open from one DataStage run, as you've already stated with 1-node and 15 DB2 stages that is how many connections you should have. Is your Db2 partitioned?

Sorry for a late reply.
We stopped all jobs, and ran only one job which has 15 DB2 stages and found out that there are 245 open sessions. This DB2 is database partitioned.

Regards,
Suman.