Locking types

vamseepotti · New User Joined: 21 Oct 2003 Posts: 45

What r the Locking types in DB2? Explain?

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...

franclin · Posted: Sun Feb 22, 2004 12:44 pm

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.