Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 02 Jul 2009 @ 19:39:47 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Blocking processes in Teradata
From:   Victor Sokovin

  What interests me is whether any Teradata DBAs out there have experienced a tangible slow down in processing other sessions (unrelated to the block) when one session is blocking another session.  

Chaim, I had to re-read your original posting and noticed that you were talking about ODBC:

"I have macros that load into a certain table via an ODBC connection - sometimes after the macro begins, an MLOAD job loading to the same table begins and this causes a blocking situation. The blocked MLOAD process is blocked already at the BEGIN MLOAD stage."

This ODBC aspect was not discussed in the subsequent postings. Perhaps it is important in your discussion with the local DBA but it is difficult for us to understand the role of ODBC connections in your ETL process. Could you perhaps describe it in more detail?


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023