Originally posted by: SystemAdmin

Hi friends...

What determines the maximum connection possible ?
and maximum connection recommended from DataStage(PX) to a DB2 ?
What values will determine this No: ?

Thanks
HS
HScolor=red:b263b878a4[/color:b263b878a4]color=cyan:b263b878a4[/color:b263b878a4]
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

This doesn't look like a 'DataStage TX' question.

jvanboga
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Hi All

Can we set the number of connection pools to a database in DataStage ?

Thanks
HS
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

If you are referring to DataStage TX there are settings in the mercator.ini file which control the min/max connections. From your Windows Start>Programs menu if you access the product via the "Mercator 6.x" menu entry you are using what is now known as DataStage TX. If you access the product via the "Ascential DataStage" menu and the first thing the Designer does is ask you to connect to a project, you are using DataStage and not DataStage TX. You need to re-post your question under the "DataStage" forum.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange