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.

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 ?


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?
