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
 

 

Locking types

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vamseepotti

New User


Joined: 21 Oct 2003
Posts: 45

PostPosted: Fri Feb 20, 2004 3:44 pm    Post subject: Locking types
Reply with quote

What r the Locking types in DB2? Explain?
Back to top
View user's profile Send private message

gv_narayana_rao

New User


Joined: 21 Feb 2004
Posts: 10

PostPosted: Sat Feb 21, 2004 6:22 pm    Post subject:
Reply with quote

What r the Locking types in DB2? Explain?

Exclusive
Share
Update
Intent

Exclusive - only one user can read/write/update
Share - Only one user can update/write. Others r allowed to read
Update - (i will get u that later)
Intent - These r like indicators. If a job is using some table say "A"
and other job want to access the same. This lock jus says about the status of the table. That is it gives information about which job is currently using that and for what sort of operation and all related stuff.
Intent locks r further classified into different categories.
(I will get u the other information tommorrow).


I hope this will help u...
Back to top
View user's profile Send private message
franclin

New User


Joined: 23 May 2003
Posts: 11
Location: Chennai, India

PostPosted: Sun Feb 22, 2004 12:44 pm    Post subject: Locking Types
Reply with quote

Hi,

There are four types of locking is available
ROW LOCK
PAGE LOCK
TABLE LOCK
TABLE SPACE LOCK

NOTE: ROW LOCK is introduced by DB2 version 4.

Thanks & Regards
Suman.
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 Types of variables REXX tvinodkumar7 TSO/ISPF 2 Wed Aug 26, 2015 6:57 pm
No new posts DB2 10.1 Share level locking and Sele... Mary Lewis DB2 1 Wed Apr 15, 2015 9:51 pm
This topic is locked: you cannot edit posts or make replies. Locking question VarunJ1991 IMS DB/DC 1 Mon Mar 11, 2013 9:17 pm
No new posts Personal Comm. - User Defined Transfe... Div Grad IBM Tools 6 Wed Mar 06, 2013 2:06 am
No new posts GDG Locking after reaching maximum limit riteshsingh92 JCL & VSAM 17 Thu Feb 07, 2013 1:56 pm


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