0 - 10 of 10 tags for lock

The Windows installation of Studio and Studio Express supports preconfigured preferences that can be provided during the installation process. The feature focuses on those preferences that pertain to database interactions.

Hi All,
Please consider a scenario:
A table (contains 10 records) is being loaded with some records (20 records).
It takes 5 mins to retrieve the records from the table.
While User 1 is running a select on the table , in parallel select User 2 runs an insert which inerts 1 records in 60 seconds.

Hi,
All of my table in a database is locked for insert/update/drop. When i run lokdisp command, i get following output. What does Mode: RHL mean in following output. The database is locked even after I restart the system using 'tpa stop' and 'tpa start'. How do I get out of this situation.
Thank you.

Issue description:
When a job that is loading an empty table through FastLoad Functionality (Teradata Connector) aborts, it causes the mentioned table to be left in an irrecoverable Lock state, which cannot be cleared using an empty FastLoad, and which only workaround is to drop and recreate the table.

Does fastLoad apply Exclusive lock on target table ? If not what type of lock is applied ?

Hi
In a script, at Session level the transaction isolation is set to RU (Read Uncommitted or ACCESS).
At table level I am overriding to READ lock for Table1 in a SQL select.
 
Now if there is already an INSERT / MERGE / UPDATE operation going on Table1 then it will be on WRITE lock. So the SQL with READ lock will wait. 

Hi,
 
Is there any way to measure performance impact on existing queries with enabling LockLogger?
 
I'm planning to enable LockLogger in continuous mode to debug deadlock queries.
But I'm not sure the side-effect on perfomance of existing queries. Will is use CPU a alot? Many Disk I/O?
 

How can we get to know what type of lock is applied on a table
in teradata database, when when fire a query in TD SQL?

Is there any dbc table providing the information?

I have been looking for answers to a basic question on table partitioning in Teradata. Can someone please shed more light. Here it is -