DataStage to Oracle connection establishment taking moretime
Posted: Mon Jan 27, 2014 7:57 am
Hi Team
simple datarule in Information Analyzer is taking more time when comapared to oracle query executed in oracle query window.
for ex: If i ran oracle query in query window it takes 1 min time to retrive results.Same query i executed through IA it is taking 21 min to finshed the job.
I did some analysis on datastage director log and found that
To establish a connection from oracle to Datastage is taking more time around 25min for small amount of data.If there is huge amount of data connection establishment taking hours of time and job get aborts.
Is there any property to reduse connection establishment from Datastage to oracle.Below is the .odbc.ini file entry.
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora25.so
Description=Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=plgmtiw2.na.gmacfs.com
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=UID
password=PWD
PortNumber=1521
ProcedureRetResults=0
SID=tiw2
UseCurrentSchema=1
Please help me to getrid of this issue.
Thanks in Advance
simple datarule in Information Analyzer is taking more time when comapared to oracle query executed in oracle query window.
for ex: If i ran oracle query in query window it takes 1 min time to retrive results.Same query i executed through IA it is taking 21 min to finshed the job.
I did some analysis on datastage director log and found that
To establish a connection from oracle to Datastage is taking more time around 25min for small amount of data.If there is huge amount of data connection establishment taking hours of time and job get aborts.
Is there any property to reduse connection establishment from Datastage to oracle.Below is the .odbc.ini file entry.
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora25.so
Description=Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=plgmtiw2.na.gmacfs.com
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=UID
password=PWD
PortNumber=1521
ProcedureRetResults=0
SID=tiw2
UseCurrentSchema=1
Please help me to getrid of this issue.
Thanks in Advance