O'Reilly logo

Teradata Database Administration – The Fundamentals by Thomas Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11 – Locking

“If you are planning for a year, sow rice; if you are planning for a decade, plant trees; if you are planning for a lifetime, educate people.”

-Chinese Proverb

The Four Major Locks of Teradata

Read Lock

Write Lock

Exclusive Lock

Access Lock

 

There are four locks used in the Teradata Database, and they are the Read, Write, Exclusive and Access Locks. This is an important concept that will soon have that bright light bulb in your brain lighting up.

The Read Lock

images

 

When a user runs an SQL Select statement, then Teradata automatically places a read lock on the table being selected from. Above, we can see that the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required