Search found 6 matches

by themixedup1
Sun Nov 22, 2015 8:39 pm
Forum: General
Topic: 40503 A call to an OLE server has failed
Replies: 2
Views: 6511

Any update?

Any update on this? I'm not able to launch DataStage Director or DataStage Manager since I updated my machine with Office 2013. I would like to not have to re-image but this seems to be where I'm going.
by themixedup1
Wed Oct 07, 2009 8:33 am
Forum: General
Topic: Datastage Scalability
Replies: 0
Views: 866

Datastage Scalability

I'd like to know if anyone is running multiple datstage servers in a semi clustered environment. Like having 30 table loads run from one server and having another 30 table loads run from another server. And they sort of "see" each other in the process. So it would be like server A tells Se...
by themixedup1
Wed Oct 07, 2009 8:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Database Connection
Replies: 4
Views: 1977

Re: Oracle Database Connection

In my experience, Datastage does not drop the connections to the servers instantly. It pulls through the data and leaves the connection open anywhere from 30 secs to 5 mins. Depending on what else it is processing. I've seen them drop faster from SQL Server but they seem to drop slower from Oracle d...
by themixedup1
Tue Oct 06, 2009 1:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connection Pooling
Replies: 5
Views: 2936

I'm not entirely sure but I was asked to find out if Datastage could invoke connection pooling since we are getting time out expired from the Oracle server so we would like to leave 100 connections open so that datastage doesn't have to initiate a connection each time. It can just pull on that's ope...
by themixedup1
Tue Oct 06, 2009 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connection Pooling
Replies: 5
Views: 2936

Re: Oracle Connection Pooling

Oh and I know that the server can handle the pools from the oracle side but I want to be able to manage them from Datastage on the client side.
themixedup1 wrote:I'm trying to connection pool for an Oracle Client read/write not connection pooling on the oracle server using parallel stages. Is this possible?
by themixedup1
Tue Oct 06, 2009 11:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connection Pooling
Replies: 5
Views: 2936

Oracle Connection Pooling

I'm trying to connection pool for an Oracle Client read/write not connection pooling on the oracle server using parallel stages. Is this possible?