Page 2 of 2
Posted: Wed Jul 23, 2008 8:53 am
by chulett
Have you
confirmed a timeout issue or is it just a belief? I for one haven't heard of a "3 minute timeout" - a 3 minute egg, sure, but timeouts are usually more in the 30 to 60 minute range. IMHO, 3 would just be crazy and would affect more than this one job.
Posted: Wed Jul 23, 2008 9:00 am
by satya99
Create Multiple Instance job
ODBC--->Transformer|---->Hashed File1
Posted: Wed Jul 23, 2008 9:20 am
by Sandeep.pendem
[quote="chulett"]Have you [b]confirmed[/b] a timeout issue or is it just a belief? I for one haven't heard of a "3 minute timeout" - a 3 minute egg, sure, but timeouts are usually more in the 30 to 60 minute range. IMHO, 3 would just be crazy and would affect more than this one job.
[/quote]
Yes, Its timeout issue since most of our jobs which are reading data from ODBC stage(Sql server 2005) are unable to run after 3-4 mins time. so potentially this is a timeout issue.
We are using ODBC driver version 4.2 with sql server 2005.
Thanks
Posted: Wed Jul 23, 2008 4:18 pm
by Sandeep.pendem
[quote="Sandeep.pendem"][quote="chulett"]Have you [b]confirmed[/b] a timeout issue or is it just a belief? I for one haven't heard of a "3 minute timeout" - a 3 minute egg, sure, but timeouts are usually more in the 30 to 60 minute range. IMHO, 3 would just be crazy and would affect more than this one job.
[/quote]
Yes, Its timeout issue since most of our jobs which are reading data from ODBC stage(Sql server 2005) are unable to run after 3-4 mins time. so potentially this is a timeout issue.
We are using ODBC driver version 4.2 with sql server 2005.
Thanks[/quote]
Does anyone has any thoughts on what change we should make inorder to get rid of this timeout stuff? I understand that there are lot of other solutions to overcome this problem, but the point here is its a simple sql query which would be commonly used with joins,etc. the datastage not handling the timeout is something which we want to resolve ..Any help is highly appreciated
Posted: Wed Jul 23, 2008 4:20 pm
by Sandeep.pendem
[quote="Sandeep.pendem"][quote="chulett"]Have you [b]confirmed[/b] a timeout issue or is it just a belief? I for one haven't heard of a "3 minute timeout" - a 3 minute egg, sure, but timeouts are usually more in the 30 to 60 minute range. IMHO, 3 would just be crazy and would affect more than this one job.
[/quote]
Yes, Its timeout issue since most of our jobs which are reading data from ODBC stage(Sql server 2005) are unable to run after 3-4 mins time. so potentially this is a timeout issue.
We are using ODBC driver version 4.2 with sql server 2005.
Thanks[/quote]
Does anyone has any thoughts on what change we should make inorder to get rid of this timeout stuff? I understand that there are lot of other solutions to overcome this problem, but the point here is its a simple sql query which would be commonly used with joins,etc. the datastage not handling the timeout is something which we want to resolve ..Any help is highly appreciated