Search found 6 matches

by snatarajan
Thu May 22, 2008 9:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Database Connection limit exceeded error
Replies: 11
Views: 5959

Hi there, Will appreciate if somebody help me in resolving this issue. Thanks Javed Hi Ray, If you are talking about database partition. So none of my tables are partitioned. But data stage job is using Auto option for partiotining the records at runtime. Thanks Javed Are you working with partitione...
by snatarajan
Wed May 21, 2008 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Database Connection limit exceeded error
Replies: 11
Views: 5959

Hi Ray,

If you are talking about database partition. So none of my tables are partitioned.

But data stage job is using Auto option for partiotining the records at runtime.

Thanks
Javed


ray.wurlod wrote:Are you working with partitioned tables?
by snatarajan
Tue May 20, 2008 10:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Database Connection limit exceeded error
Replies: 11
Views: 5959

Re: Database Connection limit exceeded error

I've just checked the job with single node.. but it's still creating somewhat double connections. Any clue that why it's behaving this way. Logically in one node it should create the same no of connections as the total of source+Target+Reference = 50 but it's creating around 97. Thanks Ray. Let me t...
by snatarajan
Tue May 20, 2008 8:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Database Connection limit exceeded error
Replies: 11
Views: 5959

Re: Database Connection limit exceeded error

Thanks Ray. Let me test the job with one configuration node. Can somebody help me in resolving this issue. I've no clue first of all that why Data Stage are creating 2 connection per Sybase OC or ODBC relational connections into the database. Let me guess: your configuration file specifies two proce...
by snatarajan
Mon May 19, 2008 9:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Database Connection limit exceeded error
Replies: 11
Views: 5959

I deleted the other three posts. Hope it'll be fine now. I thought this was your fourth post but it's actually your first as you've posted this in four different forums. Please don't do that, it doesn't help get you an answer faster and just causes problems maintaining a coherent conversation. I can...
by snatarajan
Mon May 19, 2008 7:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Database Connection limit exceeded error
Replies: 11
Views: 5959

Database Connection limit exceeded error

Hi there, I'm facing database server connection limit error while running the parallel job. I've around 40 lookups, 1 source and 1 target. I'm using Sybase OC & ODBC stage as the relational operators and my database is Sybase IQ. I've set the Database connection limit to 100. But the problem is ...