Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 19 Jun 2009 @ 07:52:23 GMT

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

Subj:   Re: Determine Lock in a Table
From:   DWellman

Hi Ayush,

To check a query whilst it is running use Teradata Manager, PMON or (if you're on TD 12) you can use the MonitorSession command. These will show you if the query is doing anything (increasing cpu, io's etc and changing spool space).

A question for you: in your last email you said " I first released the lock on the target table ". What do you mean by this ? There is no command to release an SQL lock on a table. Do you mean a Multiload or ARC lock ?



Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

  <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