What is ROW LOCK and TABLE LOCK and how to implement them?

[Vibha]

Hello,

What is ROW LOCK & TABLE LOCK and how to implement them? Or if you can direct me, how can I perform ROW Lock and table Lock in DB2?

[m4mainframe]

AFAIK, you cannot control directly the lock in DB2 but indirectly you can try doing that but not completely as for that matter DB2 have IRLM which manages it and if you still want to try to manipulate it, you can try it but cannot guarantee it and for that you need to know every resource using the DB2 objects - ROW, PAGE, TABLE, TableSpace etc with the ISOLATION Level you provide in the BIND Card, also sometimes you code - WITH <isolation level> in the SQL Query itself in the COBOL program. Also, you code provide the default lock it can apply while creating the DB2 Objects - Table, TableSpace, I believe, am not sure.

[Anuj Dhawan]

This article provides and intresting read on: Understanding locking in DB2 Universal Database.

Hope this helps.

[Vibha]

Thanks m4mainframe and Anuj.