View previous topic :: View next topic
|
Author |
Message |
ajaychandra
New User
Joined: 31 Mar 2005 Posts: 16 Location: Bangalore
|
|
|
|
Hi
Explain abt DB2 Locks in detail ?... |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
A lock is the mechanism that controls access to data pages and tablespaces.
The three types of locks are shared, update and exclusive.
DB2 imposes locks of four differing sizes: pages, tables, tablespace and for indexes subpage.
Attribute of Locks
Object : How much data is marked ?in-use?
Duration : How long is the lock needed (The lock duration are the lengths of time a lock is held. )
Mode : How severe is the lock ( The type of access allowed for the lock owner as well as the type of access permitted for concurrent users of the locked object. )
------------Hope this helps you-------------
Regards,
Priyesh |
|
Back to top |
|
|
ovreddy
Active User
Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
|
|
Back to top |
|
|
|