locking a DB2 table

bittu · New User Joined: 07 Jan 2007 Posts: 19 Location: Bangalore

Hi,

can anybody suggest me that how to lock a table in db2 to generate a contention issue.
actually the requirement is like that only, there are some fatal error messages which need to be validated. for this i need some mechanism to lock the table and finally when i run the program it will show that fatal error message about table contention.

thanks in advance,

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

Use the LOCK TABLE statement to override DB2’s rules for choosing initial lock attributes. Two examples are:

LOCK TABLE table-name IN SHARE MODE;
LOCK TABLE table-name PART n IN EXCLUSIVE MODE;

Executing the statement requests a lock immediately.

The bind option RELEASE determines when locks acquired by LOCK TABLE or LOCK TABLE with the PART option are released.