LOCKSIZE ANY problem

Document ID : KB000014280
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Table LOCKSIZE display

Question:

When a Table lock occurred, if the Tablespace is defined with LOCKSIZE ANY, 

the request shows the Tablespace name as locked resource instead of the Table name. 

When the Tablespace is defined with LOCKSIZE PAGE or ROW or TABLE the correct Table 

name is showed as resource. 

Why is this?

Environment:
z/od DB2
Answer:

In DB2  

If you set the LOCKSIZE to TABLE, DB2 takes a table level lock and therefore the locked resource is a table, 

When you set it to ANY, DB2 sets the entire tablespace lock and therefore the locked resource is the 

tablespace/pageset.