|
|
| Author |
Message |
vamseepotti
New User
Joined: 21 Oct 2003
Posts: 46
|
|
|
|
| What r the Locking types in DB2? Explain? |
|
| Back to top |
|
 |
References
|
 Posted: Fri Feb 20, 2004 3:44 pm Post subject: Re: Locking types |
|
|
|
|
gv_narayana_rao
New User
Joined: 21 Feb 2004
Posts: 10
|
|
|
|
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 |
|
|
francis suman
New User
Joined: 23 May 2003
Posts: 11
Location: Chennai, India
|
|
|
|
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 |
|
|
|
|
