Search found 6 matches
- 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: 5958
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...
- 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: 5958
- 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: 5958
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...
- 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: 5958
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...
- 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: 5958
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...
- 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: 5958
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 ...