IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Explain about DB2 Locks in detail...


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ajaychandra

New User


Joined: 31 Mar 2005
Posts: 16
Location: Bangalore

PostPosted: Tue Apr 19, 2005 5:09 pm
Reply with quote

Hi

Explain abt DB2 Locks in detail ?...
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Thu Apr 21, 2005 10:58 am
Reply with quote

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
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Wed May 04, 2005 2:08 pm
Reply with quote

Hi Ajay,


Please refer to the following article for more detailed explanation of locks with db2 syntax. publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/r0008190.htm

Thanks,
Reddy
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts Include Group record based on detail ... DFSORT/ICETOOL 11
No new posts How to include header and some detail... DFSORT/ICETOOL 2
No new posts File compare, where file has header a... SYNCSORT 8
No new posts Check if any Detail records and extra... SYNCSORT 19
Search our Forums:

Back to Top