Tags for lock
Studio Preferences: Initialization and Locking
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.
studio studio express client preferences install lock v_tools
Dirty Reads
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.
dirty read lock
What is RHL lock mode
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.
lock locking lokdisp
TERADATA 13.10 - DATASTAGE 8.5 Issues with FastLoad functionality
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.
fastload issues error lock table lecked table
FastLoad lock Type
Does fastLoad apply Exclusive lock on target table ? If not what type of lock is applied ?
fastload lock lock type fastload lock fastload lock type
TD Lock Upgrade and Downgrade Options
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. 
teradata isolation level lock read access read uncommitted
Performance consideration in Enabling LockLogger
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?  
lock Lock Logger performance
How to lock set of tables used by Particular Session (Session Level Integrity)
lock session level integrity
Locking Information
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?
lock locking
Question on Partitioning:: Full table lock or only Partition Lock?
I have been looking for answers to a basic question on table partitioning in Teradata. Can someone please shed more light. Here it is -
deadlock partitioning table lock lock resource contention