Does Datastage take advantage of Connection Pooling?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
SPA_BI
Premium Member
Premium Member
Posts: 36
Joined: Tue Aug 29, 2006 8:01 pm
Location: Melbourne

Does Datastage take advantage of Connection Pooling?

Post by SPA_BI »

Hi,

I am using Datastage version 7.5.1, with an Oracle 10g database. Oracle 10g uses connection pooling. Can this feature be used from DataStage?

If so - how?
from SPA_BI
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

AFAIK, connecting pooling is transparent to the 'poolie'. So, any application, DataStage included, will just connect and Oracle will manage the pool.
-craig

"You can never have too many knives" -- Logan Nine Fingers
SPA_BI
Premium Member
Premium Member
Posts: 36
Joined: Tue Aug 29, 2006 8:01 pm
Location: Melbourne

Post by SPA_BI »

great - thanks for the clarification :)
from SPA_BI
Post Reply