Teradata Forums / Teradata / Partner software applications/questions / Teradata query not finishing when executed from DataStage / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 01:30:52 GMT20Teradata query not finishing when executed from DataStagehttp://www.teradata.com/teradataforum/Topic9355-12-1.aspxHello all,I have a developer running a process using Datastage 8A query is executed on Teradata but does'nt finish.From Pmon the session is idle and pe state is response. It stayed in this state all weekend.If I run the query outside of DS it executes in less than a minute and returns 21 mil rows.Any Ideas?thanks, TbobTue, 23 Oct 2007 11:06:58 GMTTBob