Locking Levels

[Rahulbatra]

I want to know about the locking levels available in DB2. If someone could mention it here it would be of great help.

[sammy]

I know that for sure PAGE and TABLE are the locking levels available in DB2. But I doubt whether TABLESPACE is also a locking level available in DB2. Someone has to clarify this.

[Rahulbatra]

The locking levels available in DB2 are PAGE, TABLE and TABLESPACE. You can lock in any of the three levels in DB2 database.

[Adrian]

The available locking levels in DB2 are PAGE, TABLE and TABLESPACE. Hope you want to know about this. Let me know if you have any other query.