Teradata query not finishing when executed from DataStage
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Teradata query not finishing when executed... Expand / Collapse
Author
Message
Posted 10/23/2007 11:06:58 AM
Forum Guru

Forum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum Guru

Group: Forum Members
Last Login: 4/17/2008 10:56:01 AM
Posts: 58, Visits: 9
Hello all,
I have a developer running a process using Datastage 8
A 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, Tbob


Post #9355
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 2:46am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 8 queries. Compression Disabled.