Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 18 Aug 2003 @ 14:46:41 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Sessions holding locks after query completes?
 
From:   McBride, Michael

I have been getting ETL sessions that do renames on tables getting blocked by end users "sessions" that are idle. In other words, the query that had an "access" lock on the table (via a view) is complete, the session is "idle" but the ETL sessions continues to be blocked. The blocking user session is initiated from Cognos Impromptu. When the user ends the session by closing the catalog, then the lock is released and the ETL is unblocked...

When a session is idle and a query has completed, including all response, shouldn't the locks for that query be released by the database???

This is what the logger utility is reporting...

   ---------------- AMP 0 REPORTS 2 LOCK ENTRIES -------------

                           GRANTED LOCK REQUEST(S):
   Tran: 16380 00AC04F2
   Host:  1025 Session:     4,64056 Mode: Ac   User: XXXXXXX
   Database: AEO_PRODDB           Table: DAILY_STORE_INVN_8DN

                          BLOCKED LOCK REQUEST(S):
   Tran: 16383 00937B5E
   Host:  2049 Session:     4,64207 Mode: EX   User: AEOBATCH

   Database: AEO_PRODDB           Table: DAILY_STORE_INVN_8DN

   User AEOBATCH is in the "BLOCKED" session Report
   User XXXXXX is in the "IDLE session Report


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