Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 07 Mar 2000 @ 02:13:53 GMT

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

Subj:   Re: Hung up session
From:   Bill Grenwelge

You may have what is commonly referred to as a 'ghost session'. Basically Teradata thinks the session is still there but in reality is not. The only way we have ever been able to get rid of it was by taking a restart on our Teradata system. You may also want to try releasing the lock on the table first by 'release lock on dbname.tablename, all, overide; This may take care of the lock on the system; if not then you will need to force a restart on your Teradata system.

Bill Grenwelge

  <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