Teradata input stage locked by output stage
Posted: Wed Oct 20, 2004 8:54 pm
I'm working with Teradata plug-in stages, but I think the question applies to all databases.
I have a job executing an SQL that joins table A & B, do necesssary transform, and produce an output to insert back into table B through a database load. My job was hung, and database trace shows the load step was blocked and eventually timed out. It was released if I terminate my SELECT session.
Does Datastage starts the multiload stage before the SELECT stage complete? Is there any way to control the job so the load will not be initiated until the full SELECT is finished? Would changing to use Teradata fastexport stage to perform the SELECT help in this situation?
THanks.
Jennifer
I have a job executing an SQL that joins table A & B, do necesssary transform, and produce an output to insert back into table B through a database load. My job was hung, and database trace shows the load step was blocked and eventually timed out. It was released if I terminate my SELECT session.
Code: Select all
Teradata API stage --> TRANSFORM ---> Teradata multiload stage
(SELECT FROM A (INSERT)
WHERE NOT IN B)
THanks.
Jennifer