Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Explain about DB2 Locks in detail...

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Explain about DB2 Locks in detail...
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: 1452
Location: Chicago, IL

PostPosted: Thu Apr 21, 2005 10:58 am    Post subject: Re: DB2 Locks
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    Post subject:
Reply with quote

Hi Ajay,


Please refer to the following article for more detailed explanation of locks with db2 syntax. http://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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need a logic to validate the data in ... sandeep kumar302 COBOL Programming 17 Mon Feb 01, 2016 3:30 pm
No new posts GROUP - header data to be repeated in... Musab Ahmed DFSORT/ICETOOL 3 Mon Feb 01, 2016 11:36 am
No new posts Can someone explain me this JCL line ... PeterHolland JCL & VSAM 9 Sat Dec 12, 2015 7:22 am
No new posts Easytrieve Report: Advanced blank Lin... Raj Vatsav CA Products 6 Mon Jul 06, 2015 2:59 pm
No new posts Finding locks on z/OS DB2? Ed Goodman DB2 2 Fri Aug 22, 2014 11:55 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us