Exclusive lock waiting

Connectivity
Highlighted
Enthusiast

Exclusive lock waiting

Hi All, 

 

There is batch job locking  exclusively on the table .There are querygrid jobs trying to access the same and table and they get blocked for many hours .

 

Can anyone suggest how to avoid this situation .

 

thanks,

Suri


Accepted Solutions
Teradata Employee

Re: Exclusive lock waiting

By default, no. An UPDATE requires a WRITE lock.

DDL generally uses exclusive locks, and an application can request an exclusive lock.

1 ACCEPTED SOLUTION
3 REPLIES
Teradata Employee

Re: Exclusive lock waiting

Why does the batch job need an exclusive lock? Perhaps dropping and re-creating secondary or join indexes, or doing ALTER of some sort?

 

You may need to consider changing the table/index structure and/or the maintenance approach so that exclusive locks will not be required.

Enthusiast

Re: Exclusive lock waiting

An update is happening on this table .So is there an exclusive lock required for an update ?

Teradata Employee

Re: Exclusive lock waiting

By default, no. An UPDATE requires a WRITE lock.

DDL generally uses exclusive locks, and an application can request an exclusive lock.