What is an intent lock ?
An intent lock is at the table level for a segmented tablespace or at the tablespace level for a non-segmented tablespace. They indicate at the table or tablespace level the kinds of locks at lower levels.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Can I use LOCK TABLE on a view ? 16.03.08
No. To lock a view, take lock on the underlying tables....What is lock escalation ? 14.03.08
Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has aquired more locks than specified in NUMLKTS. Locks should be taken on obje...How does DB2 determine what lock-size to use? 14.03.08
There are three methods to determine the lock-size. They are: 1. Based on the lock-size given while creating the tablespace 2. Programmer can direct the DB2...What happens when a thread cannot acquire a lock on an object? 25.05.07
If a thread attempts to execute a synchronized method or synchronized statement and is unable to acquire an object's lock, it enters the waiting state until the...What is an object’s lock and which objects have locks? 24.05.07
An object's lock is a mechanism that is used by multiple threads to obtain synchronized access to the object. A thread may execute a synchronized method of an o...What are lock objects? 26.03.07
Reason for Setting Lock: Suppose a travel agent want to book a flight. The customer wants to fly to a particular city with a certain airline on a certain day. T...How does thread synchronization occurs inside a monitor ? 26.01.07
The JVM uses locks in conjunction with monitors. A monitor is basically a guardian in that it watches over a sequence of code, making sure only one thread at a...What is lock escalation? 15.06.06
Lock escalation is the process of converting a lot of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a m...What happens when a thread cannot acquire a lock on an object? 07.03.06
If a thread attempts to execute a synchronized method or synchronized statement and is unable to acquire an object's lock, it enters the waiting state until the...What is an object’s lock and which object’s have locks? 07.03.06
An object's lock is a mechanism that is used by multiple threads to obtain synchronized access to the object. A thread may execute a synchronized method of an o...