Level of Locking on a specific table



IBM's flagship relational database management system

Level of Locking on a specific table

Postby kk12345 » Mon Jan 03, 2011 8:05 pm

Dear Experts,

I read in the DB2 book that there are row level locking and table level locking exists.
And a developer or admin can also change the level of locking using the
ALTER TABLE [Table-Name] LOCKSIZE [ ROW / TABLE ]
LOCK TABLE [TABLE-NAME] IN [ SHARE / EXCLUSIVE ] MODE
above commands.

I would like to know the existing level of locking ( ROW / TABLE ] for tables in my application. Please let me know which system catalog table I need to query for ??
kk12345
 
Posts: 18
Joined: Sun Dec 26, 2010 6:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Level of Locking on a specific table

Postby GuyC » Tue Jan 04, 2011 4:39 pm

LOCKRULE in SYSIBM.SYSTABLESPACE

select tb.creator , tb.name, tb.dbname, tb.tsname, ts.lockrule
from sysibm.systables tb
join sysibm.systablespace ts on tb.dbname = ts.dbname and tb.tsname = ts.name
where tb.creator = 'xxxx' and tb.name = 'xxxxx'
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: Level of Locking on a specific table

Postby kk12345 » Thu Jan 06, 2011 8:18 pm

thanks GuyC. I understand about Lockrule.

I have posted few other Questions in DB2. please help me by answering them.

thanks in advance.
kk12345
 
Posts: 18
Joined: Sun Dec 26, 2010 6:26 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post