1. LOCK TABLE table-name IN SHARE MODE;
ex - LOCK TABLE UPAD.EMPLOYEE IN EXCLUSIVE MODE;
2. LOCK TABLE table-name PART n IN EXCLUSIVE MODE;
ex- LOCK TABLE UPAD.EMPLOYEE PART 1 IN EXCLUSIVE MODE;
When the statement is executed, DB2 locks partition 1 with an X lock. The
lock has no effect on locks that already exist on other partitions in the
It seems that the lock gets released only when the program ends...i tried to run a select query on the same table which is locked by another program..but the select query is performed only when the program which has locked the table ends....
Okay then any info abt explicit row level locking...